C# WinForm中DataGridView导出Excel缺失表头问题求助

Got it, let's tackle that missing header issue in your Excel export! The root problem here is that your current code is only looping through the DataGridView's data rows, but not writing out the column headers first. Adding that step is straightforward—here's how to integrate it into your existing method, plus some extra tweaks to make the export cleaner.

First, let's assume you're using the standard Microsoft Office Interop Excel library (since that's the most common approach for WinForm exports). Here's your updated method with header export included:

private void ImportDataGridViewDataToExcelSheet()
{
    string userID = WindowsIdentity.GetCurrent().Name;
    
    // Initialize Excel objects (adjust this part to match your existing code)
    Microsoft.Office.Interop.Excel.Application excelApp = new Microsoft.Office.Interop.Excel.Application();
    Microsoft.Office.Interop.Excel.Workbook workbook = excelApp.Workbooks.Add();
    Microsoft.Office.Interop.Excel.Worksheet worksheet = workbook.ActiveSheet;

    // --- Add this section to export headers ---
    if (dataGridView1.Columns.Count > 0)
    {
        // Write headers to the first row of the Excel sheet
        for (int colIndex = 0; colIndex < dataGridView1.Columns.Count; colIndex++)
        {
            var column = dataGridView1.Columns[colIndex];
            // Optional: Skip hidden columns if you don't want them in the export
            if (!column.Visible) continue;
            
            // Excel uses 1-based indexing, so row 1, column = colIndex + 1
            worksheet.Cells[1, colIndex + 1] = column.HeaderText;
            // Make headers bold for better readability
            worksheet.Cells[1, colIndex + 1].Font.Bold = true;
        }
    }
    // --- End header export section ---

    // Write data rows (start at row 2 since row 1 is headers)
    for (int rowIndex = 0; rowIndex < dataGridView1.Rows.Count; rowIndex++)
    {
        // Skip the blank "new row" that DataGridView adds by default
        if (dataGridView1.Rows[rowIndex].IsNewRow) continue;

        for (int colIndex = 0; colIndex < dataGridView1.Columns.Count; colIndex++)
        {
            var column = dataGridView1.Columns[colIndex];
            if (!column.Visible) continue;
            
            // Handle null values to avoid errors
            var cellValue = dataGridView1.Rows[rowIndex].Cells[colIndex].Value;
            worksheet.Cells[rowIndex + 2, colIndex + 1] = cellValue?.ToString() ?? string.Empty;
        }
    }

    // Show the Excel file (or save it programmatically)
    excelApp.Visible = true;

    // Important: Release COM objects to prevent memory leaks
    // System.Runtime.InteropServices.Marshal.ReleaseComObject(worksheet);
    // System.Runtime.InteropServices.Marshal.ReleaseComObject(workbook);
    // System.Runtime.InteropServices.Marshal.ReleaseComObject(excelApp);
}

Key Notes: #

• 1-based Indexing: Excel uses 1-based row/column numbers, so we offset the DataGridView's 0-based index by 1 when writing to cells.
• Hidden Columns: The if (!column.Visible) continue; check lets you skip columns that are hidden in the DataGridView—remove this line if you want to export all columns regardless of visibility.
• New Row Skip: The IsNewRow check prevents exporting that blank final row that DataGridView adds for new entries.
• Null Handling: cellValue?.ToString() ?? string.Empty ensures we don't throw errors when a cell has a null value.

If you're using a lighter library like EPPlus (which doesn't require Office to be installed on the machine), here's the equivalent header export code:

using OfficeOpenXml;
using System.IO;

private void ImportDataGridViewDataToExcelSheet()
{
    string userID = WindowsIdentity.GetCurrent().Name;
    
    using (ExcelPackage package = new ExcelPackage())
    {
        ExcelWorksheet worksheet = package.Workbook.Worksheets.Add("ExportedData");

        // Export headers
        for (int colIndex = 0; colIndex < dataGridView1.Columns.Count; colIndex++)
        {
            var column = dataGridView1.Columns[colIndex];
            if (!column.Visible) continue;
            worksheet.Cells[1, colIndex + 1].Value = column.HeaderText;
            worksheet.Cells[1, colIndex + 1].Style.Font.Bold = true;
        }

        // Export data rows
        for (int rowIndex = 0; rowIndex < dataGridView1.Rows.Count; rowIndex++)
        {
            if (dataGridView1.Rows[rowIndex].IsNewRow) continue;
            for (int colIndex = 0; colIndex < dataGridView1.Columns.Count; colIndex++)
            {
                var column = dataGridView1.Columns[colIndex];
                if (!column.Visible) continue;
                worksheet.Cells[rowIndex + 2, colIndex + 1].Value = dataGridView1.Rows[rowIndex].Cells[colIndex].Value?.ToString() ?? string.Empty;
            }
        }

        // Save the file
        package.SaveAs(new FileInfo(@"C:\Your\Save\Path\Export.xlsx"));
    }
}

Either way, adding that header loop before your data row loop will fix the missing headers issue. Let me know if you run into any snags with your specific setup!

内容的提问来源于stack exchange，提问作者FunCoder