How to connect the microsoft excel files to my app?
Use the API connector and Google sheets api
Zapier plugin they have a Zap for that
@levon has a Sheetu plugin
1 Like
The zapier zap requires the excel file to be on a OneDrive business account unfortunately. And the other two solutions you mentioned are for Google Sheets.
Does anyone know if there is a way to allow a user to upload an excel file and read that data into a Bubble database?
Why not save the file as a .csv and upload it directly into Bubble? You can do this either via workflow (100 rows max) as a user or via the Bubble Editor (App Data) via admin, which does not have size restrictions.
Will give this a try, thanks! I was also just reading about Apachi POI which I guess is an API for reading excel documents. Any idea if the Bubble API connector would be able to connect to this?
https://poi.apache.org/
It says it supports Java 6, but doesn’t mention anything about json/xml/etc. You’ll have to read through their documentation, but it doesn’t look like it.
1 Like
That Sheetsu plugin is not for the newbie. Instructions, if that’s what you want to call them, make no sense. They’re written for those that are already programmers.