C#中导出dataGridView数据为Excel

C#中导出dataGridView数据为Excel

#region 导出Excel功能函数
/// <summary>
///  dataGridView 导出Excel功能函数
/// </summary>
/// <param name="dataView">dataGridView数据表</param>
/// <param name="filePath">路径</param>
private void ExportDataToExcel(DataGridView dataView, string filePath)
{
    try
    {
        using (StreamWriter writer = new StreamWriter(filePath, false, Encoding.UTF8))
        {
            // 写入表头
            for (int i = 0; i < dataView.Columns.Count; i++)
            {
                writer.Write(dataView.Columns[i].HeaderText);
                if (i < dataView.Columns.Count - 1)
                {
                    writer.Write(",");
                }
            }
            writer.WriteLine();

            // 写入数据
            foreach (DataGridViewRow row in dataView.Rows)
            {
                if (!row.IsNewRow) // 忽略新行
                {
                    for (int i = 0; i < dataView.Columns.Count; i++)
                    {
                        writer.Write(row.Cells[i].Value?.ToString());
                        if (i < dataView.Columns.Count - 1)
                        {
                            writer.Write(",");
                        }
                    }
                    writer.WriteLine();
                }
            }
        }

        MessageBox.Show("Data exported successfully.", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
    }
    catch (Exception ex)
    {
        MessageBox.Show("Error exporting data: " + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
    }
}

#endregion

按键

     private void menuExportFile_Click(object sender, EventArgs e)
     {
         using (SaveFileDialog saveFileDialog = new SaveFileDialog())
         {
             saveFileDialog.Filter = "Excel files (*.xlsx)|*.xlsx|CSV files (*.csv)|*.csv";
             saveFileDialog.Title = "Save as";
             saveFileDialog.FileName = $"{DateTime.Now:yyyyMMddHHmmss}"; // 默认文件名，以当前时间命名

             if (saveFileDialog.ShowDialog() == DialogResult.OK)
             {
                 string filePath = saveFileDialog.FileName;
                 string fileExtension = Path.GetExtension(filePath).ToLower();

                 if (fileExtension == ".csv")
                 {
                     ExportDataToExcel(dataView,filePath);
                 }
                 else if (fileExtension == ".xlsx")
                 {
                     ExportDataToExcel(dataView, filePath);
                 }
                 else
                 {
                     MessageBox.Show("Unsupported file format.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                 }
             }
         }
     }