|
the syntax to import sheets from excel to data table is...........
DataTable.ImportSheet "location of .xls file","sheet in .xls file","sheet in data table"
Ex: DataTable.ImportSheet "C:\gettingstarted.xls","sheet1","action1"
similarly u can import other required sheets into data table as well.......
|