Export Data to Excel by using x++

Export Data to Excel file.

static void exportVendDateToExcel (Args _args)
{
    VendTable                  vendTable;

    SysExcelApplication  application;

    SysExcelWorkbooks  workbooks;

    SysExcelWorkbook    workbook;

    SysExcelWorksheets worksheets;

    SysExcelWorksheet   worksheet;

    SysExcelCells            cells;

    SysExcelCell              cell;

    SysExcelFont             font;

    int                              row;

  
    application    = SysExcelApplication::construct();
    workbooks    = application.workbooks();
    workbook      = workbooks.add();
    worksheets   = workbook.worksheets();
    worksheet     = worksheets.itemFromNum(1);
    cells             = worksheet.cells();
    cells.range('A:A').numberFormat('@');
  
    // Setting Header values
    cell = cells.item(1, 1);
    cell.value("Vend Num");
    font = cell.font();
    font.bold(true);
  
    cell = cells.item(1, 2);
    cell.value("Name");
    font = cell.font();
    font.bold(true);
    row = 1;
  
    while select vendTable
    {
        row++;
        cell = cells.item(row, 1);
        cell.value(vendTable.AccountNum);
        cell = cells.item(row, 2);
        cell.value(vendTable.name());
    }
  
    application.visible(true);
}

run this job now.