Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
312 views
in Technique[技术] by (71.8m points)

Error in creating google web app script by providing one drive excel link

I am developing a Google web application through Google apps scrips. I am stuck at where I am linking one drive excel file instead of a Google sheet following are the codes:

function doGet(e){

   var ss = SpreadsheetApp.openByUrl("https://KKR1-my.sharepoint.com/:x:/g/personal/keshavkumar_KKR_com/ET7kXHaCl0lIsQcDcvxRi9MBy9kLTJ8dUZotCWxrZH1Z_A?e=de8CWK");

   var sheet = ss.getSheetByName("Sheet1");      
   return getUserss(sheet); 
  
}

When I put the link of google sheet then there is no error. Is there any way to link the Onedrive excel sheet in the Google app script???

question from:https://stackoverflow.com/questions/65864859/error-in-creating-google-web-app-script-by-providing-one-drive-excel-link

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)
Waitting for answers

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...