Finance | Project Operations, Human Resources, ...

In X++ Export data to Excel sheet

(0) Share

Report

Posted on by Riyas ahamed F

1,215

Hi guys,

I need to export data from D365FO to an excel sheet of the format as shown to below image.

How to achieve this format in x++ please give us a Example.

Thanks

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

vinitgoyal2005 6,332 on at

Like (0)

Report

Hi Riyas,

Create a data entity if it doesn't exist and export the data using data management in Excel format. Check docs.microsoft.com/.../data-import-export-job

Was this reply helpful? Yes No
Sukrut Parab 71,710 Moderator on at

Like (0)

Report

What data you want to export ? As mentioned by Vinit, can't you use data management to export data ? Are you facing any challenges in creating data entity ?

Was this reply helpful? Yes No
Blue Wang on at

Like (0)

Report

Hi Riyas,

Can you explain your needs? What have you tried or any specific situations?

Is the suggested method not feasible? Data Management or Excel.

If you only want to pass X++ code, have you tried the SysExcel* class?

Please provide more, thanks

Was this reply helpful? Yes No
Riyas ahamed F 1,215 on at

Like (0)

Report

Thanks for your replay ,

No, i'm not used in Data Entity what i want to know in the Runbasebatch class i need it export data Excel as a Table Design above i mentioned how to achieve that process in X++ .

Was this reply helpful? Yes No
Suggested answer

vinitgoyal2005 6,332 on at

Like (1)

Report

Hi Riyas,

When you are exporting excel, where do you want to store it? you cant access the file system as you used to do it in AX 2012. What is the requirement here? Who is using the data from Excel? You can use Power automate for the export of file using data management and email it/ store it in blob storage/Sharepoint etc.

Let us know the business requirement so we can guide you better.

Was this reply helpful? Yes No
Riyas ahamed F 1,215 on at

Like (0)

Report

Thanks for your valuable answer Vinit Goyal ,

we are using on Runbasebatch class In D365Fo and when i click Generate Template in UI it will Export data from excel sheet as a Field column so that we want as a Table design instead of normal Column.

below our Runbasebatch,

this above image Export data bank details

output,

so, now i want to table design in the Excel sheet how to do in my Runbasebatch class give me example.

Thanks

Was this reply helpful? Yes No
vinitgoyal2005 6,332 on at

Like (0)

Report

Hi Riyas,

Can you share your existing code? If I understood correctly, you need the excel to look in a different format? Still did not understand the exact requirement. I see the above output, do you want the column names different? or the background color of header different?

Was this reply helpful? Yes No