如何在C#中将特定列从DataGridView导出到Excel或CSV？

using System;
using System.IO;
using System.Windows.Forms;
using Excel = Microsoft.Office.Interop.Excel;

private void ExportToExcel(DataGridView dataGridView, string filePath, int[] columnIndices)
{
    Excel.Application excelApp = new Excel.Application();
    Excel.Workbook workbook = excelApp.Workbooks.Add();
    Excel.Worksheet worksheet = workbook.ActiveSheet;

    // 导出特定列的标题
    for (int i = 0; i < columnIndices.Length; i++)
    {
        worksheet.Cells[1, i + 1] = dataGridView.Columns[columnIndices[i]].HeaderText;
    }

    // 导出特定列的数据
    for (int i = 0; i < dataGridView.Rows.Count; i++)
    {
        for (int j = 0; j < columnIndices.Length; j++)
        {
            worksheet.Cells[i + 2, j + 1] = dataGridView.Rows[i].Cells[columnIndices[j]].Value.ToString();
        }
    }

    // 保存Excel文件
    workbook.SaveAs(filePath);
    workbook.Close();
    excelApp.Quit();
}

int[] columnIndices = { 0, 2, 4 }; // 需要导出的列的索引
string filePath = "路径/文件名.xlsx"; // 导出文件的路径和名称

ExportToExcel(dataGridView1, filePath, columnIndices);