Thursday, July 24, 2008

Import Excel sheet or Files

Datatable.import(“C:\sheet.xls”)

Import sheet method
Datatable.importsheet(Filename, sheetsource, Sheetdest)
Filename = File location
Sheetsource = sheet name (Start from index 1)
Sheetdesignation = Particular location (Start from index 1)
DataTable.ImportSheet "C:\sheet.xls" ,1 ,"name"

No comments: