How do you upload excel file in to the app and save/update in google sheet-database?

MIT App Inventor Help
1

How do you allow app users to upload excel file in to the app and the file has to be saved/updated in google sheet-database?

2

Upload file using File Picker + Save+Read using MFile + Update in Google Sheet. I assume something like this.

3

I haven't tried this but you could possibly convert your Excel file to a CSV file; upload the CSV. Then you might be able to use the CSV in your Project by reading it with the GoogleSheet control. Google Sheets can load a CSV created by Excel.

I suspect you will have issues that might require the csv is loaded into a shared folder and you might have to use SAF because of Google's security requirements.

1 Like