Hi there,
I am trying to custom sheet format, but I got error: "Exception: Service Spreadsheets timed out while accessing document with id {}" at line "var txtRange = "A2:Z" + sheet.getLastRow();"
Before It used to run well for long time, but got this error in recent days.
Do you have any ideas about this? Many thanks.
Script:
"
function doGet(e) {
return HtmlService.createHtmlOutput("Received request");
}
//function clearActiveSheet(){
//SpreadsheetApp.getActiveSpreadsheet().getSheetByName("nirmil").clear();
//SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet1").clear();
//SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet2").clear();
//this is a function that fires when the webapp receives a POST request
function doPost(e) {
//var params = JSON.stringify(e.postData.contents);
//params = JSON.parse(params);
var myData = JSON.parse(e.postData.contents);
var tab_name="EDU";
Logger.log(typeof(tab_name))
var itt = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(tab_name);
if (!itt) {
SpreadsheetApp.getActiveSpreadsheet().insertSheet(tab_name);
}else {
var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(tab_name);
}
//auto resize all columns
sheet.autoResizeColumns(1, 23);
//hidden default to below column
sheet.hideColumns(3);
sheet.hideColumns(4);
sheet.hideColumns(8);
sheet.hideColumns(9);
sheet.hideColumns(10);
sheet.hideColumns(11);
sheet.hideColumns(14);
sheet.hideColumns(15);
sheet.hideColumns(16);
sheet.hideColumns(17);
sheet.hideColumns(18);
sheet.hideColumns(19);
sheet.hideColumns(20);
sheet.hideColumns(21);
sheet.hideColumns(22);
sheet.hideColumns(23);
//sort column CREATED_AT
var txtRange = "A2:Z" + sheet.getLastRow();
sheet.getRange(txtRange).sort({column: 1, ascending: true});
SpreadsheetApp.flush();
return HtmlService.createHtmlOutput("post request received");
}
"