public class XSSFWorkbook extends POIXMLDocument implements Workbook
SheetIterator
Visibility | Name | Parameters | Deprecated | External Use | CFG | Call | DFG | |
---|---|---|---|---|---|---|---|---|
public | XSSFWorkbook | XSSFWorkbookType workbookType | Show | Show | Show | |||
public | XSSFWorkbook | InputStream is | Show | Show | Show | |||
public | XSSFWorkbook | File file | Show | Show | Show | |||
public | XSSFWorkbook | String path | Show | Show | Show | |||
public | XSSFWorkbook | Show | Show | Show | ||||
public | XSSFWorkbook | OPCPackage pkg | Show | Show | Show | |||
Visibility | Type | Name | Static | Instance | Final | Deprecated | External Use | DFG | |
---|---|---|---|---|---|---|---|---|---|
private | POILogger | logger | Show | ||||||
private | ListValuedMap | namedRangesByName | Show | ||||||
private | List | namedRanges | Show | ||||||
private | SharedStringsTable | sharedStringSource | Show | ||||||
private | XSSFDataFormat | formatter | Show | ||||||
private | List | pivotTables | Show | ||||||
private | Pattern | COMMA_PATTERN | Show | ||||||
private | int | MAX_SENSITIVE_SHEET_NAME_LEN | Show | ||||||
private | CTWorkbook | workbook | Show | ||||||
private | List | sheets | Show | ||||||
Visibility | Return | Name | Parameters | Static | Instance | Concrete | Deprecated | External Use | CFG | Call | DFG | |
---|---|---|---|---|---|---|---|---|---|---|---|---|
private | void | validateSheetIndex | int index | Show | Show | Show | ||||||
private | void | addRelation | RelationPart rp POIXMLDocumentPart target | Show | Show | Show | ||||||
private | String | getUniqueSheetName | String srcName | Show | Show | Show | ||||||
private | boolean | workbookProtectionPresent | Show | Show | Show | |||||||
private | CTWorkbookProtection | safeGetWorkbookProtection | Show | Show | Show | |||||||
private | XSSFName | createAndStoreName | CTDefinedName ctName | Show | Show | Show | ||||||
private | void | updateNamedRangesAfterSheetReorder | int oldIndex int newIndex | Show | Show | Show | ||||||
private | void | updateActiveSheetAfterSheetReorder | int oldIndex int newIndex | Show | Show | Show | ||||||
private | void | validateSheetName | String sheetName | Show | Show | Show | ||||||
private | void | saveNamedRanges | Show | Show | Show | |||||||
Issue Id | Last Changed | Summary | Status | Severity | Priority | Related Commits | View Report | |
---|---|---|---|---|---|---|---|---|
45018 | 2008-05-28 08:44:09 | [PATCH] Patch to fetch embedded documents from OOXML files | RESOLVED | normal | P2 | Show | ||
45431 | 2016-03-31 06:08:43 | XSSFWorkbook cannot save a macro-enabled Excel (.xlsm) | RESOLVED | normal | P2 | Show | ||
45492 | 2008-09-21 11:57:37 | HSSFCellStyle.getFillBackgroundColor() does always return 64 | RESOLVED | normal | P2 | 0c6a27425 | Show | |
45881 | 2008-09-24 10:57:11 | Fix some examples | RESOLVED | normal | P2 | Show | ||
45894 | 2008-09-25 23:03:03 | patch XSSFWorkbook | RESOLVED | normal | P2 | Show | ||
45899 | 2008-09-28 22:33:05 | patch for XSSFWorkbook | RESOLVED | normal | P2 | Show | ||
45917 | 2008-11-05 20:11:03 | Documentation XSSFFont | RESOLVED | normal | P2 | Show | ||
45920 | 2008-11-05 20:20:09 | Implement XSSFSheet.getDisplayGuts and XSSFSheet.setDisplayGuts | RESOLVED | normal | P2 | Show | ||
45974 | 2008-10-21 10:57:07 | POI 3.5b3: XSSFCell.getCellStyle can return null | RESOLVED | normal | P2 | Show | ||
46003 | 2008-10-17 11:45:42 | Implemented XSSFWorkbook.setPrintArea() | RESOLVED | normal | P2 | Show | ||
Commit Id | Commiter | Date/Time | Summary | Related Issues | View Commit | |
---|---|---|---|---|---|---|
0e44d8da7 | Nick Burch | 2014-08-01 | Fix bug #56800 - Provide a helpful exception, XLSBUnsupportedException, if XSSFWorkbook is passed a .xlsb file | 56800 | Show | |
0f1f7d1d4 | Yegor Kozlov | 2009-07-24 | fixed compatibility issues with OpenOffice 3.0 and Excel 2008 Mac sp2, see Bugzilla #46419 and #47559 | 47559, 46419 | Show | |
0f86c22ae | Yegor Kozlov | 2010-12-02 | Avoid crashing Excel when sorting XSSFSheet autofilter, see Bugzilla 50315 | 50315 | Show | |
0fdd7a1db | Nick Burch | 2014-11-04 | Partial HSSF support for adding new external workbook formula references for #57184 | 57184 | Show | |
0fdfac62c | Dominik Stadler | 2014-12-22 | Bug 57171 and 57163: Adjust the active sheet in setSheetOrder() and removeSheet() for both HSSF and XSSF | 57171, 57163 | Show | |
141294063 | Yegor Kozlov | 2012-10-04 | Bugzilla 53950 - fixed setForceFormulaRecalculation to reset workbook-level manual flag< | 53950 | Show | |
141dc22e8 | Yegor Kozlov | 2009-09-16 | improved work with user-defined functions, see Bugzilla 47809 | 47809 | Show | |
15be6fb33 | Javen O'Neal | 2017-01-20 | bug 60605: convert Workbook.SHEET_STATE_* to SheetVisibility enum | 60605 | Show | |
19a6ad2ab | Yegor Kozlov | 2011-06-27 | Bug 51422 - Support using RecalcIdRecord to trigger a full formula recalculation on load | 51422 | Show | |
1b19410d6 | Yegor Kozlov | 2011-12-07 | Bugzilla 52268 - support cloning sheets with drawings in XSSF | 52268 | Show | |