Get Range

Category

Excel Commands

Description

This command gets text from a specified Excel Range. Use this command when you want to get a value from a specific cell.

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)

Delimiter

Enter the Delimiter. Default is comma. (ex. |,!,@ or COMMA)

Include First Row

Select Yes if you want to include the first row in 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\Get Range.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 As Datatable

• 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