Microsoft Dynamics AX (Archived)

Export specific data using Export to Excel option

(0) Share

Report

Posted on by Community Member

Hi,

I have multiple tabs in a detail form and each tab will have Export to excel option. Each fast tab has grid.

I have requirement to export selected record from a grid on the current tab to excel.

Please guide how can i achieve this.

Thanks

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

Community Member on at

Like (0)

Report

RE: Export specific data using Export to Excel option

Hi...

I have used the code from this link "https://community.dynamics.com/ax/b/axaptavsme/archive/2013/03/13/exporting-data-to-excel-from-axapta-x", on the RunBaseBatch class, But i have got this error "Method 'item' in COM object of class 'Sheets' returned error code 0x8002000B (<unknown>) which means: <unknown>."

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Export specific data using Export to Excel option

I have used the code from this link on the runBaseBatch class "https://dynamicsaxgyan.wordpress.com/2012/04/24/sysexcelworksheethelper-class-in-ax-2012quickly-create-excel-x/", and i have got this error "Method 'item' in COM object of class 'Sheets' returned error code 0x8002000B (<unknown>) which means: <unknown>.", The error thrown from this line of code "worksheet = sysExcelHelper.addWorksheet("Test");".

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (1)

Report

RE: Export specific data using Export to Excel option

I have found a solution for this.

Override the clicked() method on the Export to excel comand button. In the clicked() method before the super() call, write the below line of code:

element.selectControl([YourGrid]);

Thanks for all your suggestions.

Thanks

Was this reply helpful? Yes No
André Arnaud de Cal... 298,244 Super User 2025 Season 2 on at

Like (0)

Report

RE: Export specific data using Export to Excel option

Hi JeffGreenRC,

In addition to the answer from Vilmos:

Functionally you can also try to use the shortcut CTRL+T.

Was this reply helpful? Yes No
Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report

RE: Export specific data using Export to Excel option

You could just create your own button to do this, since the Export to Excel is a canned framework. You could find some details on this on a Microsoft blog article:

https://blogs.msdn.microsoft.com/emeadaxsupport/2009/09/07/how-does-the-export-to-excel-feature-work-under-the-hood/

Here are some examples how you could create your custom code to do the export:

community.dynamics.com/.../exporting-data-to-excel-from-axapta-x

https://dynamicsaxgyan.wordpress.com/2012/04/24/sysexcelworksheethelper-class-in-ax-2012quickly-create-excel-x/

Was this reply helpful? Yes No