Belajar Komputer & Gadget

Example export data to excel in AX 2012 void exportToExcel() {     SysExcelApplication application;     SysExcelWorkBooks workbooks;     SysExcelWorkBook workbook;     SysExcelWorksheets worksheets;     sysExcelWorksheet worksheet;     SysExcelCells cells;     SysExcelCell cell;     int row;     ;     application = SysExcelApplication::construct();     workbooks = application.workbooks();     //gets the workbook object     workbook = workbooks.add();     // creates a new workbook     worksheets = workbook.worksheets();     //gets the worksheets object     worksheet = worksheets.itemFromNum(1);     //Selects the first worksheet in the workbook to insert data     cells = worksheet.cells();     cells.range('A:A').numberFormat('@'); // numberFormat ‘@’ is to insert data as Text     row = 1;         cell = cells.item(row,1);         cell.value("TransactionType");         cell = cells.item(row,2);         cell.value("StoreNumber&quo