Hi All,
I tried importing excel data through this process but I received the following error during run-time:
The error shows up in line (3) datatable.AddSheet, stop and re-running the script from beginning solve this problem, is there any why to avoid this error.
I tried importing excel data through this process but I received the following error during run-time:
Code:
"The Data Table.AddSheet operation failed. Invalid argument".
sheetcount = DataTable.GetSheetCount
If sheetcount < 2000 Then
Line (3) datatable.AddSheet(SheetName)
datatable.ImportSheet Dir&ExcelName,SheetName,SheetName
DataTable.SetCurrentRow(0)
End IfThe error shows up in line (3) datatable.AddSheet, stop and re-running the script from beginning solve this problem, is there any why to avoid this error.