Hi, Is there an easy way to allow users to download an Excel? I tried to put: html.A("Download Excel", href="test.xlsx", download="test.xlsx") but what I get in the dowloaded document is actually HTML code trying load the page. If i put: html.A("Download Excel", href="test.xlsx") and I clic…

FYI this option is built in to the DataTable as well, see http://dash.plotly.com/datatable/reference for all available options: dash_table.DataTable(export_format='xlsx')

Thx! It works like a charm! For other people that may be interested this is what I did (Im converting a DataFrame into an Excel): import dash from dash.dependencies import Input, Output, State import dash_core_components as dcc import dash_html_components as html import dash_table_experiments as …

@Hujikol0 I was trying to do something like this but I kept getting stuck and I couldn’t find ANYTHING on how to fix the issues I was running into, but your code was FINALLY just what I needed to get my app working. Thank you so much for sharing!!!

Do you know if there would be any reason why this solution wouldn’t work on a mac? I’m trying to run your code but the xls file that gets downloaded has 0 bytes and cannot be opened… :frowning:

This is really great. Thanks for sharing - just what I needed!

Hi - have you tried in different browsers? We have seen strangely different behaviour between Safari and Chrome.

I figured it out, it’s because of the cache. Reset your cache in Chrome and in the future the send_file function you should set the cache_timeout=0. Here’s the whole example: import dash import dash_html_components as html from flask import send_file import pandas as pd app = dash.Dash() app.lay…

Thanks, that’s good to know - we’ll try using that too!

Is it possible to integrate this in a callback which creates the dataframe dynamically (based on inputs to the callback)?

You could refer to Allowing users to download CSV on click to integrate this in a callback. Hope the following example helps import dash import flask import dash_html_components as html import dash_core_components as dcc from dash.dependencies import Input, Output from flask import send_file impor…

Allow users to dowload an Excel in a click

Dash Python

chriddyp April 4, 2018, 4:12pm 2

See Allowing users to download CSV on click

Download data to excel button - works locally but not on website

Topic		Replies	Views
Dash, Unable to download excel file on button click Dash Python question	4	574	November 10, 2022
Download raw data Dash Python	69	52011	February 6, 2021
Download Raw Data - xls/xlsx Dash Python	5	5342	March 2, 2020
Download data to excel button - works locally but not on website Dash Python	7	2215	September 22, 2025
Raw data download working locally and not online Dash Python	5	1351	November 6, 2020

Allow users to dowload an Excel in a click

Related topics