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