C# WinForm导出Excel本地正常，其他系统报索引错误

Hey there, let's break down what's causing this frustrating "bad indexing" error when your app runs on other machines, and fix it step by step.

核心问题分析 #

1. 硬编码Sheet名称触发索引失败 #

Your code uses workbook.Sheets["Sheet1"] to grab the worksheet, but here's the catch: Office uses localized default sheet names. For example, Chinese systems use "工作表1", Japanese uses "シート1", and so on. When the target machine has a non-English Office, this line returns null—and any subsequent calls to worksheet.Cells[...] will throw the "bad indexing" error because you're trying to access a null object.

2. Office Interop的兼容性依赖 #

Office Interop requires the target machine to have the exact (or compatible) Office version installed that you used during development. Version mismatches (e.g., you used Office 2019, target uses 2016) can also lead to weird indexing or method call failures.

3. DataGridView行处理的潜在隐患 #

You're using PandMGDV.Rows.Count-1 to loop through rows, but DataGridView adds an empty "new row" by default. If the target machine's DGV settings differ, this could lead to trying to read null values, which might trigger a ToString() exception that manifests as an indexing error.

解决方案 #

方案1：修复现有Interop代码（快速临时修复） #

Fix the worksheet access, optimize row handling, and use a proper save dialog instead of hardcoding paths:

// Initialize Excel application
Microsoft.Office.Interop.Excel._Application app = new Microsoft.Office.Interop.Excel.Application();
// Create new workbook
Microsoft.Office.Interop.Excel._Workbook workbook = app.Workbooks.Add(Type.Missing);
// Use index instead of localized sheet name to avoid language issues
Microsoft.Office.Interop.Excel._Worksheet worksheet = workbook.Sheets[1];
worksheet = workbook.ActiveSheet;

// Write header row
for (int i = 1; i < PandMGDV.Columns.Count + 1; i++)
{
    worksheet.Cells[1, i] = PandMGDV.Columns[i - 1].HeaderText;
    worksheet.Cells[1, i].Font.Bold = true;
}

// Write data rows: skip the empty new row
int rowIndex = 2;
foreach (DataGridViewRow row in PandMGDV.Rows)
{
    if (row.IsNewRow) continue;
    for (int colIndex = 0; colIndex < PandMGDV.Columns.Count; colIndex++)
    {
        // Handle null values to avoid ToString() crashes
        var cellValue = row.Cells[colIndex].Value;
        worksheet.Cells[rowIndex, colIndex + 1] = cellValue != null ? cellValue.ToString() : string.Empty;
    }
    rowIndex++;
}

// Use SaveFileDialog to let user choose save path (avoids permission/path errors)
SaveFileDialog saveDialog = new SaveFileDialog();
saveDialog.Filter = "Excel 97-2003 (*.xls)|*.xls|Excel 2007+ (*.xlsx)|*.xlsx";
saveDialog.FileName = "ExportedData";
if (saveDialog.ShowDialog() == DialogResult.OK)
{
    // Pick the correct file format based on user's choice
    var fileFormat = saveDialog.FilterIndex == 1 
        ? Microsoft.Office.Interop.Excel.XlFileFormat.xlWorkbookNormal 
        : Microsoft.Office.Interop.Excel.XlFileFormat.xlOpenXMLWorkbook;
    
    workbook.SaveAs(saveDialog.FileName, fileFormat, Type.Missing, Type.Missing, 
                    Type.Missing, Type.Missing, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlExclusive,
                    Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
    workbook.Close(true, Type.Missing, Type.Missing);
    app.Quit();
    MessageBox.Show($"Excel file saved successfully!\nPath: {saveDialog.FileName}", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
    // Clean up if user cancels save
    workbook.Close(false, Type.Missing, Type.Missing);
    app.Quit();
}

// Prompt to close app
DialogResult closePrompt = MessageBox.Show("Do you want to close the application?", "Exit", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (closePrompt == DialogResult.Yes)
{
    this.Close();
}

方案2：改用无Office依赖的库（长期推荐） #

Office Interop is notoriously finicky with cross-machine compatibility. For a more reliable solution, use open-source libraries like EPPlus or NPOI—they don't require Office to be installed on the target machine.

Here's an example with EPPlus (install via NuGet first):

using OfficeOpenXml;
using System.IO;

// Set license context (required for EPPlus 5+)
ExcelPackage.LicenseContext = LicenseContext.NonCommercial;

SaveFileDialog saveDialog = new SaveFileDialog();
saveDialog.Filter = "Excel 2007+ (*.xlsx)|*.xlsx";
saveDialog.FileName = "ExportedData";
if (saveDialog.ShowDialog() == DialogResult.OK)
{
    using (ExcelPackage excelPackage = new ExcelPackage(new FileInfo(saveDialog.FileName)))
    {
        ExcelWorksheet worksheet = excelPackage.Workbook.Worksheets.Add("ExportedData");
        
        // Write header
        for (int i = 0; i < PandMGDV.Columns.Count; i++)
        {
            worksheet.Cells[1, i + 1].Value = PandMGDV.Columns[i].HeaderText;
            worksheet.Cells[1, i + 1].Style.Font.Bold = true;
        }
        
        // Write data rows
        int rowIndex = 2;
        foreach (DataGridViewRow row in PandMGDV.Rows)
        {
            if (row.IsNewRow) continue;
            for (int colIndex = 0; colIndex < PandMGDV.Columns.Count; colIndex++)
            {
                var cellValue = row.Cells[colIndex].Value;
                worksheet.Cells[rowIndex, colIndex + 1].Value = cellValue != null ? cellValue.ToString() : string.Empty;
            }
            rowIndex++;
        }
        
        excelPackage.Save();
    }
    MessageBox.Show($"Excel file saved successfully!\nPath: {saveDialog.FileName}", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
}

// Prompt to close app
DialogResult closePrompt = MessageBox.Show("Do you want to close the application?", "Exit", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (closePrompt == DialogResult.Yes)
{
    this.Close();
}

关键注意事项 #

• If you stick with Office Interop, ensure the target machine has a compatible Office version installed, and match your project's Interop reference version to it.
• Never hardcode sheet names—use indexes or dynamically create sheets to avoid localization issues.
• Always use SaveFileDialog instead of InputBox for save paths to avoid permission errors and invalid directory issues.

内容的提问来源于stack exchange，提问作者Owais.Afsar