X++ 코드를 이용해 Excel에 데이터 보여주기

아래 코드를 이용해 CustTable의 거래처 정보를 Excel 화면에 보여줄 수 있습니다

static void CreateExcelFile(Args _args) { CustTable custTable; SysExcelApplication excel; SysExcelWorkbooks workbooks; SysExcelWorkbook workbook; SysExcelWorksheets worksheets; SysExcelWorksheet worksheet; SysExcelCells cells; SysExcelCell cell; int row; excel = SysExcelApplication::construct(); workbooks = excel.workbooks(); workbook = workbooks.add(); worksheets = workbook.worksheets(); worksheet = worksheets.itemFromNum(1); cells = worksheet.cells(); cells.range('A:A').numberFormat('@'); while select custTable { row++; cell = cells.item(row, 1); cell.value(custTable.AccountNum); cell = cells.item(row, 2); cell.value(custTable.name()); } excel.visible(true); }

[결과 화면].