OfficeOpenXml
Excel操作库
打开
// 打开文件
using ExcelPackage package = new(new FileInfo("path/to/file"));
// 打开工作表
ExcelWorksheet worksheet = package.Workbook.Worksheets["sheet_name"];清空表
worksheet.Cells.Clear();读取/写入
// 读取指定坐标内容
var value = worksheet.Cells[row, column].Value?.ToString();
var value = worksheet.Cells[row, column].Value?.ToString().ToInt();
// 写入指定坐标内容
worksheet.Cells[row, column].Value = "NewValue";遍历
for (int row = 1; row <= worksheet.Dimension.Rows; row++) {
for (int columns = 1; columns <= worksheet.Dimension.Columns; columns++) {
worksheet.Cells[row, column].Value
}
}保存
package.Save();