项目需求:
为了版本管理的需求,Excel文档 往往会使用到 named ranges/命名区域。
下面讲解一下 怎么使用NPOI 读取named ranges
named ranges demo
1. NPOI dll 下载
2.使用NPOI 读取EXCEL文件
3.
Dictionary<string, string> namedRangesDictionary = new Dictionary<string, string>();
XSSFWorkbook book1 = new XSSFWorkbook(new FileStream("namedRangeTest.xlsm", FileMode.Open));
IName name1 = book1.GetName("SencondName");
CellReference cr2 = new CellReference(name1.RefersToFormula);
ICell cell2 = book1.GetSheet(cr2.SheetName).GetRow(cr2.Row).GetCell(cr2.Col);
CellType type = cell2.CellType;
if(type == CellType.Numeric)
{
namedRangesDictionary.Add("Opportunity_Number", cell2.NumericCellValue.ToString());
}