Any way to load Excel workbook within anvil app

Anvil Q&A
1

Is there anyway to load whole excel workbook within an anvil app (while perserving all its format & formulas). Yes, I know its weird (I am stuck with a client who thinks she knows more accounting then a professional accountant (Thats me :grinning:).

The app will be deployed locally.

If you are aware of any quick solution please let me know.

2

That seems like you want a Javascript way of importing and displaying the Workbook, to avoid trying to recreate it all in a data grid. I don’t have experience with it, but this page describes a library: https://www.grapecity.com/blogs/how-to-importexport-excel-files-using-javascript-and-spread-sheets

3

@jshaffstall Thanks. But for a small task like mine, licensing fees is way too much.

4

There may very well be free Javascript libraries out there. The main point was that to avoid recreating the entire logic of Excel yourself in Anvil, a Javascript library is what you want to investigate, unless you get lucky and someone else has already done the Anvil work for it.