How to fetch the ID of a Google Spread Sheet via G

问题:

I've created one Google spread sheet and I want to find the ID of that spread sheet. I've tried too much to search on Google but could not succeed.

Please show me the way / script by that I can fetch the spreadsheet ID of an Active spread Sheet..

Thanks

回答1:

The ID (key) of the spreadsheet is in the URL (the part between key= and #gid=). You can retrieve it with GAS using something like:

function getId() {
  Browser.msgBox('Spreadsheet key: ' + SpreadsheetApp.getActiveSpreadsheet().getId());
}

Note, often you will get a totally different string with each method, but they both should work the same.

回答2:

Remember that the getId() function from a Spreadsheet object returns a different id compared with getId() from File object, even if the File (that is managed from DriveApp) is the same spreadsheet.

Anyhow, if you open a file from DriveApp using the id provided by the Spreadsheet, you will obtain the correct File object, returning - with getId() - the "File" id, which is different from the one that you used to open the File.

It seems confusing, but it works so. I had some issues in some scripts coming from this "double" id for the same thing.

回答3:

the sheet is is present in between the the
d and edit of the spreadsheet url.
example -: if the sheet url is

https://docs.google.com/spreadsheets/d/1rV2_S2q5rcakOuHs2E1iLeKR2floRIozSytAt2iRXo8/edit#gid=0

the sheet id is

1rV2_S2q5rcakOuHs2E1iLeKR2floRIozSytAt2iRXo8

for more information go to google sheets api official documentation