title: Google Apps Script SpreadsheetApp Banding Class - How to access these methods
body: <p>I am trying to figure out how to access the Banding Class of methods for the SpreadsheetApp.  This is not how to simply apply banding.  Instead, I am trying to get the data related to a sheet that banding has been applied to.</p>
  
  <p>Here is the Developers Documentation:
  <a href="https://developers.google.com/apps-script/reference/spreadsheet/banding" rel="nofollow noreferrer">https://developers.google.com/apps-script/reference/spreadsheet/banding</a></p>
  
  <p>I can use .getBandings() but this simply confirms whether or not a banding exits in the sheet.  There is no data as to the details of that banding.  For example, I would like to return the range of the banding.</p>
  
  <p>I also learned that when a banding is applied, the background color of the cell stays default, so I cannot utilize those methods to determine the details.</p>
  
  <p>Here is the link to a Sheet with banding applied.  I have added a few lines of script to show what getBandings() returns.  Feel free to make a copy.
  <a href="https://docs.google.com/spreadsheets/d/1xRuwE8moueSY5ZizZcy6KPkVmhJmOITN9Bql7XgHY3g/edit#gid=0" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1xRuwE8moueSY5ZizZcy6KPkVmhJmOITN9Bql7XgHY3g/edit#gid=0</a></p>
  
  <p>Any advice on how to access/utilize the methods in the Banding class would be appreciated.</p>
  
  <hr>
  
  <p>From a comment to an answer</p>
  
  <p>I am trying figure out the list of methods that would open up that class in SpreadsheetApp. I have experimented with SpreadsheetApp, getActiveSheet, getSheetByName, getRange and more. I cannot figure out how to open up that set of commands in the Banding class.</p>