Download XLSX file with multiple sheets in Streamlit

[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…