Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Ax data export to exce...
Finance | Project Operations, Human Resources, ...
Suggested answer

Ax data export to excel and save in particular directory

(0) ShareShare
ReportReport
Posted on by @rp@n 4

Hi All,

Can you please let me know , i have required to fetch data from AX and EXPORT to excel through CODE and need to save in particular directory with file name.

Criteria --

Dialog --

From date

To date

Vendor code

Vendor group

Please give me more shed on this.

Thanks!

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Ax data export to excel and save in particular directory

    Good morning @rp@n,

    There have been a number of replies for this thread and I wonder whether you have been able to get things sorted out and resolved in the meantime?

    Is there anything else the community can currently help you with?

    Best regards,

    Ludwig

  • Jay Barot Profile Picture
    Jay Barot 1,502 on at
    RE: Ax data export to excel and save in particular directory

    It's read and write both code. You just wanted to see how to write code to retrieve data in excel. That's why shared 2 different link.

    Here i feel that you want readymade code for your use.

  • @rp@n Profile Picture
    @rp@n 4 on at
    RE: Ax data export to excel and save in particular directory

    i am not looking for read code. read properly.

    looking for sample code,.

    which you send the link, error s there.

    Thanks you

  • Jay Barot Profile Picture
    Jay Barot 1,502 on at
    RE: Ax data export to excel and save in particular directory

    Hi Arpan,

    Martin is right. You have to use search engine and you need to learn the coding. Nobody will give you code ready which will work directly for your requirement.

  • Martin Dráb Profile Picture
    Martin Dráb 231,723 Most Valuable Professional on at
    RE: Ax data export to excel and save in particular directory

    I can't give you code generating your report, because I know nothing about your requirements. And if you're looking for examples how to use SysExcelApplication class, simply use a search engine, as I already told you. You need to learn how to do it; we can't do it for you every time.

  • Suggested answer
    Jay Barot Profile Picture
    Jay Barot 1,502 on at
    RE: Ax data export to excel and save in particular directory

    Hi Arpan,

    Below link may help you in detail community.dynamics.com/.../dynamics-ax-code-to-read-write-data-to-excel

  • @rp@n Profile Picture
    @rp@n 4 on at
    RE: Ax data export to excel and save in particular directory

    Yes martin,

    i preferred sysexcelapplication

    please give me the sample code

  • Suggested answer
    Jay Barot Profile Picture
    Jay Barot 1,502 on at
    RE: Ax data export to excel and save in particular directory

    Hi Arpan,

    Please go to this link to have overview on code www.theaxapta.com/.../how-to-readwrite-excel-file-through-x.html

  • Martin Dráb Profile Picture
    Martin Dráb 231,723 Most Valuable Professional on at
    RE: Ax data export to excel and save in particular directory

    Then your first step should be evaluation how you can build the report. Maybe you can use SSRS, maybe Excel Add-In, maybe you can design an Excel template and populate it with data on some way, maybe you need building the whole document in code and so on.

    If - which is not clear at all at the moment - you find out that you must do it all from code, choose the API and then use your favorite search engine to learn how to use it. Consider especially SysExcelApplication (X++) and EPPlus (.NET). for instance.

    If you run into a problem, come here and explain your particular problem.

  • @rp@n Profile Picture
    @rp@n 4 on at
    RE: Ax data export to excel and save in particular directory

    They gave the report format. that i need to show directly in excel.

    means when user run this report from menu item, it will open dialog , then user will  fill from date and to date and press ok.

    then customer wants those data in to EXCEL DIRECTLY and save in particular directory.

    i hope you understand now

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,865 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,723 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans