Csharp C# csvhelper 写入单独的行

发布于03月28日

我正在使用CSVHelper从我的datagridview读取和写入CSV文件.

我可以读取CSV文件，但是当我写入它时，它列出了标题和同一行上的行.

如何在EXCEL中将行单独排成一行？

private void btnWrite_Click(object sender, EventArgs e)
{
    using (SaveFileDialog sfd = new SaveFileDialog() {  Filter = "CSV|*.csv", ValidateNames = true })
    {
        if (sfd.ShowDialog() == DialogResult.OK)
        {
            using (var sw = new StreamWriter(sfd.FileName))
            {
                var csvwriter = new CsvWriter(sw, CultureInfo.CurrentCulture);
                csvwriter.WriteHeader(typeof(Student));

                foreach (Student s in studentBindingSource.DataSource as List<Student>)
                {
                    csvwriter.WriteRecord(s);
                    csvwriter.Flush();
                }
            }

            MessageBox.Show("Data has been saved", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
        }
    }
}

如有任何帮助，我们将不胜感激，提前谢谢您.

推荐答案

如果您要手动写入单个记录(WriteRecord而不是WriteRecords)，或者手动写入标题(WriteHeader)，则需要手动转到下一条记录.

var csvwriter = new CsvWriter(sw, CultureInfo.CurrentCulture);
csvwriter.WriteHeader(typeof(Student));
csvwriter.NextRecord(); // < ---- this

foreach (Student s in studentBindingSource.DataSource as List<Student>)
{
    csvwriter.WriteRecord(s);
    csvwriter.NextRecord(); // < ---- this
}

在CSVHelper's documentation page岁时阅读更多.