JavaScript is disabled on your browser.
Skip navigation links
Overview
Package
Class
Use
Tree
Deprecated
Index
Help
Prev
Next
Frames
No Frames
All Classes
A
B
C
D
E
F
G
H
I
N
O
P
R
S
T
U
V
X
Z
A
AreaEvalHelper
- Class in
org.zkoss.poi.ss.formula
Formula Area evaluation helper class.
AreaEvalHelper()
- Constructor for class org.zkoss.poi.ss.formula.
AreaEvalHelper
B
basisToDouble(int, Date, Date, int)
- Static method in class org.zkoss.poi.ss.formula.functions.
UtilFns
C
CAL_GMT
- Static variable in class org.zkoss.poi.ss.formula.functions.
UtilFns
checkValue(double)
- Static method in class org.zkoss.poi.ss.formula.functions.
NumericFunctionHelper
Classes
- Class in
org.zkoss.zpoiex.util
Classes()
- Constructor for class org.zkoss.zpoiex.util.
Classes
commit()
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotCache
commit()
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotCacheRecords
commit()
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotTable
Complex
- Class in
org.zkoss.poi.ss.formula.functions
Complex(double, double, String)
- Constructor for class org.zkoss.poi.ss.formula.functions.
Complex
Complex(double, double)
- Constructor for class org.zkoss.poi.ss.formula.functions.
Complex
ComplexFormat
- Class in
org.zkoss.poi.ss.formula.functions
ComplexFormat()
- Constructor for class org.zkoss.poi.ss.formula.functions.
ComplexFormat
ComplexFormat(NumberFormat, NumberFormat)
- Constructor for class org.zkoss.poi.ss.formula.functions.
ComplexFormat
ComplexFormat(NumberFormat)
- Constructor for class org.zkoss.poi.ss.formula.functions.
ComplexFormat
ComplexFormat(String, NumberFormat, NumberFormat)
- Constructor for class org.zkoss.poi.ss.formula.functions.
ComplexFormat
ComplexFormat(String, NumberFormat)
- Constructor for class org.zkoss.poi.ss.formula.functions.
ComplexFormat
ComplexFormat(String)
- Constructor for class org.zkoss.poi.ss.formula.functions.
ComplexFormat
createPivotCache(AreaReference, Workbook)
- Method in class org.zkoss.zpoiex.ss.usermodel.helpers.
PivotTableHelper
createPivotTable(CellReference, String, PivotCache, Sheet)
- Method in class org.zkoss.zpoiex.ss.usermodel.helpers.
PivotTableHelper
cToComplex(Complex, String)
- Static method in class org.zkoss.poi.ss.formula.functions.
UtilFns
Convert the complex to complex.
D
dateToDays(Date)
- Static method in class org.zkoss.poi.ss.formula.functions.
UtilFns
Returns number of days since 1900-1-0; i.e.
daysToDate(int)
- Static method in class org.zkoss.poi.ss.formula.functions.
UtilFns
Returns a
Date
of a given number of days since 1900-1-1 (inclusive); i.e.
dsm(Date, Date, int)
- Static method in class org.zkoss.poi.ss.formula.functions.
UtilFns
E
equals(Object)
- Method in class org.zkoss.poi.ss.formula.functions.
Complex
equals(Object)
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotField.XSSFItem
equals(Object, Object)
- Static method in class org.zkoss.zpoiex.util.
Objects
Tests whether two objects are equals.
evaluateDoubleArg(ValueEval, int, int)
- Static method in class org.zkoss.poi.ss.formula.functions.
TextFunctionHelper
evaluateIntArg(ValueEval, int, int)
- Static method in class org.zkoss.poi.ss.formula.functions.
TextFunctionHelper
evaluateStringArg(ValueEval, int, int)
- Static method in class org.zkoss.poi.ss.formula.functions.
TextFunctionHelper
F
format(Complex)
- Static method in class org.zkoss.poi.ss.formula.functions.
UtilFns
format Complex number to match Excel format
G
getAnyField(Class<?>, String)
- Static method in class org.zkoss.zpoiex.util.
Classes
Gets the specified field by searching all fields including any access control and any base class.
getCacheId()
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotCache
getCacheId()
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotTable
getColumnFields()
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotTable
getCreatedVersion()
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotCache
getCTColFields()
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotTable
getCTLocation()
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotTable
getCTRowFields()
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotTable
getData()
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFCacheRecord
getDatabaseField()
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFCacheField
getDatabaseField()
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotField
getDataCaption()
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotTable
getDataFields()
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotTable
getDataOnRows()
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotTable
getDefaultSubtotal()
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotField
getFieldGroup()
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFCacheField
getFieldGroup()
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotField
getFields()
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotCache
getFirstDataRef()
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotTable
getGrandTotalCaption()
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotTable
getGroupBase()
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFCacheField
getGroupDiscrete()
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFCacheField
getHide()
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotField.XSSFItem
getItems()
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotField
getLocationRef()
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotTable
getMinRefreshableVersion()
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotCache
getName()
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFCacheField
getName()
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFDataField
getName()
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotField
getName()
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotTable
getNumberFormatId()
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFCacheField
getOutline()
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotField
getOutline()
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotTable
getOutlineData()
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotTable
getPivotCache()
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotTable
getPivotField()
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFDataField
getPivotField(String)
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotTable
getPivotFields()
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotTable
getPivotTableDefinition()
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotTable
getRecords()
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotCache
getRefreshedVersion()
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotCache
getRegre(double[], double[])
- Static method in class org.zkoss.poi.ss.formula.functions.
UtilFns
Return a commons math Regression class
getRelativeValue(ValueEval, int, int)
- Static method in class org.zkoss.poi.ss.formula.
AreaEvalHelper
getRowFields()
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotTable
getRowHeaderCaption()
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotTable
getSharedItems()
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFCacheField
getSheet()
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotTable
getSheetSource()
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotCache
getShowDetail()
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotField.XSSFItem
getSortType()
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotField
getStats(double[])
- Static method in class org.zkoss.poi.ss.formula.functions.
UtilFns
Return a commons math DescriptiveStatistics class which is contructed from double array d
getSubtotal()
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFDataField
getSubtotals()
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotField
getSuffix()
- Method in class org.zkoss.poi.ss.formula.functions.
Complex
getType()
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotField
getType()
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotField.XSSFItem
getValue()
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotField.XSSFItem
getWorkbook()
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotCache
H
hashCode()
- Method in class org.zkoss.poi.ss.formula.functions.
Complex
hashCode()
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotField.XSSFItem
I
initPivotCaches(Workbook)
- Method in class org.zkoss.zpoiex.ss.usermodel.helpers.
PivotTableHelper
initPivotTables(Sheet)
- Method in class org.zkoss.zpoiex.ss.usermodel.helpers.
PivotTableHelper
N
newXSSFClientAnchor(CTMarker, CTMarker)
- Static method in class org.zkoss.poi.xssf.usermodel.
XSSFClientAnchorHelper
newXSSFPicture(XSSFDrawing, XSSFClientAnchor, CTPicture)
- Static method in class org.zkoss.poi.xssf.usermodel.
XSSFPictureHelper
NumberToGeneralTextConverter
- Class in
org.zkoss.poi.ss.util
Convert a number to "General" formatting text.
NumberToGeneralTextConverter()
- Constructor for class org.zkoss.poi.ss.util.
NumberToGeneralTextConverter
NumericFunctionHelper
- Class in
org.zkoss.poi.ss.formula.functions
NumericFunctionHelper()
- Constructor for class org.zkoss.poi.ss.formula.functions.
NumericFunctionHelper
O
Objects
- Class in
org.zkoss.zpoiex.util
Objects()
- Constructor for class org.zkoss.zpoiex.util.
Objects
onDocumentCreate()
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotCache
onDocumentCreate()
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotCacheRecords
onDocumentCreate()
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotTable
onDocumentRead()
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotCache
onDocumentRead()
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotCacheRecords
org.zkoss.poi.hssf.usermodel
- package org.zkoss.poi.hssf.usermodel
org.zkoss.poi.ss.formula
- package org.zkoss.poi.ss.formula
org.zkoss.poi.ss.formula.functions
- package org.zkoss.poi.ss.formula.functions
org.zkoss.poi.ss.util
- package org.zkoss.poi.ss.util
org.zkoss.poi.xssf.usermodel
- package org.zkoss.poi.xssf.usermodel
org.zkoss.zpoiex
- package org.zkoss.zpoiex
org.zkoss.zpoiex.ss.usermodel.helpers
- package org.zkoss.zpoiex.ss.usermodel.helpers
org.zkoss.zpoiex.util
- package org.zkoss.zpoiex.util
P
padZero(String, int)
- Static method in class org.zkoss.poi.ss.formula.functions.
UtilFns
parse(String, String)
- Method in class org.zkoss.poi.ss.formula.functions.
ComplexFormat
PivotTableHelper
- Class in
org.zkoss.poi.hssf.usermodel
PivotTableHelper()
- Constructor for class org.zkoss.poi.hssf.usermodel.
PivotTableHelper
PivotTableHelper
- Class in
org.zkoss.zpoiex.ss.usermodel.helpers
PivotTableHelper()
- Constructor for class org.zkoss.zpoiex.ss.usermodel.helpers.
PivotTableHelper
R
replaceiToi1(String, String)
- Static method in class org.zkoss.poi.ss.formula.functions.
UtilFns
Replace the String i to i1.
S
setCacheId(long)
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotCache
setColumnField(PivotField)
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotTable
setColumnItems(List<List<ItemInfo>>)
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotTable
setDatabaseField(boolean)
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFCacheField
setDataCaption(String)
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotTable
setDataField(PivotField, String, Calculation)
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotTable
setDataOnRows(boolean)
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotTable
setDefaultSubtotal(boolean)
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotField
setFirstData(int, int)
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotTable
setFirstHeaderRow(int)
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotTable
setGrandTotalCaption(String)
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotTable
setHide(boolean)
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotField.XSSFItem
setItems(List<Object>)
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotField
setLocationRef(AreaReference)
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotTable
setName(String)
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFCacheField
setName(String)
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotField
setName(String)
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotTable
setOutline(boolean)
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotField
setOutline(boolean)
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotTable
setOutlineData(boolean)
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotTable
setPivotCache(PivotCache)
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotTable
setRowField(PivotField)
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotTable
setRowHeaderCaption(String)
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotTable
setRowItems(List<List<ItemInfo>>)
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotTable
setSheetSource(AreaReference)
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotCache
setShowDetail(boolean)
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotField.XSSFItem
setSortType(PivotField.SortType)
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotField
setSubtotals(Set<Calculation>)
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotField
setType(PivotField.Type)
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotField
setType(PivotField.Item.Type)
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotField.XSSFItem
stringToBoolean(ValueEval)
- Static method in class org.zkoss.poi.ss.formula.functions.
UtilFns
stringToDate(ValueEval)
- Static method in class org.zkoss.poi.ss.formula.functions.
UtilFns
Convert a String to Date
stringToDouble(String, boolean)
- Static method in class org.zkoss.poi.ss.formula.functions.
UtilFns
Convert a string to double
suffix
- Variable in class org.zkoss.poi.ss.formula.functions.
Complex
T
TextFunctionHelper
- Class in
org.zkoss.poi.ss.formula.functions
TextFunctionHelper()
- Constructor for class org.zkoss.poi.ss.formula.functions.
TextFunctionHelper
toDouble15(double, int)
- Static method in class org.zkoss.poi.ss.formula.functions.
UtilFns
toDoubleArray(List)
- Static method in class org.zkoss.poi.ss.formula.functions.
UtilFns
Convert a list to a double array
toDoubleArray(Object[])
- Static method in class org.zkoss.poi.ss.formula.functions.
UtilFns
Convert an object array to a double array
toDoubleList(ValueEval, int, int)
- Static method in class org.zkoss.poi.ss.formula.
AreaEvalHelper
toDoubleMatrix(ValueEval, int, int)
- Static method in class org.zkoss.poi.ss.formula.
AreaEvalHelper
toDoubleMatrix(ValueEval, int, int)
- Static method in class org.zkoss.poi.ss.formula.functions.
UtilFns
toGeneralText(double, Locale, int)
- Static method in class org.zkoss.poi.ss.util.
NumberToGeneralTextConverter
toIntArray(Object[])
- Static method in class org.zkoss.poi.ss.formula.functions.
UtilFns
Convert an object array to an int array
toList(ValueEval[], int, int)
- Static method in class org.zkoss.poi.ss.formula.functions.
UtilFns
toString()
- Method in class org.zkoss.poi.xssf.usermodel.
XSSFPivotCacheRecords
TZ_GMT
- Static variable in class org.zkoss.poi.ss.formula.functions.
UtilFns
U
UID
- Static variable in class org.zkoss.zpoiex.
Version
Returns the version UID.
UtilFns
- Class in
org.zkoss.poi.ss.formula.functions
UtilFns()
- Constructor for class org.zkoss.poi.ss.formula.functions.
UtilFns
V
validateComplex(String)
- Static method in class org.zkoss.poi.ss.formula.functions.
UtilFns
Validate given String value, return associated complex.
Version
- Class in
org.zkoss.zpoiex
The version of the ZPOI extension.
Version()
- Constructor for class org.zkoss.zpoiex.
Version
X
XSSFCacheField
- Class in
org.zkoss.poi.xssf.usermodel
XSSFCacheRecord
- Class in
org.zkoss.poi.xssf.usermodel
XSSFClientAnchorHelper
- Class in
org.zkoss.poi.xssf.usermodel
raise protection.
XSSFClientAnchorHelper()
- Constructor for class org.zkoss.poi.xssf.usermodel.
XSSFClientAnchorHelper
XSSFDataField
- Class in
org.zkoss.poi.xssf.usermodel
XSSFPictureHelper
- Class in
org.zkoss.poi.xssf.usermodel
raise protection.
XSSFPictureHelper()
- Constructor for class org.zkoss.poi.xssf.usermodel.
XSSFPictureHelper
XSSFPivotCache
- Class in
org.zkoss.poi.xssf.usermodel
XSSFPivotCache()
- Constructor for class org.zkoss.poi.xssf.usermodel.
XSSFPivotCache
XSSFPivotCache(PackagePart, PackageRelationship)
- Constructor for class org.zkoss.poi.xssf.usermodel.
XSSFPivotCache
XSSFPivotCache(long, POIXMLDocumentPart, PackagePart, PackageRelationship)
- Constructor for class org.zkoss.poi.xssf.usermodel.
XSSFPivotCache
XSSFPivotCacheRecords
- Class in
org.zkoss.poi.xssf.usermodel
XSSFPivotField
- Class in
org.zkoss.poi.xssf.usermodel
XSSFPivotField.XSSFItem
- Class in
org.zkoss.poi.xssf.usermodel
XSSFPivotTable
- Class in
org.zkoss.poi.xssf.usermodel
XSSFPivotTable(PackagePart, PackageRelationship, List<PivotCache>)
- Constructor for class org.zkoss.poi.xssf.usermodel.
XSSFPivotTable
Z
ZERO_DOUBLE
- Static variable in class org.zkoss.zpoiex.util.
Objects
The zero double.
A
B
C
D
E
F
G
H
I
N
O
P
R
S
T
U
V
X
Z
Skip navigation links
Overview
Package
Class
Use
Tree
Deprecated
Index
Help
Prev
Next
Frames
No Frames
All Classes
Copyright © 2019. All rights reserved.