This is a sample script for retrieving cells without blank cells. Figure 1 shows the sample spreadsheet. In this sheet, the row 14 has one space.
|Fig. 1: Sample spreadsheet.|
Data is retrieved as follows.
var data = SpreadsheetApp .getActiveSpreadsheet() .getActiveSheet() .getRange('a1:a30') .getValues();
1. Retrieving cells with spaces and no blank cells.
var Result = [i for each (i in data)if (i)].join('');
Result : Hello World
2. Retrieving cells without both spaces and blank cells.
var Result = [i for each (i in data)if (isNaN(i))].join('');
Result : HelloWorld