Find where the data on a sheet starts and ends. Worked out from cells that hold something, so a cell that was formatted and then emptied does not count
Inputs
| Name | Type | Required | Default | Description |
|---|---|---|---|---|
Excel Instance excelInstance | variable | Required | — | — |
Sheet Name sheetName | string | Optional | — | Leave empty for the first sheet |
Output Variable outputVariable | variable | Optional | UsedRange | — |
Output
$outputVariableObjectWhere the data is
RangeStringFirstRowNumberLastRowNumberNextRowNumberFirstColumnNumberLastColumnNumberFirstColumnLetterStringLastColumnLetterStringRowCountNumberColumnCountNumberIsEmptyBoolean
Compatibility
WindowsLinuxAttendedUnattended
Related activities
Create New Excel WorkSheet
Add a new blank sheet to the workbook
Delete Excel WorkSheet
Remove a sheet from an Excel workbook
Duplicate Excel WorkSheet
Make a copy of an existing sheet
Freeze Panes
Keep the headings on screen while the rest of the sheet scrolls
Hide Rows, Columns or Sheets
Hide working rows, columns or sheets without deleting them, so the formulas that depend on them still work
Protect Worksheet
Stop a sheet being edited by accident. This is not security: an Excel sheet password is trivially removed, so use it to protect a report from mistakes rather than to keep a secret