O'Reilly logo

Microsoft Dynamics AX 2009 Development Cookbook by Mindaugas Pocius

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating Excel files

Microsoft Office Excel format is one of the formats that have been supported by Dynamics AX since its early versions. For example, the Document handling feature allows producing Excel files using the data from the system. In the new version of Dynamics AX, i.e. Dynamics AX 2009, this feature is extended even more. Now almost every form has a button called Export to Excel, which quickly allows loading form data into Excel for further analysis using powerful Excel tools.

Microsoft Office Excel format handling is done with the help of standard Dynamics AX application classes prefixed with SysExcel. Basically, those classes are Excel COM wrappers plus they contain additional helper methods to ease the developer's tasks.

To demonstrate ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required