c# - 使用c#将datagridview数据导出到csv文件

Question

我可以将 datagriview 导出到 csv 但导出一行数据和
下一行空行正在创建
没有空行它应该导出到 csv 文件
如何删除空行

internal void ExtractDataToCSV(DataGridView dgv)
{
    try
    {
            var fDialog = new SaveFileDialog();
            fDialog.Filter = "csv Files (*.csv,*.csv)|*.csv;*.csv";
            if (fDialog.ShowDialog() == DialogResult.OK && !string.IsNullOrEmpty(fDialog.FileName))
            {
                StreamWriter sw = new StreamWriter(fDialog.FileName);
                for (int i = 0; i < dgv.Columns.Count; i++)
                {
                    sw.Write(dgv.Columns[i].HeaderText);
                    sw.Write(",");
                }
                sw.Write(sw.NewLine);
                foreach (DataGridViewRow dr in dgv.Rows)
                {
                    for (int i = 0; i < dgv.Columns.Count; i++)
                    {
                        sw.Write(dr.Cells[i].Value);
                        sw.Write(",");
                    }
                    sw.Write(sw.NewLine);
                }
                sw.Close();
            }
        }
        catch (Exception ex)
        {
            throw ex;
        }
}

private void BtnUserInfo_Click(object sender, EventArgs e)
{

    ObjCsvFileIO = new CsvFileIO();
    dgv.DataSource = ObjCsvFileIO.ReadCsvFile(string CSVFilePathName);

 }

输出

预期产出

标签： c#

Answer 1

删除标记线。此代码为您生成额外的空白行。