"Export to Excel" results in incorrectly formatted cells

[jinnyzor]

Hello @nateadams

Welcome to the community!

Have you tried exporting the df to excel via a callback method? This will give you more control over how the file is exported.

Check out this post:

Open Source Dash Ag Grid Excel Download

Hi all! As you probably know if you worked with Dash ag grid, downloading the grid as an Excel file is only available on the enterprise edition and not the open source one. This minimal app (links below) uses open source Dash ag grid with openpyxl to download a grid as a formatted Excel file. The downloaded Excel file is formatted as a table already for dynamic interactivity on Excel. The Excel file has formatted column headers. Formatted cells consistent with the grid format (highlight prof…