Data export to Excel

Dynamics 365 for 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. } }