Exporting to excel

Hi Mike,

Currently, Axapta only exports to two kinds of files: Binary and CSV.
There are some options which you should consider:
1) if you just want to copy the data from an Axapta grid to Excel, you could select the records you want to copy and Copy and Paste to Excel cells.
2) You could import to CSV and load that file into Excel. If it is ok, then you have your solution.

However, it is not difficult to create code that exports data to Excel, considering that Axapta can access Excel through COM.

You could create a job like the following example (by Khue Trinh), replacing custTable with any table, and the fields Account num and Name with the desired fields.

static void Excel(Args _args)
{

SysExcelApplication ExcelApplication;
SysExcelWorkBooks ExcelWorkBooks;
SysExcelWorkBook ExcelWorkBook;
SysExcelWorkSheets ExcelWorkSheets;
SysExcelWorkSheet ExcelWorkSheet;
SysExcelRange ExcelRange;
CustTable custTable;
int row = 1;
;

ExcelApplication = SysExcelApplication::construct();
ExcelApplication.visible(true);

ExcelWorkBooks = ExcelApplication.workbooks();
ExcelWorkBook = ExcelWorkBooks.add();
ExcelWorkSheets = ExcelWorkBook.worksheets();
ExcelWorkSheet = ExcelWorkSheets.itemFromNum(1);

ExcelWorkSheet.cells().item(row,1).value('Account num');
ExcelWorkSheet.cells().item(row,2).value('Name');

row++;

while select custTable
{
ExcelWorkSheet.cells().item(row,1).value(custTable.AccountNum);
ExcelWorkSheet.cells().item(row,2).value(custTable.Name);
row++;
}

ExcelApplication.finalize();
}