Tag: google-sheets

How to speed up moveRows script

arrays google-apps-script google-sheets java javascript

I use a script how move rows in other sheet and delete them if condition match. It works but sometimes it’s long. How can i speed up this please ? I try this but it’s not working. I think i can’t combine sh1.getRange(sh1.getLastRow()+1, 1,vals.lenght , vals[0].length).setValues(result) with sh0.deleteRows(i+1) or the problem is for (var i=vals.lenght-1;i>0;i–) ?? Answer I believe your

Reading whole Google Spreadsheet with Sheets API v4 Java

google-sheets google-sheets-api java

I would like to read a Google Spreadsheet like described in the Java Quickstart https://developers.google.com/sheets/quickstart/java The Quickstart explaines how to read data from a give range But I have the problem that I do not know the Range of the Spreadsheet. The number of columns can change. So how can I read for example all the data of the Sheet

How to do I locate a Google SpreadSheet ID?

google-apps-script google-sheets java

https://developers.google.com/apps-script/guides/rest/api#parameter_and_return_types When using the Google Execution Api for Java, the ID of the spreadsheet isn’t very easy to understand. Here is the …