c#对excel读写
时间: 2023-07-07 19:17:36 浏览: 59
C#可以使用Microsoft.Office.Interop.Excel库来对Excel进行读写操作。下面是一个简单的示例代码:
```csharp
using Excel = Microsoft.Office.Interop.Excel;
// 打开Excel文件
Excel.Application excelApp = new Excel.Application();
Excel.Workbook workbook = excelApp.Workbooks.Open(@"C:\example.xlsx");
// 读取数据
Excel.Worksheet worksheet = workbook.Sheets[1];
Excel.Range range = worksheet.UsedRange;
int rowCount = range.Rows.Count;
int colCount = range.Columns.Count;
for (int i = 1; i <= rowCount; i++)
{
for (int j = 1; j <= colCount; j++)
{
string cellValue = range.Cells[i, j].Value2.ToString();
Console.Write(cellValue + "\t");
}
Console.WriteLine();
}
// 写入数据
Excel.Worksheet worksheet2 = workbook.Sheets.Add();
Excel.Range range2 = worksheet2.Range["A1"];
range2.Value2 = "Hello, World!";
// 保存文件并关闭Excel
workbook.Save();
workbook.Close();
excelApp.Quit();
```
需要注意的是,使用Microsoft.Office.Interop.Excel库需要在项目中添加对Microsoft.Office.Interop.Excel.dll的引用。