Creating Excel File Through X++ Code in dynamics ax 2009 or ax 2012

In Microsoft Dynamics Ax developers need to export the table data's from Ax Table to Excel...So here i have sample code for how to write data into excel in Dynamics ax 2009.


Sample Code:

static void AxTableToExcel(Args _args)
{
    CustTable custTable;

    int row;

    SysExcelApplication excelApp;

    SysExcelWorkbooks workbooks;

    SysExcelWorkbook workbook;

    SysExcelWorksheets worksheets;

    SysExcelWorksheet worksheet;

    SysExcelCells cellsHeader, cellsData;

    SysExcelCell cellAccNum, cellName;

    excelApp = SysExcelApplication::construct();

    workbooks =excelApp.workbooks();

    workbook = workbooks.add();

    worksheets = workbook.worksheets();

    worksheet = worksheets.itemFromNum(1);

    worksheet.name("Customers");

    cellsHeader = worksheet.cells();

    cellsData = worksheet.cells();

    cellsHeader.range('A:A').numberFormat('@');

    cellAccNum = cellsHeader.item(1, 1);

    cellAccNum.value("Account Num");

    cellName = cellsHeader.item(1, 2);

    cellName.value("Name");

    row = 1;

    while select custTable

    {

        if(row != 1550)
       
        {
            row++;

            cellAccNum = cellsData.item(row, 1);

            cellAccNum.value(custTable.AccountNum);

            cellName = cellsData.item(row, 2);

            cellName.value(custTable.Name);
        }
        else
        {
            break;
        }
    }

    worksheet.columns().autoFit();

    excelApp.visible(true);
}