I want to write a programe in which there is a Google sheet with 3 sheets namely A,B,C. I want to view data from Sheet C coloumn wise by different buttons. There will be 3 buttons for 3 coloumns. Is it possible without coding in aapscript?
TIMAI2
April 20, 2024, 11:57am
2
Use the Spreadsheet component
Can I get the code written?
TIMAI2
April 20, 2024, 12:02pm
4
Here are some examples to help you:
In order to utilize this component, one must first have a Google Developer Account. Then, one must create a new project under that Google Developer Account, enable the Google Sheets API on that project, and finally create a Service Account for the Sheets API.
How to create the Service Account, here:
http://ai2.appinventor.mit.edu.ezproxy.canberra.edu.au/reference/other/googlesheets-api-setup.html
At the end of the whole process we will obtain a file of the form:
app-inventor-338017-8c72fd465555.json
We must upload…
ABG
April 20, 2024, 8:08pm
5
This is more of a list question, once you have downloaded the sheet(s) as CSV tables and converted them to list based tables.
For lack of more detail, here are the starter materials: