Download XLSX file with multiple sheets in Streamlit

[MichaelPinatton]

Hi there !

I’ve been experimenting with streamlit for a few days and trying to convert some scripts into apps.

It’s been interesting so far but I’ve hit a roadblock : I can’t find a way to download XLSX file from the app.

My script is based on pandas and is pretty easy :

• Import CSV file
• Clean/analyze data/create new dataframes
• Export in a clean XLSX file with multiple sheets

@Charly_Wargnier showed me a way to download a CSV file from the app but I can’t figure the way to download my “export_keywords.xlsx” file :

Is there a way to do it ?

Thank you in advance.

[Charly_Wargnier]

Hey Michael! Welcome to the forum!

I think this download_button function from @jrieke would do what you need.

jrieke/traingenerator/blob/main/app/utils.py#L73

Thanks
Charly

[shashank.deshpande]

You can refer this

Download button for csv or xlsx file

Hi Simon I was struggled with the same problem before, you can have a shot with following code which works fine with me. import pandas as pd from io import BytesIO from pyxlsb import open_workbook as open_xlsb import streamlit as st def to_excel(df): output = BytesIO() writer = pd.ExcelWriter(output, engine='xlsxwriter') df.to_excel(writer, index=False, sheet_name='Sheet1') workbook = writer.book worksheet = writer.sheets['Sheet1'] format1 = workbook.add_format({'num_f…