Data export to Excel

Finance and Operations/AX Developer Forum
1

Does anyone know how to open an existing Excel file to write data in it? Is there a variant to this? **** excel = SysExcelApplication::construct(); books = excel.workbooks(); **** thx for the help. Kathleen

2

I do not know the Axapta syntax, but in Excel Automation, the next step would be book = books.open(filename); book is an Automation variable of type Excel.Workbook.

3

Here’s some Axapta code sample : SysExcelApplication excel = SysExcelApplication::construct(); str fileName = excel.getOpenFileName(); if (fileName != “”) { if (excel.workbooks().open(fileName)) { // You now have an opened workbook. } }