Hide zeros in Excel export

(0) Share

Report

Posted on by SGbron

157

Hello everyone

I try to export the fields of a table with sysExcelApplication.

in one of the fields, where i have the itemid(which is string) when the export finished all zeros that leading the itemId number are disappered.

That has no sense because is a string.

Also I tried to change the format of the cells of the excel file to "text" but nothing happened.

the code I have to export my cells is ....

excelWorksheet.cells().item(i,2).value(collectionProdJournalBOM.ItemId);

does anyone know why this happens?

I have the same question (0)

All responses (6)

Answers (1)

nmaenpaa 101,160 Moderator on at

Like (0)

Report

RE: Hide zeros in Excel export

Could you share the code where you set the formatting of the cell?

Was this reply helpful? Yes No
SGbron 157 on at

Like (0)

Report

RE: Hide zeros in Excel export

I dont have code in my class for the format of the cell of excel.

The only thing that has to do with this specific field is the line of code that I wrote above.

I found a way to change it inthe cell of the Excel file with a custom formating but I dont want to do it manually.

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

RE: Hide zeros in Excel export

May I suggest that you add some code to ensure correct cell formatting.

Was this reply helpful? Yes No
SGbron 157 on at

Like (0)

Report

RE: Hide zeros in Excel export

the only thing that I can imagine for coding is

excelWorksheet.cells().item(i,2).value(collectionProdJournalBOM.ItemId).toString();

but it also didnt work.....

Do you have any better idea to ensure the formatting?

Was this reply helpful? Yes No
Verified answer

nmaenpaa 101,160 Moderator on at

Like (1)

Report

RE: Hide zeros in Excel export

.toString() function doesn't impact the format of Excel cells in any way.

I did a quick web search for you (using search terms "dynamics ax 2009 sysExcelApplication export format cells"):

shekhardiptiman.wordpress.com/.../

Was this reply helpful? Yes No
SGbron 157 on at

Like (0)

Report

RE: Hide zeros in Excel export

It seems very helpfull...

Thank you very much Nikolaos !!

Was this reply helpful? Yes No

Join the conversation

Community site session details

Hide zeros in Excel export

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

Hide zeros in Excel export

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