Excel Create Datatable

Category

Excel Commands

Description

This command gets a range of cells and applies them against a dataset. Use this command when you want to quickly iterate over Excel as a dataset.

Parameters

Datatable Name

Indicate Datatable name to create.

Excel File Path

Enter or Select the path to the Excel file.

Sheet Name

Indicate the sheet name within the Excel file.

Header Row

Indicate if the sheet has header row.

Returned Value

This command does not have returned value.

Example Usage

Example Location:

BYpass\Examples\Excel Commands\Excel Create Datatable\Excel Create Datatable.xml

See Also

• Add Workbook

• Add Worksheet

• Append Cell

• Append Row

• Close Workbook

• Copy Worksheet

• Delete Cell

• Delete Row

• Export to PDF

• Get Cell

• Get Cell Style

• Get Last Column Index

• Get Last Row Index

• Get Range

• 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