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,166 Moderator on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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,166 Moderator on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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,166 Moderator on at

Like (1)

Report
Copy link

Link copied!

.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
Copy link

Link copied!

It seems very helpfull...

Thank you very much Nikolaos !!

Was this reply helpful? Yes No