Get All Data
Gets all data from an Excel Sheet and outputs it as a Table
Input
Workbook
| Name | Required | Description |
|---|---|---|
| Workbook Instance | Which Workbook instance to modify. |
| Name | Required | Description |
|---|---|---|
| Worksheet Position | The position of the worksheet in the document. | |
| Sheet Name | The worksheet name. | |
| Use Sheet Name | When enabled, the sheet name will be used to find the worksheet rather than the position. | |
| First Row Header | If true, will treat the first row of data as column headers. |
Output
DataTable A DataTable containing all inputted Excel data