📋
Get Sheet List
This option will let you get the list of names of all sheets present in your spreadsheet. Below it's explained how you can do it too...
To get list of Sheet present in your Spreadsheet, you will need the GetSheetList Blocks
We just have to add the block to any event, am using a button. You can also use it at initialize or at any other event
This is how the block will look like
Now we navigate to the GotSheetList blocks
We will first check if the response code is 200 or not, if it’s not 200 then we will inform the users that there is some error
If it is 200 then we proceed, am using a list viewer here, you can use any other component as well or if you don’t wish to show it to user then you can save it in a global variable where the global variable will be initialized with make empty list block
This is how our block should look like
This completes the process of getting sheet list with the CloudsheetsClassic Extension
Documentation by Team Cloudsheets
Last modified 2yr ago