Skip navigation links
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

Copyright © 2019. All rights reserved.