Text Formatting of Excel cells to export data through code

(0) Share

Report

Posted on by Raghavendra M Rao

Hi All,

Is it possible to format an excel cell to 'Text' before exporting data to excel by x++ code?
For example, a String field value stored in AX as 000011 should be exported to excel without omitting 0's.

Below code only exports 11 to the excel cell without the 0's.
xlsWorkSheet.cells().item(row,1).value(xxxx.abc);

Any help is much appreciated.

Thank you

I have the same question (0)

All responses (5)

Answers (1)

WillWU 22,361 on at

Like (0)

Report

Hi Raghavendra,

What's type of the field "xxxx.abc"?

If it is a string field, you just need to set the format of the column in Excel.

https://community.dynamics.com/ax/b/hellodax/posts/formating-cells-when-export-to-excel-example-code

Was this reply helpful? Yes No
Raghavendra M Rao 45 on at

Like (0)

Report

Hi Will,

Thanks for your response.

Yes the field mentioned is a String field in AX. Let's say the field has data like 000123, 000011, XYZ etc.

I have below concerns:

1. Formatting the cell to TEXT in excel after data is exported won't bring back the 0's.

2. I have referred to the link you shared above. It mainly focuses on number formatting and other type conversions used to extract the data needed to file.

In my case, I don't need any type conversion as the field is STRING.

Please help me if you know how to format the column to TEXT by x++ code before extracting data?

xlsWorkSheet.cells().range(strFmt("H%1:H%1",row)).numberFormat("00000000000000");

Can the above be somehow applied to TEXT formatting? I tried but to no avail.

Thanks

Was this reply helpful? Yes No
Verified answer

WillWU 22,361 on at

Like (0)

Report

Hi Raghavendra,

Is the length of your field fixed?

You could try to set the format like this in Excel.

Was this reply helpful? Yes No
Raghavendra M Rao 45 on at

Like (0)

Report

Thanks Will. But any idea how we could go about this when the field length is not fixed?

Was this reply helpful? Yes No
WillWU 22,361 on at

Like (0)

Report

Hi Raghavendra,

Actually when you export data to excel, text will remain text, numbers will remain numbers, you could open the excel with text to check.

Did you try to change the format of the cells to text?

Was this reply helpful? Yes No

Join the conversation

Community site session details

Text Formatting of Excel cells to export data through code

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Text Formatting of Excel cells to export data through code

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates