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]
)

ZAP.Da...ImportExcel

C:datatable.xls

sheet1

true

false

String Path

String SheetName

Boolean OverwriteTable

Boolean AddPrefixToColumnName

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);

Import datatable values from Excel file

Zap.Da...ImportExcel

C:datatable.xls

Set sheet name, overwrite datatable values and add prefix to column name

Zap.Da...ImportExcel

C:datatable.xls

sheet1

true