Retrieving Google Sheets cell border style programmatically

by

I’m not sure whether this is the best way. I always retrieve the border style using Sheets API. The sample script is as follows.

When you use this sample script, please enable Sheets API.

How to enable API:

From April 8, 2019, the specification for enabling API has been changed for the GAS project created after April 8, 2019. Ref

GAS project created after April 8, 2019

In this case, when the API is enabled at Advanced Google services, the API is automatically enabled at API console. So you can use the API by only enabling it at Advanced Google services.

Enable Sheets API v4 at Advanced Google Services

  • On script editor
    • Resources -> Advanced Google Services
    • Turn on Google Sheets API v4

GAS project created before April 8, 2019

In this case, the API is required to be enabled at Advanced Google services and API console.

Enable Sheets API v4 at Advanced Google Services

  • On script editor
    • Resources -> Advanced Google Services
    • Turn on Google Sheets API v4

Enable Sheets API v4 at API console

  • On script editor
    • Resources -> Cloud Platform project
    • View API console
    • At Getting started, click “Explore and enable APIs”.
    • At left side, click Library.
    • At Search for APIs & services, input “sheets”. And click Google Sheets API.
    • Click Enable button.
    • If API has already been enabled, please don’t turn off.

If now you are opening the script editor with the script for using Sheets API, you can enable Sheets API for the project by accessing this URL https://console.cloud.google.com/apis/library/sheets.googleapis.com/

Other case

If you want to use the API which is not included in the Advanced Google services at GAS project created after April 8, 2019, it is required to link Cloud Platform Project to Google Apps Script Project. And the API is required to be enabled at API console. You can see the detail flow of this at here.

Sample script :

var spreadsheetId = SpreadsheetApp.getActiveSpreadsheet().getId();
var res = Sheets.Spreadsheets.get(spreadsheetId, {ranges: "Sheet1!B2", fields: "sheets/data/rowData/values/userEnteredFormat/borders"});

References :

If this was not useful for you, I’m sorry.

More Related Contents:

  1. Refresh data retrieved by a custom function in Google Sheet
  2. How do you create a “reverse pivot” in Google Sheets?
  3. Create Google Calendar Events from Spreadsheet but prevent duplicates
  4. ultimate short custom number formatting – K, M, B, T, etc., Q, D, Googol
  5. Google Apps Script: How to set “Use column A as labels” in chart embedded in spreadsheet?
  6. Determining the last row in a single column
  7. Cannot find method getRange(number,number)?
  8. You do not have permission to call openById
  9. Google Apps Script, copy one spreadsheet to another spreadsheet with formatting
  10. Single Google Form for multiple Sheets [duplicate]
  11. Adding Buttons To Google Sheets and Set value to Cells on clicking
  12. How do I communicate a page(modal dialog) with its sibling (sidebar)?
  13. Custom function throws a “You do not have the permission required to setValue” error
  14. Margins parameters for Google spreadsheet export as PDF
  15. Google Apps Script: Dynamically creating spreadsheet menu items
  16. Script to convert .XLSX to Google Sheet and move converted file
  17. Hidden field in a Google Form
  18. Apply multiple font colors to the text in a single Google Sheets cell
  19. How to evaluate a spreadsheet formula within a custom function?
  20. Google Sheet use Importxml error could not fetch url [duplicate]
  21. On Edit doesnt work if cell auto updates – Need a workaround Google Sheets
  22. Adding a property to an Html template gives error “Object does not allow properties to be added or changed”
  23. Use script in all spreadsheets
  24. Iterate over range, append string to each
  25. Can the google spreadsheet ‘query’ function be used in google apps script?
  26. How to pause App Scripts until spreadsheet finishes calculation
  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