Creating an Excel file
The Microsoft Office Excel format is one of the formats that have been supported by Dynamics AX right from its early versions. Since Dynamics AX 2009, almost every form has the Export to Excel function, which quickly allows loading data on the screen into Excel for further analysis with powerful Excel tools. In Dynamics AX 2012, the new Microsoft Office Add-ins were introduced. They allow data exporting, refreshing, editing, and publishing back to Dynamics AX, in a very user-friendly manner.
But if the Add-ins are not installed, it is still possible to create an Excel document from code. Dynamics AX holds a set of standard application classes prefixed with SysExcel. Basically, those classes are COM wrappers for Excel, and ...
Get Microsoft Dynamics AX 2012 Development Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
