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 they contain additional helper methods to make the developer's tasks easier.
In this recipe, we will demonstrate the use of the SysExcel classes. We will create a new Excel file from code, and will fill it with a customer list from the system.
