Examples

Read excel file and show values of each cell in log

#uses "classes/BeccExcelCell"
#uses "classes/BeccExcelSheet"
#uses "classes/BeccExcelBook"

main()
{
  BeccExcelBook book = new BeccExcelBook();//create new instance

  try
  {
    book.load("C:\\temp\\xxx.xlsx");//load excel file
  }
  catch
  {
    throwError(getLastException());//show log error if load fails
    return;
  }

  int iSheet2Idx = book.getSheetIndex("sheet2");//get index of the sheet with name 'sheet2'

  if ( iSheet2Idx > 0 )//sheet exists
  {
    shared_ptr<BeccExcelSheet> sheet2 = book.getSheet(iSheet2Idx);//get sheet2 pointer

    for ( int line = 1; line <= sheet2.getLastRow(); line++ )
    {
      for ( int column = 1; column <= sheet2.getLastColumn(); column++ )
      {
        shared_ptr<BeccExcelCell> cell = sheet2.getCell(line, column); //get cell pointer

        DebugN("line "+line+":column:"+column+"=", cell.getValue());//show each value in log
      }
    }
  }
}