| Package | Description | 
|---|---|
| org.apache.poi.hssf.usermodel | The usermodel package maps HSSF low level structures to familiar workbook/sheet model | 
| org.apache.poi.ss.formula | This package contains common internal POI code for manipulating formulas. | 
| org.apache.poi.ss.usermodel | |
| org.apache.poi.xssf.model | |
| org.apache.poi.xssf.streaming | |
| org.apache.poi.xssf.usermodel | 
| Modifier and Type | Class and Description | 
|---|---|
| class  | HSSFNameHigh Level Representation of a 'defined name' which could be a 'built-in' name,
 'named range' or name of a user defined function. | 
| Modifier and Type | Method and Description | 
|---|---|
| void | HSSFWorkbook. removeName(Name name)Remove a name. | 
| Modifier and Type | Method and Description | 
|---|---|
| Name | FormulaParsingWorkbook. createName()Return the underlying workbook | 
| Modifier and Type | Method and Description | 
|---|---|
| Name | Workbook. createName()Creates a new (uninitialised) defined name in this workbook | 
| Name | Workbook. getName(java.lang.String name) | 
| Modifier and Type | Method and Description | 
|---|---|
| java.util.List<? extends Name> | Workbook. getAllNames()Returns all defined names. | 
| java.util.List<? extends Name> | Workbook. getNames(java.lang.String name)Returns all defined names with the given name. | 
| Modifier and Type | Method and Description | 
|---|---|
| void | Workbook. removeName(Name name)Remove a defined name | 
| Modifier and Type | Class and Description | 
|---|---|
| protected class  | ExternalLinksTable.ExternalName | 
| Modifier and Type | Method and Description | 
|---|---|
| java.util.List<Name> | ExternalLinksTable. getDefinedNames() | 
| Modifier and Type | Method and Description | 
|---|---|
| Name | SXSSFWorkbook. createName()Creates a new (uninitialised) defined name in this workbook | 
| Name | SXSSFWorkbook. getName(java.lang.String name) | 
| Modifier and Type | Method and Description | 
|---|---|
| java.util.List<? extends Name> | SXSSFWorkbook. getAllNames()Returns all defined names | 
| java.util.List<? extends Name> | SXSSFWorkbook. getNames(java.lang.String name)Returns all defined names with the given name. | 
| Modifier and Type | Method and Description | 
|---|---|
| void | SXSSFWorkbook. removeName(Name name)Remove the given defined name | 
| Modifier and Type | Class and Description | 
|---|---|
| class  | XSSFNameRepresents a defined named range in a SpreadsheetML workbook. | 
| Modifier and Type | Method and Description | 
|---|---|
| XSSFPivotTable | XSSFSheet. createPivotTable(Name source,
                CellReference position)Create a pivot table using the Name range, at the given position. | 
| XSSFPivotTable | XSSFSheet. createPivotTable(Name source,
                CellReference position,
                Sheet sourceSheet)Create a pivot table using the Name range reference on sourceSheet, at the given position. | 
| void | XSSFWorkbook. removeName(Name name) | 
Copyright 2021 The Apache Software Foundation or its licensors, as applicable.