Get Range As DataTable
Read a range as a DataTable using the first row as headers.
Overview
Get Range As DataTable is a no-code automation step in the Excel category of AutoFlowRPA. It performs its action in a single step when the workflow reaches it. You can configure 4 parameter(s) to control exactly how it behaves. It is one of 369 commands you can drag into a workflow in the visual builder — no scripting required.
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 |
How to use Get Range As DataTable
- 1
Open AutoFlowRPA and drag the Get Range As DataTable command from the Excel group onto the canvas.
- 2
Set its parameters in the side panel — Get Range As DataTable has 4 configurable field(s).
- 3
Connect it into your workflow and press Run. Everything executes locally on your machine.
Frequently asked questions
What does the Get Range As DataTable command do?
Read a range as a DataTable using the first row as headers.
Which group does the Get Range As DataTable command belong to?
Get Range As DataTable is part of the Excel group. AutoFlowRPA ships with 369+ ready-made commands you can combine without code.
Does the Get Range As DataTable command take any parameters?
Yes — Get Range As DataTable has 4 configurable field(s), all editable in the visual node editor.
More Excel commands
Ready to automate your busywork?
Start your free 30-day trial today. No credit card, no commitment.