Method ImportExcel
Imports values to the datatable from external Excel fileUsage
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, falseJavaScript
Datatable.ImportExcel("C:\datatable.xls", "Sheet1", true, false);
Documentation Categories
ZAPTEST
FARM
Comment
Import datatable values from Excel file