如何使用C# .NET为excel添加自动调整列数据

using System;
using Microsoft.Office.Interop.Excel;

class Program
{
    static void Main(string[] args)
    {
        Application excelApp = new Application();
        Workbook workbook = excelApp.Workbooks.Add(Type.Missing);
        Worksheet worksheet = workbook.Sheets[1];

        // 写入数据
        worksheet.Cells[1, 1] = "Name";
        worksheet.Cells[1, 2] = "Age";
        worksheet.Cells[2, 1] = "Alice";
        worksheet.Cells[2, 2] = 30;
        worksheet.Cells[3, 1] = "Bob";
        worksheet.Cells[3, 2] = 25;

        // 自动调整列宽
        worksheet.Columns.AutoFit();

        // 保存文件
        workbook.SaveAs("example.xlsx", XlFileFormat.xlOpenXMLWorkbook, Type.Missing, Type.Missing, Type.Missing, Type.Missing, XlSaveAsAccessMode.xlExclusive, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);

        // 关闭工作簿和应用程序
        workbook.Close(false, Type.Missing, Type.Missing);
        excelApp.Quit();
    }
}

worksheet.Columns[1].ColumnWidth = 0; // 重置第一列的宽度
worksheet.Columns.AutoFit();

try
{
    Application excelApp = new Application();
    Workbook workbook = excelApp.Workbooks.Open("path_to_your_file.xlsx");
    // 其他操作...
}
catch (Exception ex)
{
    Console.WriteLine("Error: " + ex.Message);
}