https://issues.apache.org/bugzilla/show_bug.cgi?id=55273
Bug ID: 55273
Summary: Names referring to Excel tables have no associated
sheet
Product: POI
Version: 3.10-dev
Hardware: PC
OS: Linux
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
Assignee: [email protected]
Reporter: [email protected]
Created attachment 30596
--> https://issues.apache.org/bugzilla/attachment.cgi?id=30596&action=edit
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());
}
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
