在.CSV中导出包含多行行的datagridview

private void ExportToCSV(DataGridView dataGridView, string filePath)
{
    StringBuilder sb = new StringBuilder();

    // 添加列标题
    foreach (DataGridViewColumn column in dataGridView.Columns)
    {
        sb.Append(column.HeaderText);
        sb.Append(",");
    }
    sb.AppendLine();

    // 添加数据行
    foreach (DataGridViewRow row in dataGridView.Rows)
    {
        foreach (DataGridViewCell cell in row.Cells)
        {
            // 处理特殊字符
            string cellValue = cell.Value.ToString().Replace(",", "\\,");
            sb.Append(cellValue);
            sb.Append(",");
        }
        sb.AppendLine();
    }

    // 写入到CSV文件
    File.WriteAllText(filePath, sb.ToString());
}

string filePath = "data.csv";
ExportToCSV(dataGridView1, filePath);