web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Export Data from Ax201...
Microsoft Dynamics AX (Archived)

Export Data from Ax2012 to Excel

(0) ShareShare
ReportReport
Posted on by Zohan 2

Hello,

i want to know that how can we export data from ax2012 to Excel. i've already seen some blog regarding to export data in excel using class (xlsworkApplication). Now kindly do let me know if i want to open the  report from button on the form. how is it possible ? Using controller class or  specify the menu item ? 

Regards,

Zohan

*This post is locked for comments

I have the same question (0)
  • B K Sharma Profile Picture
    B K Sharma 737 on at

    You means you have developed a report and given menu button on the form and for active record when you select the report button than this report export in to excel.

    Thanks

  • Suggested answer
    Vilmos Kintera Profile Picture
    Vilmos Kintera 46,149 on at

    It is quite easy to do that, the SysExcel* classes are using the methods implemented in the Excel API/SDK. You can follow the blog articles to generate the file.

    You may do something like this if you want to start Excel:

    community.dynamics.com/.../157961

    And then the Workbook has an open method, with which you can load documents into Excel.

  • Zohan Profile Picture
    Zohan 2 on at

    i want to open 10 reports on excel. When ever i clicked the button the all 10 reports will be displayed on Excel sheet. How can i do it ?

  • Suggested answer
    Vilmos Kintera Profile Picture
    Vilmos Kintera 46,149 on at

    If by reports you mean you would generate the content yourself from code, then it is a matter of programming it using the SysExcel* framework classes, and you could then populate the "reports" into separate worksheets for example. If you use Google, you can find a lot of examples online on how to generate Excel content from AX.

    If you have meant printing an SSRS report that you would save as Excel, that is not possible, SSRS does not support saving multiple reports into the same document. What you could do instead is to save them to separate Excel sheets, and then with a press of a button or a periodic functionality you could write your own code in AX again using the SysExcel* framework, and combine them into a single document on multiple worksheets.

    Kindly mark helpful answers as verified to close the topic.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 39

#2
Michel ROY Profile Picture

Michel ROY 14

#3
imran ul haq Profile Picture

imran ul haq 8

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans