Hi, currently I am working on a project which involves duplicating sheets and renaming them in google spreadsheet everytime i have a new input logged in my main console sheet. The current problem is the spreadsheet will be fill in with so many sheets so i want to provide the unique url link that can direct my client to whichever sheet they want to configure. I found a possible solution which is get url activities but i am stuck at pinpointing whichever sheet I want to open within a spreadsheet file through UI Automation. Is there any solution towards this problem? Thanks a lot in advance!
So you want to open the excel sheet file along with the specific sheet?
yes, a specific sheet among quite a number of sheets within a google spreadsheet to fetch its url
There are two things when I just observed in the URL one is the sheet file ID and the other is the gID which is the current sheet ID.
Just try to check the worksheet object or activities through which if you can get the IDs, which can be then used as required.
Hope this helps.