从Android中的ListView中删除最后一项时出错(Error when removing last item from ListView in Android)

 我相信您要查找的术语是命名范围 （尽管它们在某些版本的Excel中的功能区的“公式”选项卡中定义）。 假设你是这个意思： 
 
  
 
 然后，Apache POI需要的关键方法是： 
 
 
 
 Workbook.getNumberOfNames（） 
 
 
 Workbook.getName（字符串） 
 
 
 Workbook.getNameAt（INT） 
 
 
 Workbook.createName（） 
 
 
 如果你知道范围的名称，并想要得到它所指的单元格，你就会做类似的事情 
 
Workbook wb = WorkbookFactory.create(new File("input.xls"));
Name name = wb.getName("TestRange");

System.out.println("Named Range '" + name.getNameName() + 
                   "' points to " + name.getRefersToFormula());
 
 对于上述情况，将打印出来 
 
 Named Range 'TesRange' points to Sheet1!$A$1:$C$5

I believe that the term you are looking for is a Named Range (though they are defined in the Formula tab of the ribbon in some versions of Excel). Assuming you mean this:
 
 
Then the key methods you need from Apache POI are:
 
 
 
Workbook.getNumberOfNames()
 
 
Workbook.getName(String)
 
 
Workbook.getNameAt(int)
 
 
Workbook.createName()
 
 
If you know the name of the range, and want to get the cells it refers to, you'd do something like
 
Workbook wb = WorkbookFactory.create(new File("input.xls"));
Name name = wb.getName("TestRange");

System.out.println("Named Range '" + name.getNameName() + 
                   "' points to " + name.getRefersToFormula());
 
Which for the case above would print
 
 Named Range 'TesRange' points to Sheet1!$A$1:$C$5