OfficeOpenXml

Excel操作库

打开

CS
// 打开文件
using ExcelPackage package = new(new FileInfo("path/to/file"));
// 打开工作表
ExcelWorksheet worksheet = package.Workbook.Worksheets["sheet_name"];
点击展开查看更多

清空表

CS
worksheet.Cells.Clear();
点击展开查看更多

读取/写入

CS
// 读取指定坐标内容
var value = worksheet.Cells[row, column].Value?.ToString();
var value = worksheet.Cells[row, column].Value?.ToString().ToInt();

// 写入指定坐标内容
worksheet.Cells[row, column].Value = "NewValue";
点击展开查看更多

遍历

CS
for (int row = 1; row <= worksheet.Dimension.Rows; row++) {
	for (int columns = 1; columns <= worksheet.Dimension.Columns; columns++) {
		worksheet.Cells[row, column].Value
	}
}
点击展开查看更多

保存

CS
package.Save();
点击展开查看更多

版权声明

作者: Chaim

链接: https://chaim.eu.org/posts/officeopenxml/

许可证: CC BY-NC-SA 4.0

This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License. Please attribute the source, use non-commercially, and maintain the same license.

开始搜索

输入关键词搜索文章内容

↑↓
ESC
⌘K 快捷键