NPOI 读取 named ranges /命名区域

项目需求：

为了版本管理的需求，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());
    }