Method ImportExcel

Imports values to the datatable from external Excel file

Usage

Function DataTable.ImportExcel( 
    String Path,
    String SheetName [Optional],
    Boolean OverwriteTable [Optional],
    Boolean AddPrefixToColumnName [Optional]
)

Parameters

Path

Type: String

Path of the Excel file

SheetName (optional)

Type: String

Default value: Empty String

Sheet name to import

OverwriteTable (optional)

Type: Boolean

Default value: true

If set to true, overwrites the existing datatable values

AddPrefixToColumnName (optional)

Type: String

Default value: false

Adds the filename prefix to the parameter name (Especially useful to prevent duplicate parameter names when OverwriteTable is set to false)

Returns

No return value

Example

VBScript

Datatable.ImportExcel "C:datatable.xls", "Sheet1", true, false

JavaScript

Datatable.ImportExcel("C:\datatable.xls", "Sheet1", true, false);

Datatable Methods

Method ExportCSV

Method ExportExcel

Method ImportCSV

Method ImportExcel

Method SetValue

Method Value

Documentation Categories

benefits UI testing and rpa

ZAPTEST

Manual testing tools, vs. automation, checklists and more

FARM

LOAD