How to ignore empty cell values for getRange().getValues()

by

You can also use filter().

var ss = SpreadsheetApp.getActiveSpreadsheet(); 
var sheet = ss.getSheetByName("Test"); 
var range_input = ss.getRange("A1:A").getValues();
var filtered_input = range_input.filter(String);

More Related Contents:

  1. Determining the last row in a single column
  2. How can I be getting multiple unwanted event blocks from the same onFormSubmit Trigger?
  3. ArrayFormula is breaking the getLastRow() funtion. Possible workarounds?
  4. Google Sheets OnEdit() – You do not have permission to call a service
  5. Detect user inserting row or column in a google spreadsheet and reacting in a script
  6. Is there a custom function or script that returns gid of a specific sheet in Google Sheets?
  7. Export (or print) with a google script new version of google spreadsheets to pdf file, using pdf options
  8. Google app scripts: email a spreadsheet as excel
  9. Is there a way to keep two sheets synchronized?
  10. Selecting the last value of a column
  11. Moving Files In Google Drive Using Google Script
  12. How to get onFormSubmit to trigger automatically?
  13. Copying a spreadsheet copies all linked files as well
  14. onEdit simple trigger never seems to be triggered
  15. “SpreadsheetApp.getUi() cannot be called from this context”
  16. Using built-in spreadsheet functions in a script
  17. Protect ranges with google apps script
  18. GAS “On edit” trigger not running when edited from API
  19. How to access new ‘in-cell-image’ from google apps script?
  20. How to convert a Google Sheets-File to an Excel-File (XLSX)
  21. Difference between getValue() and getDisplayValue() on google app script
  22. Dynamically creating spreadsheet menu items
  23. Creating and Sending sheets in the same function
  24. How do I know if spreadsheet cells are merged using google apps script
  25. How to use a formula written as a string in another cell [evaluate for Google Spreadsheet] [duplicate]
  26. How to prefill Google form checkboxes?
  27. Google apps script error: “You do not have permission to call protect” [duplicate]
  28. Google spreadsheet “Cannot call method “getRange” of null”
  29. Is it possible to create macro buttons to navigate in Google Sheets?
  30. Publish an add-on privately

Leave a Comment