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???
2.1m questions
2.1m answers
60 comments
57.0k users