How to return and download Excel file using FastAPI?

by

You could set the Content-Disposition header using the attachment parameter, indicating to the browser that the file should be downloaded, as described in the answers here and here. Swagger UI will provide a Download file link for you to download the file, as soon as you execute the request.

headers = {'Content-Disposition': 'attachment; filename="Book.xlsx"'}
return FileResponse(excel_file_path, headers=headers)

To have the file viewed in the browser, one can use the inline, instead of attachment, parameter in the Content-Disposition header, as explained in the linked answers earlier. However, for the browser to be able to display the Excel file, one should set the correct media_type in the FileResponse (for Excel files see here), as well as .xlsx (or .xls) must be a known file extension to the browser (this is usually achieved through browser extensions/plug-ins).

More Related Contents:

  1. Export a list of stock prices to excel
  2. How to add both file and JSON body in a FastAPI POST request?
  3. Editing workbooks with rich text in openpyxl
  4. Reading Excel File using Python, how do I get the values of a specific column with indicated column name?
  5. append dataframe to excel with pandas
  6. .xlsx and xls(Latest Versions) to pdf using python
  7. Convert date from excel in number format to date format python [duplicate]
  8. Calling python script from excel/vba
  9. Merge rows based on value (pandas to excel – xlsxwriter)
  10. Write to StringIO object using Pandas Excelwriter?
  11. How to Upload File using FastAPI?
  12. Python openpyxl data_only=True returning None
  13. How to upload File in FastAPI, then to Amazon S3 and finally process it?
  14. What is the proper way to make downstream Https requests inside of Uvicorn/FastAPI?
  15. Insert row into Excel spreadsheet using openpyxl in Python
  16. How to display uploaded image in HTML page using FastAPI & Jinja2?
  17. How to post JSON data to FastAPI and retrieve the JSON data inside the endpoint?
  18. React not showing POST response from FastAPI backend application
  19. How to save an uploaded image to FastAPI using Python Imaging Library (PIL)?
  20. How to navigate through FastAPI routes by clicking on HTML button in Jinja2 Templates?
  21. How do I return an image in fastAPI?
  22. How to return a custom 404 Not Found page using FastAPI?
  23. How to write to an existing excel file without breaking formulas with openpyxl?
  24. Appending Pandas DataFrame to existing Excel document
  25. How to pass URL as a path parameter to a FastAPI route?
  26. FastAPI python: How to run a thread in the background?
  27. How to initialise a global object or variable and reuse it in every FastAPI endpoint?
  28. How do I send list of dictionary as Body parameter together with Files in FastAPI?
  29. Redirect to login page if user not logged in using FastAPI-Login package
  30. Using openpyxl to read file from memory

Leave a Comment