Quiero dar xlsx a pedido. Con el uso BytesIO y xlsxwriter , creo un archivo.
Usando el siguiente código, puedo descargar un archivo .txt vacío (!):
@router.get("/payments/xlsx", response_description='xlsx') async def payments(): """sss""" output = BytesIO() workbook = xlsxwriter.Workbook(output) worksheet = workbook.add_worksheet() worksheet.write(0, 0, 'ISBN') worksheet.write(0, 1, 'Name') worksheet.write(0, 2, 'Takedown date') worksheet.write(0, 3, 'Last updated') workbook.close() output.seek(0) return StreamingResponse(output) Si agrego headers={'Content-Type': 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'} este error en el navegador:
Unable to open file You may be having a problem connecting with the server, or the file that you wanted to open was corrupted.¿Cómo puedo arreglar esto?
Tienes que establecer el encabezado Content-Disposition en la respuesta.
@router.get("/payments/xlsx", response_description='xlsx') async def payments(): output = BytesIO() workbook = xlsxwriter.Workbook(output) worksheet = workbook.add_worksheet() worksheet.write(0, 0, 'ISBN') worksheet.write(0, 1, 'Name') worksheet.write(0, 2, 'Takedown date') worksheet.write(0, 3, 'Last updated') workbook.close() output.seek(0) headers = { 'Content-Disposition': 'attachment; filename="filename.xlsx"' } return StreamingResponse(output, headers=headers )