Notifications
Announcements
No record found.
Hi,
Does anybody know whether you are able to export data direct from AX to Excel.
Many Thanks,
Clyde
*This post is locked for comments
Hello Clyde,
If you are printing a report and want to export the results to Excel you can do that through Printer Setup export as txt file and then import the file into excel.
Also try Administration > Periodic > Data export/import > Excel spreadsheets
Regards,Abdallah
Or you can select records on a grid in DAX forms, then copy and paste them to Excel.
George
In AX 2009, you can export the contents of any grid to excel. For list pages, use the general tab and you will see an "Export to Excel" button. For other grids, there is an Excel icon on the toolbar above the grid.
Thanks,
Tom
COM excel = new COM('Excel.Application');
COM workbooks = excel.workbooks();
COM workbook = workbooks.add();
COM worksheets = workbook.worksheets();
COM worksheet = worksheets.item(1);
COM cell;
void variant2COM(COM _COM, COMVariant _variant)
{
_COM.attach(_variant.iDispatch());
}
;
cell = worksheet.cells();
variant2COM(cell, cell.item(1,1));
cell.value2("Hello world!");
excel.visible(true);
excel = null;
workbooks = null;
workbook = null;
worksheets = null;
worksheet = null;
cell = null;
Hi, Tom
when i click the button "Export to excel", AX always popup error"Method 'pasteSpecial' in COM object of class '_Worksheet' returned error code 0x800A03EC (<unknown>) which means: Microsoft Office Excel cannot paste the data."
btw, my instance is as below:
Hope to hear your opinion, thanks.
Mike
Hy Mike
I have the same problem when i try to export my datas to Excel with the same error message. Have you found a solution about this problem? Can you give me a hint how you have solved the Problem?
Regards Seiko
Hello Mike & Seiko.
I don't known what is concret problem in your case...
But.
I have problem with paste data to Excel worksheet when merged cells exist in grid.
May be you have the same problem?
Problem with merged cells have not solved yet.
Andrey.
Hi MIke, I will pass this on to the developers who worked on this feature and get back with you.
Thanks for your help. Btw, can you provide your AX 2009 version number to us.
Regards,
Mike,
Hi Clyde
Can you plz do this?
Administration>Perodic>DataExportImport>Excel Export
Choose Definition Group (The table name you want to Export with Data)
Click on Folder Icon and Creat an Excel File on your PC (Desktop/Folder in any location)
Click OK
if it doesn't happen then plz check the Settings or contact any developer/administrator
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 4 Most Valuable Professional
Priya_K 4
MyDynamicsNAV 2
