Why csv file doesnt show special characters when export?

Hi,

I have this code used on my application to export datagridview as csv file.It worked fine but csv doesnt show cell values correclty.See below images and I have pasted my code as well.What can I change on this code to fix this?

Here is the datagridview

This is the exported csv and it shows like this

Here is my code

public void writeCSV(DataGridView gridIn, string outputFile)
{
//test to see if the DataGridView has any rows
if (gridIn.RowCount > 0)
{
string value = "";
DataGridViewRow dr = new DataGridViewRow();
StreamWriter swOut = new StreamWriter(outputFile);
//write header rows to csv
for (int i = 0; i <= gridIn.Columns.Count - 1; i++)
{
if (i > 0)
{
swOut.Write(",");
}
swOut.Write(gridIn.Columns[i].HeaderText);
}
swOut.WriteLine();
//write DataGridView rows to csv
for (int j = 0; j <= gridIn.Rows.Count - 2; j++)
{
if (j > 0)
{
swOut.WriteLine();
}
dr = gridIn.Rows[j];
for (int i = 0; i <= gridIn.Columns.Count - 1; i++)
{
if (i > 0)
{
swOut.Write(",");
}
value = dr.Cells[i].Value.ToString();
//replace comma's with spaces
value = value.Replace(',', ' ');
//replace embedded newlines with spaces
value = value.Replace(Environment.NewLine, " ");
swOut.Write(value);
}
}
swOut.Close();
}
}

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nilesh Shah9y ago
Accepted answer
Hi, i think the problem is with encoding

I don't know what's the encoding of your excel file, but try one of these 3 shold work:

replace your line
StreamWriter swOut = new StreamWriter(outputFile);
with either of (do trial and error)
StreamWriter swOut = new StreamWriter(outputFile, true, Encoding.ASCII);
StreamWriter swOut = new StreamWriter(outputFile, true, Encoding.Unicode);
StreamWriter swOut = new StreamWriter(outputFile, true, Encoding.GetEncoding("iso-8859-1"));
Nilesh Shah9y ago
@RD Design
please tell us which one worked for u?

thanks!
Guest User9y ago
Have you tried specifying UTF8 encoding in the StreamWriter's constructor?

Why csv file doesnt show special characters when export?

@RD Design