How to read Data from an Excel file

Try the following job :)

static void ReadExcel(Args _args)
{
SysExcelApplication application;
SysExcelWorkbooks workbooks;
SysExcelWorkbook workbook;
SysExcelWorksheets worksheets;
SysExcelWorksheet worksheet;
SysExcelCells cells;
COMVariantType type;
int row;
ItemId itemid;
Name name;
FileName filename;


;

application = SysExcelApplication::construct();
workbooks = application.workbooks();
//specify the file path that you want to read
filename = "C:\\item.xls";
try
{
    workbooks.open(filename);
}
catch (Exception::Error)
{
    throw error("File cannot be opened.");
}

workbook = workbooks.item(1);
worksheets = workbook.worksheets();
worksheet = worksheets.itemFromNum(1);
cells = worksheet.cells();
do
{
   row++;
   itemId = cells.item(row, 1).value().bStr();
   name = cells.item(row, 2).value().bStr();
   info(strfmt('%1 - %2', itemId, name));
   type = cells.item(row+1, 1).value().variantType();
}
while (type != COMVariantType::VT_EMPTY);
   application.quit();
}

Happy Daxing!