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)

Verified answer

Martin Dráb 239,040 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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
MDeeb 98 on at

Like (0)

Report
Copy link

Link copied!

Thank you Martin.

Was this reply helpful? Yes No
MDeeb 98 on at

Like (0)

Report
Copy link

Link copied!

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

Like (0)

Report
Copy link

Link copied!

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 98 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,166 Moderator on at

Like (0)

Report
Copy link

Link copied!

Try commaIo.WriteExp method instead of the write method.

Was this reply helpful? Yes No
MDeeb 98 on at

Like (0)

Report
Copy link

Link copied!

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

Regards,

Was this reply helpful? Yes No
Verified answer

nmaenpaa 101,166 Moderator on at

Like (0)

Report
Copy link

Link copied!

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 98 on at

Like (0)

Report
Copy link

Link copied!

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

Thanks.

Was this reply helpful? Yes No