How to download the excel file created from xlsxwriter and openpyxl

Anvil Q&A
1

Hello everyone,
I’m trying to pull an excel that I created with xslxwriter and openpyxl from my app

I’ve copy and paste code that is working in different Python IDE and I think it’s working in my app too because I don’t have any error.

But my problem here is that I don’t know how to find the created excel file and so download it.

First, if there is a file section somewhere how can we access it ?
And second, does anyone know the syntax of the created excel file so I can put it into a data table to make it downloadable for users.

PS: My excel file has some formatting tables and some graphs so I can’t juste use pd.to_excel

Thanks all,
Have a good day

2

Hi, and welcome! Can you share the specific code you’re using to create this excel file, or share a clone link to an app demonstrating this code? For tips on how to do this: How to ask a good question

Here’s the docs on the server module filesystem: https://anvil.works/docs/media#files-in-server-modules

3

I also have this question.

4

Your short answer to this old question is not going to attract any new answers.

Please create new questions and provide as much information as you can: How to ask a good question

1 Like