NPOI.XSSF.UserModel.XSSFWorkbook.GetNameIndex C# (CSharp) Method

        public int GetNameIndex(String name)
        {
            int i = 0;
            foreach (XSSFName nr in namedRanges)
            {
                if (nr.NameName.Equals(name))
                {
                    return i;
                }
                i++;
            }
            return -1;
        }

 public ExternalName GetExternalName(String nameName, String sheetName, int externalWorkbookNumber)
 {
     if (externalWorkbookNumber > 0)
     {
         // External reference - reference is 1 based, link table is 0 based
         int linkNumber = externalWorkbookNumber - 1;
         ExternalLinksTable linkTable = _uBook.ExternalLinksTable[linkNumber];
         foreach (IName name in linkTable.DefinedNames)
         {
             if (name.NameName.Equals(nameName))
             {
                 // HSSF returns one sheet higher than normal, and various bits
                 //  of the code assume that. So, make us match that behaviour!
                 int nameSheetIndex = name.SheetIndex + 1;
                 // TODO Return a more specialised form of this, see bug #56752
                 // Should include the cached values, for in case that book isn't available
                 // Should support XSSF stuff lookups
                 return(new ExternalName(nameName, -1, nameSheetIndex));
             }
         }
         throw new ArgumentException("Name '" + nameName + "' not found in " +
                                     "reference to " + linkTable.LinkedFileName);
     }
     else
     {
         // Internal reference
         int nameIdx = _uBook.GetNameIndex(nameName);
         return(new ExternalName(nameName, nameIdx, 0));  // TODO Is this right?
     }
 }