Link to home
Start Free TrialLog in
Avatar of fwstealer
fwstealerFlag for United States of America

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();
        }

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of libby9284
libby9284
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial