I have this button below. And a data frame named ‘df_download’. How can I function this button to download the ‘df_download’ as excel/csv file? download=st.button('Download Excel File') if download: 'Download Started!' liste= ['A','B','C'] df_download= pd.DataFrame(liste) df_download.col…

@randyzwitch thank you for the inspiration. I manage to solve it like : if download: 'Download Started!' liste= ['A','B','C'] df_download= pd.DataFrame(liste) df_download.columns=['Title'] df_download csv = df_download.to_csv(index=False) b64 = base64.b64encode(csv.encode()).decode()…

Thanks very much for your attention and time. :pray:

Hi mate, is there a way to customize the link where the user will click? Like the image below… Download excel file [1221]

Hi @feliperoque , certainly! I’ll refer you to this thread by @Chad_Mitchell who creates a download button with custom CSS: A download button with custom CSS - #13 by jrieke A download function and examples app for Streamlit · GitHub Using Chad’s function in the code from this thread: import stre…

I had a problem with this function while i was trying to convert a csv to excel. Didn’t worked. Could i create just this part: button_uuid = str(uuid.uuid4()).replace('-', '') button_id = re.sub('\d+', '', button_uuid) custom_css = f""" <style> #{button_id} {{ …

@feliperoque I edited my previous answer such that it converts a dataframe to .xlsx instead of .csv :slight_smile:

[image] snehankekre: b64 = base64.b64encode(towrite.read()).decode() Thx you very much, i was looking for this my whole night rsrs.

Thanks for the useful replies and cross post linking everyone! I got my Excel file download working with a combination of openpyxl, using wb.save("test.xlsx") to save it to the current app dir and then jamming that file into: file = f'<a href="test.xlsx" download="test.xlsx">Download excel file</a>…

Starting with v0.88 now have st.download_button natively built into Streamlit. Check out the release notes and demo: 0.88.0 Release Notes

Hi @snehankekre , thanks a lot for this solution. Can you please help me with understadning, how to add multiple sheets in the excel file and then download that. With your current code, I checked, only one sheet is getting added. Thanks

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

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

Using Streamlit

snehankekre October 28, 2022, 12:07pm 19

@sehitkaradag Without a reproducible code snippet, I’m afraid I can’t be of much help. Using Streamlit: how to post a question in the Streamlit forum

Topic		Replies	Views
How to download file in streamlit Using Streamlit file-download	95	73247	December 6, 2023
Download XLSX file with multiple sheets in Streamlit Using Streamlit pandas , file-download	2	7021	December 6, 2021
Download button for csv or xlsx file Using Streamlit pandas , file-download	4	45060	January 30, 2024
A download button with custom CSS Show the Community! file-download	20	12010	October 30, 2025
Download Button with Excel File Using Streamlit file-download	16	29775	May 10, 2024

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

Related topics