Example: UsedRange property

This example gets the used range of a sheet.

  Sheets sheets = spreadsheet.getSheets();
  Sheet sheet = sheets.item(1);
  Range range = sheet.getUsedRange();

Related information

UsedRange property