如何用c#实现带格式的excel列自动调整

using Excel = Microsoft.Office.Interop.Excel;

// 创建Excel应用程序对象
Excel.Application excelApp = new Excel.Application();
excelApp.Visible = true;

// 打开已存在的Excel文件或者创建新的Excel文件
Excel.Workbook workbook = excelApp.Workbooks.Open("your_file_path.xlsx");
// 或者
Excel.Workbook workbook = excelApp.Workbooks.Add();

// 获取第一个工作表
Excel.Worksheet worksheet = workbook.Worksheets[1];
// 或者通过工作表名称获取
Excel.Worksheet worksheet = workbook.Worksheets["Sheet1"];

// 写入数据
worksheet.Cells[1, 1] = "Header 1";
worksheet.Cells[1, 2] = "Header 2";
worksheet.Cells[2, 1] = "Data 1";
worksheet.Cells[2, 2] = "Data 2";

// 设置单元格格式
Excel.Range headerRange = worksheet.Range["A1:B1"];
headerRange.Font.Bold = true;
headerRange.Interior.Color = System.Drawing.Color.LightGray;

Excel.Range dataRange = worksheet.Range["A2:B2"];
dataRange.Font.Bold = false;
dataRange.Interior.Color = System.Drawing.Color.White;

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

// 保存文件
workbook.SaveAs("your_file_path.xlsx");

// 关闭Excel应用程序
workbook.Close();
excelApp.Quit();