Created attachment 30596 [details] Excel file used for reproduction of issue Names that refer to Excel tables (Excel 2007+) have no associated sheet although an Excel table is linked to a worksheet. See the following example: XSSFWorkbook wbook = (XSSFWorkbook) WorkbookFactory.create(new File("ExcelTables.xlsx")); // file attached Name nm = wbook.getName("TableAsRangeName"); System.out.println(nm.getRefersToFormula()); // gives TableName[#All] System.out.println(nm.getSheetName()); // gives null ... // ... although tables are associated to a worksheet for(XSSFTable t : wbook.getSheet("ExcelTable").getTables()) { System.out.println(t.getName()); }
Added disabled unit test in r1748606. This fails on POI 3.15-beta 2 because CellReference is used to parse the sheet name from "TableName[#All]", but cannot handle this cell reference format.