Get Range As DataTable
Read a range as a DataTable using the first row as headers.
ExcelExcelGetRangeASDT
What it does
Read a range as a DataTable using the first row as headers.
Parameters
| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
| Excel instance | variable | Required | excel | Name that identifies this open workbook. |
| Sheet (blank = active) | string | Optional | Worksheet name; blank uses the active sheet. Supports variables | |
| Range (A1:C3) | string | Required | Example: A1:C10 Supports variables | |
| Store DataTable in | variable | Required | Example: table |
More Excel commands
Ready to automate your busywork?
Start your free 10-day trial today. No credit card, no commitment.