If you want to end up with a truly ‘blank’ value, you can use the expression IFERROR(0/0). This is different from an empty string which is what you get when you use “”. A cell with an empty string will not test true using ISBLANK(), but IFERROR(0/0) will. For example: =IF(ISBLANK(A1),IFERROR(0/0),”not blank”) How this works: … Read more
=unique(A2:A) should work =unique(filter(A2:A,A2:A<>””)) to also ignore blanks
The following should do the trick: workbook.setSheetName(workbook.getSheetIndex(sheet), “newName”);
There’s a way to make API calls and have the results go into a spreadsheet – the only way I know to do it is create/open the target spreadsheet, go to tools and then Script editor, and use this as a bound script: function Maestro() { var ss = SpreadsheetApp.getActiveSpreadsheet(); //get active spreadsheet (bound to … Read more
No need to extact the value to determine if the cell is empty. Google Spreadsheet API already has a method for this: Range – isBlank method var cell = r.getCell(rws-1, 10); if (cell.isBlank()) { cell.setValue(“foo”); }
Is it populating the worksheet? or saving? that you find too slow? How are you populating the spreadsheet with the data? Using the fromArray() method is more efficient than populating each individual cell, especially if you use the Advanced Value Binder to set cell datatypes automatically. If you’re setting values for every individual cell in … Read more
Assuming you really mean easiest and are not necessarily looking for a way to do this programmatically, you can do this: Add, if not already there, a row of “column Musicians” to the spreadsheet. That is, if you have data in columns such as: Rory Gallagher Guitar Gerry McAvoy Bass Rod de’Ath Drums Lou Martin … Read more