we are using closed xml library to export a excel file from AX with type csv comma delimited

(0) Share

Report

Posted on by MDeeb

Hi All,

when we try to open the csv file with note pad after it was exported from AX through the closedXML library, the file opens in different format with different characters inside as per below pic , so we have to manually save the file as csv comma delimted then it open with correct format, how can we solve this issue that after the export it opens in right format ?

Thank you,

I have the same question (0)

All responses (9)

Answers (2)

MDeeb 90 on at

Like (0)

Report

RE: we are using closed xml library to export a excel file from AX with type csv comma delimited

Thanks a lot Nikolaos, the team has used the TextIO, and is exporting it to CSV.

Thanks.

Was this reply helpful? Yes No
Verified answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

RE: we are using closed xml library to export a excel file from AX with type csv comma delimited

Sorry, actually you need to use TextIO instead of CommaIO if you don't want to have the quotation marks. In normal CSV string values are surrounded by quotation marks, to avoid issues where the string field contains the delimiter character (such as comma).

Are you sure it's not ok to have the quotation marks there? I would assume that the application who reads this file knows how to handle it.

Was this reply helpful? Yes No
MDeeb 90 on at

Like (0)

Report

RE: we are using closed xml library to export a excel file from AX with type csv comma delimited

Thank you Nikolaos, replaced the write with writeexp but with same output.

Regards,

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

RE: we are using closed xml library to export a excel file from AX with type csv comma delimited

Try commaIo.WriteExp method instead of the write method.

Was this reply helpful? Yes No
MDeeb 90 on at

Like (0)

Report

RE: we are using closed xml library to export a excel file from AX with type csv comma delimited

Thank you Nikolaos for your response : below is the code and the output

Was this reply helpful? Yes No
nmaenpaa 101,160 Moderator on at

Like (0)

Report

RE: we are using closed xml library to export a excel file from AX with type csv comma delimited

Instead of removing, I would focus on not writing the quotation marks in the file in the first place.

How to do that in your case depends quite a lot on your implementation. Perhaps you can share your code, then we can suggest how to change it?

Was this reply helpful? Yes No
MDeeb 90 on at

Like (0)

Report

RE: we are using closed xml library to export a excel file from AX with type csv comma delimited

Hi Martin,

i have a question please :

we are trying to generate a csv file when the WF is completed. the file is generated successfully but when we try to open it with note pad the value appear with "" is there any way to remove the "" .

Thank you

Was this reply helpful? Yes No
MDeeb 90 on at

Like (0)

Report

RE: we are using closed xml library to export a excel file from AX with type csv comma delimited

Thank you Martin.

Was this reply helpful? Yes No
Verified answer

Martin Dráb 235,818 Most Valuable Professional on at

Like (0)

Report

RE: we are using closed xml library to export a excel file from AX with type csv comma delimited

This is not a CSV file. It's an Excel file, which isn't a huge surprise, since you used a library for working with Excel files.

So either your fine with getting an Excel file, or you'll have to change your implementation.

Was this reply helpful? Yes No