Hi..
I use google sheet extension and it seems to be working so fine
I have a google sheet file with many sheets and I need to get the Gids for every sheet and store in a list
Any hint?
You can do this with Google apps script
could you show me how
function getSheetId()
{
var ss=SpreadsheetApp.getActive();
var sh=ss.getActiveSheet();
var allSheets=ss.getSheets();
var ids=[];
for(var i=0;i<allSheets.length;i++)
{
ids[allSheets[i].getName()]=allSheets[i].getSheetId();
}
console.log(ids);
}
Credits:
Thanks alot for your support and showing the credits
just last think ...
I am not familiar with scripting...
could you tell me how to include this in my Graphical interface and put the results in both sheet names list and gids list
thanks again