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 |
HSSFName
High 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)
As
HSSFWorkbook.removeName(String) is not necessarily unique
(name + sheet index is unique), this method is more accurate. |
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) |
Name |
Workbook.getNameAt(int nameIndex)
Deprecated.
4.0.0. New projects should avoid accessing named ranges by index.
|
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) |
Name |
SXSSFWorkbook.getNameAt(int nameIndex)
Deprecated.
3.16. New projects should avoid accessing named ranges by index.
|
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 |
XSSFName
Represents 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)
As
XSSFWorkbook.removeName(String) is not necessarily unique
(name + sheet index is unique), this method is more accurate. |
Copyright 2020 The Apache Software Foundation or its licensors, as applicable.