c#操作excel的方法

C#可以通过Microsoft.Office.Interop.Excel库来操作Excel，具体步骤如下：

1. 引用Excel库

在项目中添加引用，选择COM，找到Microsoft Excel XX.X Object Library，添加即可。

2. 创建Excel对象

using Microsoft.Office.Interop.Excel;

Application excelApp = new Application();

3. 打开Excel文件

Workbook workbook = excelApp.Workbooks.Open("文件路径");

4. 操作Excel表格

Worksheet worksheet = workbook.Sheets[1];

//读取单元格的值 Range range = worksheet.Cells[1, 1]; string value = range.Value;

//写入单元格的值 Range range = worksheet.Cells[1, 1]; range.Value = "Hello World";

//设置单元格样式 Range range = worksheet.Cells[1, 1]; range.Font.Bold = true; range.Interior.Color = XlRgbColor.rgbRed;

5. 保存Excel文件并关闭

workbook.Save(); workbook.Close();

6. 释放资源

Marshal.ReleaseComObject(range); Marshal.ReleaseComObject(worksheet); Marshal.ReleaseComObject(workbook); Marshal.ReleaseComObject(excelApp)