Here is a simple code to write data in EXCEL from X++
static void Write2ExcelFile(Args _args)
{
InventTable inventTable;
SysExcelApplication application;
SysExcelWorkbooks workbooks;
SysExcelWorkbook workbook;
SysExcelWorksheets worksheets;
SysExcelWorksheet worksheet;
SysExcelCells cells;
SysExcelCell cell;
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('@');
cell = cells.item(1,1);
cell.value("Item");
cell = cells.item(1,2);
cell.value("Name");
row = 1;
while select inventTable
{
row++;
cell = cells.item(row, 1);
cell.value(inventTable.ItemId);
cell = cells.item(row, 2);
cell.value(inventTable.ItemName);
}
application.visible(true);
}
static void Write2ExcelFile(Args _args)
{
InventTable inventTable;
SysExcelApplication application;
SysExcelWorkbooks workbooks;
SysExcelWorkbook workbook;
SysExcelWorksheets worksheets;
SysExcelWorksheet worksheet;
SysExcelCells cells;
SysExcelCell cell;
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('@');
cell = cells.item(1,1);
cell.value("Item");
cell = cells.item(1,2);
cell.value("Name");
row = 1;
while select inventTable
{
row++;
cell = cells.item(row, 1);
cell.value(inventTable.ItemId);
cell = cells.item(row, 2);
cell.value(inventTable.ItemName);
}
application.visible(true);
}
1 comment:
babyliss, insanity workout, mac cosmetics, hollister, converse outlet, hollister, valentino shoes, giuseppe zanotti, louboutin, reebok shoes, nike roshe, beats by dre, gucci, new balance, bottega veneta, nike air max, longchamp, soccer jerseys, north face outlet, ghd, nike trainers, chi flat iron, celine handbags, asics running shoes, jimmy choo shoes, nike huarache, lululemon, nike air max, ferragamo shoes, vans, wedding dresses, birkin bag, mcm handbags, mont blanc, abercrombie and fitch, baseball bats, instyler, ray ban, converse, oakley, p90x workout, timberland boots, iphone cases, north face outlet, hollister, herve leger, soccer shoes, nfl jerseys, vans shoes, ralph lauren
Post a Comment