I am using this (which I got from this forum) to send me an email of the
shared sheets.
var oauthConfig = UrlFetchApp.addOAuthService("google");
oauthConfig.setAccessTokenUrl("https://www.google.com/accounts/OAuthGetAccessToken";);
oauthConfig.setRequestTokenUrl("https://www.google.com/accounts/OAuthGetRequestToken?scope=https://spreadsheets.google.com/feeds/";);
oauthConfig.setAuthorizationUrl("https://www.google.com/accounts/OAuthAuthorizeToken";);
oauthConfig.setConsumerKey("anonymous");
oauthConfig.setConsumerSecret("anonymous");
var requestData = {"method": "GET", "oAuthServiceName": "google",
"oAuthUseToken": "always"};
var url =
"https://spreadsheets.google.com/feeds/download/spreadsheets/Export?key=";
+ ssID + "&gid=0&portrait=true" +"&exportFormat=xls";
var result = UrlFetchApp.fetch(url , requestData);
var contents = result.getContent();
MailApp.sendEmail(email,subject ,body,
{attachments:[{fileName:sheetName+".xls", content:contents,
mimeType:"application//xls"}]});
but I need to print for me the hidden sheets.
how I do that?
thank you
--
You received this message because you are subscribed to the Google Groups
"Google Spreadsheets API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
