Multiple dataframes to specific excel sheets

[snehankekre]

This question has been previously answered by me with a working solution:

How to add a download excel/csv function to a button?

Hi @A2-Response, Certainly. I’ll show you how to use st.download_button to do the job. You’ll have to install the xlsxwriter package and/or add it to your requirements file. I’ll use xlsxwriter's official example: Pandas Excel with multiple dataframes and an example from the pandas docs to write the Excel file to RAM: Code import streamlit as st import pandas as pd import io buffer = io.BytesIO() # Create some Pandas dataframes from some data. df1 = pd.DataFrame({'Data': [11, 12, 13, 14]})…