I want to open Google Sheet with a particular Sheet.
How to do that?
Thank You
How are you accessing google sheets from your app ?
I have the google sheets app installed in my phone.
After a button click i want to open a particular google sheet
Where the DataUri is in this format:
https://docs.google.com/spreadsheets/d/<>SHEETID/edit#gid=<GIDID>
You should ensure that Google Drive / Google Sheets are installed on the device, and that the app user has permission to at least view the spreadsheet.
whats GIDID?
It is the ID of the GID (Grid Id) which is the specific sheet in a spreadsheet. An example:
https://docs.google.com/spreadsheets/d/1IdpGILd7Nii8....la2xbDN1Cok/edit#gid=1517699002
On the above spreadsheet gid=1517699002 is Sheet2
Mine has 0 I suppose 
edit#gid=0
That would be the first sheet when the spreadsheet was created. It may not be the first sheet on the left (which is opened by default if no gid is specified), so you should specify it...
Thank You so much
Of course this works on MIT AppInventor for Android. It will not work for iOS, and would need testing on other builders...
1 Like
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.