fwstealer
asked on
export datagridview to csv - remove last character in row
how do i remove the last delimiter in a row when it exports the data to a csv file? i have a ; at the end.
private void btnExport_Click(object sender, EventArgs e)
{
//don't append ; at end of row
System.IO.StreamWriter streamWriter = new System.IO.StreamWriter(@"C:\Projects\Excel\csvExported.csv");
string strHeader = "";
for (int i = 0; i < dgvConverted.Columns.Count; i++)
{
strHeader += dgvConverted.Columns[i].HeaderText + ";"; //use ; instead of ,
}
//streamWriter.WriteLine(strHeader); //don't write headers
for (int m = 0; m < dgvConverted.Rows.Count; m++)
{
string strRowValue = "";
for (int n = 0; n < dgvConverted.Columns.Count; n++)
{
strRowValue += dgvConverted.Rows[m].Cells[n].Value + ";"; //use ; instead of ,
}
streamWriter.WriteLine(strRowValue);
}
streamWriter.Close();
}
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.