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, false
JavaScript
Datatable.ImportExcel("C:\datatable.xls", "Sheet1", true, false);
Documentation Categories
![](https://www.zaptest.com/wp-content/uploads/2022/02/1SCRIPT_STEP.jpg)
ZAPTEST
![](https://www.zaptest.com/wp-content/uploads/2022/02/FARM.jpg)
FARM
![](https://www.zaptest.com/wp-content/uploads/2022/02/LOAD.jpg)
Comment
Import datatable values from Excel file