使用Excel Interop在Visual C#中一次设置多个单元格

using Excel = Microsoft.Office.Interop.Excel;

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

// 打开Excel文件
Excel.Workbook workbook = excelApp.Workbooks.Open("文件路径");
Excel.Worksheet worksheet = workbook.ActiveSheet;

// 选择要设置的单元格范围
Excel.Range range = worksheet.Range["A1:B2"];

// 设置单元格的值
range.Value = "Hello World";

// 设置单元格的字体颜色为红色
range.Font.Color = Excel.XlRgbColor.rgbRed;

// 设置单元格的背景色为黄色
range.Interior.Color = Excel.XlRgbColor.rgbYellow;

// 设置单元格的边框样式
range.BorderAround(Excel.XlLineStyle.xlContinuous, Excel.XlBorderWeight.xlThin);

// 保存Excel文件
workbook.Save();

// 关闭Excel文件
workbook.Close();

// 释放资源
System.Runtime.InteropServices.Marshal.ReleaseComObject(range);
System.Runtime.InteropServices.Marshal.ReleaseComObject(worksheet);
System.Runtime.InteropServices.Marshal.ReleaseComObject(workbook);
System.Runtime.InteropServices.Marshal.ReleaseComObject(excelApp);