Google Spreadheets Scripts: check if cell is empty

by

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");
}

More Related Contents:

  1. Apps Script: how to get hyperlink from a cell where there is no formula
  2. Refresh data retrieved by a custom function in Google Sheet
  3. How to automatically import data from uploaded CSV or XLS file into Google Sheets
  4. Create Google Calendar Events from Spreadsheet but prevent duplicates
  5. ultimate short custom number formatting – K, M, B, T, etc., Q, D, Googol
  6. How do I make a Sidebar display values from cells?
  7. Google Apps Script: How to set “Use column A as labels” in chart embedded in spreadsheet?
  8. Google Spreadsheet SCRIPT Check if edited cell is in a specific range
  9. button click is only working on Windows & not working on Android mobile sheet
  10. Custom functions intermittently hang with “Error – Loading Data”
  11. Retrieving Google Sheets cell border style programmatically
  12. How do I add formulas to Google Sheets using Google Apps Script?
  13. Deleting rows in google sheets using Google Apps Script
  14. Delete a row in Google Spreadsheets if value of cell in said row is 0 or blank
  15. Google apps script to email google spreadsheet excel version [duplicate]
  16. Margins parameters for Google spreadsheet export as PDF
  17. Hidden field in a Google Form
  18. Measurement of execution time of built-in functions for Spreadsheet
  19. onEdit() doesn’t catch all changes
  20. Converting .xls to google spreadsheet in google apps script
  21. Adding a property to an Html template gives error “Object does not allow properties to be added or changed”
  22. Use script in all spreadsheets
  23. Iterate over range, append string to each
  24. Can the google spreadsheet ‘query’ function be used in google apps script?
  25. How to pause App Scripts until spreadsheet finishes calculation
  26. How can I merge multiple tabs in a Google Spreadsheet using Google App Script?
  27. Custom Functions and Recalculation
  28. How to create INDIRECT array string of multiple sheet references in Google Sheets?
  29. Can the google spreadsheet ‘query’ function be used in google apps script?
  30. google script openById : You do not have permission to perform that action

Leave a Comment