C# CSV problem

[PenguinPig]

Dear All

I am using C# + XML + XSLT to export the search result from the SQL Server.

And the result CSV contains utf-8 character. Before save in CSV, I need
remove the link <?xml version="1.0" encoding="utf-8"?> from the xslt file.

It can be display correctly in the Notepad. But it I open it in the Excel,
it display incorrectly.

Do anyone faced the same problem? And how to solve it?

Thanks

 

[Guest]

This tag is necessary because via this Excel recognize that the file is an
XML file. Because how can you call some one if some one doesnt has an
identity.