Get Range As Datatable

Category

Excel Commands

Description

This command gets text from a specified Excel Range and put it into a DataTable. Use this command when you want to get a value from a specific range.

Parameters

Instance Name

Enter the instance name to indicate the selected workbook

Sheet Name

Indicate the name of the sheet within the Workbook to activate

Range

Indicate the range to delete (ex. A1 or A1:C1)

First Row is Header

Select Yes will exclude the first row from the output

Variable

Assign result to variable

Returned Value

This command does not have returned value.

Example Usage

Example Location:

BYpass\Examples\Excel Commands\Get Range As Datatable\Get Range As Datatable.xml

See Also

• Add Workbook

• Add Worksheet

• Append Cell

• Append Row

• Close Workbook

• Copy Worksheet

• Delete Cell

• Delete Row

• Excel Create Datatable

• Export to PDF

• Get Cell

• Get Cell Style

• Get Last Column Index

• Get Last Row Index

• Get Range

• Get Worksheets

• Go To Cell

• Insert Cell

• Lookup Range

• Open Workbook

• Remove Duplicate

• Run Macro

• Save Workbook

• Save Workbook As

• Set Range

• Write Range

• Write Row