Read xml/xslx files/word from datatables

Anvil Q&A
1

Hi guys, i’m new to anvil and i want to know how to read an xml/xlsx/word file or any media file from datatables.

I uploaded to a datatable one word to use it as a template. But i can’t use it (i don’t know how). I tried get_bytes() but no luck. I have an app which takes an xlsx file and i want to read it with pandas and do the maths and then the infos i want to put in the word template and convert to pdf and sent via email to the client. I did this in python with Kivy GUI but i want to make it on anvil too. I know i need to pay for individual plan to use pandas but before i pay i want to know if i can do this.

Can you guys help me? I don’t know how to work with blobmedia or Lazymedia…and i suck to web dev…that’s why i came to anvil…

I want to know how to use a file from datatables like i’ll do normally in python when i pass them like:

path = “c:/Desktop/PythonApp/sales.xlsx”
and
excel_data = pd.read_excel(path )

I hope you guys understood me and can you help me!

Thanks!

2

Hi there,

You might want to take a look at our documentation on using static files in your app: Anvil Docs | Data Files

We also have a full tutorial on using pandas in Anvil:

3

For access to third-party libraries (e.g., to read and/or write that Word document you mentioned), also see:

1 Like