Index

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z _ 
All Classes and Interfaces|All Packages|Constant Field Values|Serialized Form

A

A1 - Enum constant in enum org.apache.poi.ss.usermodel.CellReferenceType
Cells are referenced in the form A1, B4, etc.
A1 - Static variable in class org.apache.poi.ss.util.CellAddress
A constant for references to the first cell in a sheet.
A3_PAPER - Enum constant in enum org.apache.poi.ss.usermodel.PaperSize
 
A3_PAPERSIZE - Static variable in interface org.apache.poi.ss.usermodel.PrintSetup
A3 - 297x420 mm
A4_EXTRA_PAPERSIZE - Static variable in interface org.apache.poi.ss.usermodel.PrintSetup
A4 Extra - 9.27 x 12.69 in
A4_PAPER - Enum constant in enum org.apache.poi.ss.usermodel.PaperSize
 
A4_PAPERSIZE - Static variable in interface org.apache.poi.ss.usermodel.PrintSetup
A4 - 210x297 mm
A4_PLUS_PAPERSIZE - Static variable in interface org.apache.poi.ss.usermodel.PrintSetup
A4 Plus - 210x330 mm
A4_ROTATED_PAPERSIZE - Static variable in interface org.apache.poi.ss.usermodel.PrintSetup
A4 Rotated - 297x210 mm
A4_SMALL_PAPER - Enum constant in enum org.apache.poi.ss.usermodel.PaperSize
 
A4_SMALL_PAPERSIZE - Static variable in interface org.apache.poi.ss.usermodel.PrintSetup
A4 Small - 210x297 mm
A4_TRANSVERSE_PAPERSIZE - Static variable in interface org.apache.poi.ss.usermodel.PrintSetup
A4 Transverse - 210x297 mm
A5_PAPER - Enum constant in enum org.apache.poi.ss.usermodel.PaperSize
 
A5_PAPERSIZE - Static variable in interface org.apache.poi.ss.usermodel.PrintSetup
A5 - 148x210 mm
AbortableHSSFListener - Class in org.apache.poi.hssf.eventusermodel
Abstract class for use with the HSSFRequest and HSSFEventFactory, which allows for the halting of processing.
AbortableHSSFListener() - Constructor for class org.apache.poi.hssf.eventusermodel.AbortableHSSFListener
 
abortableProcessEvents(HSSFRequest, InputStream) - Method in class org.apache.poi.hssf.eventusermodel.HSSFEventFactory
Processes a DocumentInputStream into essentially Record events.
abortableProcessRecord(Record) - Method in class org.apache.poi.hssf.eventusermodel.AbortableHSSFListener
Process an HSSF Record.
abortableProcessWorkbookEvents(HSSFRequest, DirectoryNode) - Method in class org.apache.poi.hssf.eventusermodel.HSSFEventFactory
Processes a file into essentially record events.
abortableProcessWorkbookEvents(HSSFRequest, POIFSFileSystem) - Method in class org.apache.poi.hssf.eventusermodel.HSSFEventFactory
Processes a file into essentially record events.
ABOVE_AVERAGE - Enum constant in enum org.apache.poi.ss.usermodel.ConditionFilterType
 
abs - Enum constant in enum org.apache.poi.sl.draw.geom.GuideIf.Op
 
ABS - Static variable in class org.apache.poi.ss.formula.functions.NumericFunction
 
absoluteDay(LocalDateTime, boolean) - Static method in class org.apache.poi.ss.usermodel.DateUtil
Given a LocalDateTime, return the number of days since 1900/12/31.
absoluteDay(Calendar, boolean) - Static method in class org.apache.poi.ss.usermodel.DateUtil
Given a Calendar, return the number of days since 1900/12/31.
AbstractColorStyle - Class in org.apache.poi.sl.usermodel
Helper class for ColorStyle - not part of the API / implementation may change any time
AbstractColorStyle() - Constructor for class org.apache.poi.sl.usermodel.AbstractColorStyle
 
AbstractEscherHolderRecord - Class in org.apache.poi.hssf.record
The escher container record is used to hold escher records.
AbstractEscherHolderRecord() - Constructor for class org.apache.poi.hssf.record.AbstractEscherHolderRecord
 
AbstractEscherHolderRecord(AbstractEscherHolderRecord) - Constructor for class org.apache.poi.hssf.record.AbstractEscherHolderRecord
 
AbstractEscherHolderRecord(RecordInputStream) - Constructor for class org.apache.poi.hssf.record.AbstractEscherHolderRecord
 
AbstractEscherOptRecord - Class in org.apache.poi.ddf
Common abstract class for EscherOptRecord and EscherTertiaryOptRecord
AbstractEscherOptRecord() - Constructor for class org.apache.poi.ddf.AbstractEscherOptRecord
 
AbstractEscherOptRecord(AbstractEscherOptRecord) - Constructor for class org.apache.poi.ddf.AbstractEscherOptRecord
 
AbstractFunctionPtg - Class in org.apache.poi.ss.formula.ptg
This class provides the base functionality for Excel sheet functions There are two kinds of function Ptgs - tFunc and tFuncVar Therefore, this class will have ONLY two subclasses
AbstractFunctionPtg(int, int, byte[], int) - Constructor for class org.apache.poi.ss.formula.ptg.AbstractFunctionPtg
 
abstractNums - Variable in class org.apache.poi.xwpf.usermodel.XWPFNumbering
 
ACCENT_1 - Enum constant in enum org.apache.poi.xddf.usermodel.SchemeColor
 
ACCENT_2 - Enum constant in enum org.apache.poi.xddf.usermodel.SchemeColor
 
ACCENT_3 - Enum constant in enum org.apache.poi.xddf.usermodel.SchemeColor
 
ACCENT_4 - Enum constant in enum org.apache.poi.xddf.usermodel.SchemeColor
 
ACCENT_5 - Enum constant in enum org.apache.poi.xddf.usermodel.SchemeColor
 
ACCENT_6 - Enum constant in enum org.apache.poi.xddf.usermodel.SchemeColor
 
ACCENT_BORDER_CALLOUT_1 - Enum constant in enum org.apache.poi.sl.usermodel.ShapeType
 
ACCENT_BORDER_CALLOUT_1 - Enum constant in enum org.apache.poi.xddf.usermodel.PresetGeometry
 
ACCENT_BORDER_CALLOUT_1 - Static variable in class org.apache.poi.ss.usermodel.ShapeTypes
 
ACCENT_BORDER_CALLOUT_2 - Enum constant in enum org.apache.poi.sl.usermodel.ShapeType
 
ACCENT_BORDER_CALLOUT_2 - Enum constant in enum org.apache.poi.xddf.usermodel.PresetGeometry
 
ACCENT_BORDER_CALLOUT_2 - Static variable in class org.apache.poi.ss.usermodel.ShapeTypes
 
ACCENT_BORDER_CALLOUT_3 - Enum constant in enum org.apache.poi.sl.usermodel.ShapeType
 
ACCENT_BORDER_CALLOUT_3 - Enum constant in enum org.apache.poi.xddf.usermodel.PresetGeometry
 
ACCENT_BORDER_CALLOUT_3 - Static variable in class org.apache.poi.ss.usermodel.ShapeTypes
 
ACCENT_BORDER_CALLOUT_90 - Enum constant in enum org.apache.poi.sl.usermodel.ShapeType
 
ACCENT_CALLOUT_1 - Enum constant in enum org.apache.poi.sl.usermodel.ShapeType
 
ACCENT_CALLOUT_1 - Enum constant in enum org.apache.poi.xddf.usermodel.PresetGeometry
 
ACCENT_CALLOUT_1 - Static variable in class org.apache.poi.ss.usermodel.ShapeTypes
 
ACCENT_CALLOUT_2 - Enum constant in enum org.apache.poi.sl.usermodel.ShapeType
 
ACCENT_CALLOUT_2 - Enum constant in enum org.apache.poi.xddf.usermodel.PresetGeometry
 
ACCENT_CALLOUT_2 - Static variable in class org.apache.poi.ss.usermodel.ShapeTypes
 
ACCENT_CALLOUT_3 - Enum constant in enum org.apache.poi.sl.usermodel.ShapeType
 
ACCENT_CALLOUT_3 - Enum constant in enum org.apache.poi.xddf.usermodel.PresetGeometry
 
ACCENT_CALLOUT_3 - Static variable in class org.apache.poi.ss.usermodel.ShapeTypes
 
ACCENT_CALLOUT_90 - Enum constant in enum org.apache.poi.sl.usermodel.ShapeType
 
ACCENT1 - Enum constant in enum org.apache.poi.xssf.model.ThemesTable.ThemeElement
 
ACCENT2 - Enum constant in enum org.apache.poi.xssf.model.ThemesTable.ThemeElement
 
ACCENT3 - Enum constant in enum org.apache.poi.xssf.model.ThemesTable.ThemeElement
 
ACCENT4 - Enum constant in enum org.apache.poi.xssf.model.ThemesTable.ThemeElement
 
ACCENT5 - Enum constant in enum org.apache.poi.xssf.model.ThemesTable.ThemeElement
 
ACCENT6 - Enum constant in enum org.apache.poi.xssf.model.ThemesTable.ThemeElement
 
AccentBorderCallout1 - Static variable in interface org.apache.poi.hssf.usermodel.HSSFShapeTypes
 
AccentBorderCallout2 - Static variable in interface org.apache.poi.hssf.usermodel.HSSFShapeTypes
 
AccentBorderCallout3 - Static variable in interface org.apache.poi.hssf.usermodel.HSSFShapeTypes
 
AccentBorderCallout90 - Static variable in interface org.apache.poi.hssf.usermodel.HSSFShapeTypes
 
AccentCallout1 - Static variable in interface org.apache.poi.hssf.usermodel.HSSFShapeTypes
 
AccentCallout2 - Static variable in interface org.apache.poi.hssf.usermodel.HSSFShapeTypes
 
AccentCallout3 - Static variable in interface org.apache.poi.hssf.usermodel.HSSFShapeTypes
 
AccentCallout90 - Static variable in interface org.apache.poi.hssf.usermodel.HSSFShapeTypes
 
accept(XDGFShape) - Method in class org.apache.poi.xdgf.usermodel.shape.ShapeDataAcceptor
 
accept(XDGFShape) - Method in class org.apache.poi.xdgf.usermodel.shape.ShapeTextVisitor.TextAcceptor
 
accept(XDGFShape) - Method in class org.apache.poi.xdgf.usermodel.shape.ShapeVisitor
 
accept(XDGFShape) - Method in interface org.apache.poi.xdgf.usermodel.shape.ShapeVisitorAcceptor
 
accepts(FileMagic) - Method in interface org.apache.poi.extractor.ExtractorProvider
 
accepts(FileMagic) - Method in class org.apache.poi.extractor.MainExtractorFactory
 
accepts(FileMagic) - Method in class org.apache.poi.hssf.usermodel.HSSFWorkbookFactory
 
accepts(FileMagic) - Method in class org.apache.poi.ooxml.extractor.POIXMLExtractorFactory
 
accepts(FileMagic) - Method in interface org.apache.poi.sl.usermodel.SlideShowProvider
 
accepts(FileMagic) - Method in interface org.apache.poi.ss.usermodel.WorkbookProvider
 
accepts(FileMagic) - Method in class org.apache.poi.xslf.usermodel.XSLFSlideShowFactory
 
accepts(FileMagic) - Method in class org.apache.poi.xssf.usermodel.XSSFWorkbookFactory
 
accumulate(double, double) - Method in interface org.apache.poi.ss.formula.functions.XYNumericFunction.Accumulator
 
ACOS - Static variable in class org.apache.poi.ss.formula.functions.NumericFunction
 
ACOSH - Static variable in class org.apache.poi.ss.formula.functions.NumericFunction
 
ACTION_BUTTON_BACK_PREVIOUS - Enum constant in enum org.apache.poi.sl.usermodel.ShapeType
 
ACTION_BUTTON_BACK_PREVIOUS - Enum constant in enum org.apache.poi.xddf.usermodel.PresetGeometry
 
ACTION_BUTTON_BACK_PREVIOUS - Static variable in class org.apache.poi.ss.usermodel.ShapeTypes
 
ACTION_BUTTON_BEGINNING - Enum constant in enum org.apache.poi.sl.usermodel.ShapeType
 
ACTION_BUTTON_BEGINNING - Enum constant in enum org.apache.poi.xddf.usermodel.PresetGeometry
 
ACTION_BUTTON_BEGINNING - Static variable in class org.apache.poi.ss.usermodel.ShapeTypes
 
ACTION_BUTTON_BLANK - Enum constant in enum org.apache.poi.sl.usermodel.ShapeType
 
ACTION_BUTTON_BLANK - Enum constant in enum org.apache.poi.xddf.usermodel.PresetGeometry
 
ACTION_BUTTON_BLANK - Static variable in class org.apache.poi.ss.usermodel.ShapeTypes
 
ACTION_BUTTON_DOCUMENT - Enum constant in enum org.apache.poi.sl.usermodel.ShapeType
 
ACTION_BUTTON_DOCUMENT - Enum constant in enum org.apache.poi.xddf.usermodel.PresetGeometry
 
ACTION_BUTTON_DOCUMENT - Static variable in class org.apache.poi.ss.usermodel.ShapeTypes
 
ACTION_BUTTON_END - Enum constant in enum org.apache.poi.sl.usermodel.ShapeType
 
ACTION_BUTTON_END - Enum constant in enum org.apache.poi.xddf.usermodel.PresetGeometry
 
ACTION_BUTTON_END - Static variable in class org.apache.poi.ss.usermodel.ShapeTypes
 
ACTION_BUTTON_FORWARD_NEXT - Enum constant in enum org.apache.poi.sl.usermodel.ShapeType
 
ACTION_BUTTON_FORWARD_NEXT - Enum constant in enum org.apache.poi.xddf.usermodel.PresetGeometry
 
ACTION_BUTTON_FORWARD_NEXT - Static variable in class org.apache.poi.ss.usermodel.ShapeTypes
 
ACTION_BUTTON_HELP - Enum constant in enum org.apache.poi.sl.usermodel.ShapeType
 
ACTION_BUTTON_HELP - Enum constant in enum org.apache.poi.xddf.usermodel.PresetGeometry
 
ACTION_BUTTON_HELP - Static variable in class org.apache.poi.ss.usermodel.ShapeTypes
 
ACTION_BUTTON_HOME - Enum constant in enum org.apache.poi.sl.usermodel.ShapeType
 
ACTION_BUTTON_HOME - Enum constant in enum org.apache.poi.xddf.usermodel.PresetGeometry
 
ACTION_BUTTON_HOME - Static variable in class org.apache.poi.ss.usermodel.ShapeTypes
 
ACTION_BUTTON_INFORMATION - Enum constant in enum org.apache.poi.sl.usermodel.ShapeType
 
ACTION_BUTTON_INFORMATION - Enum constant in enum org.apache.poi.xddf.usermodel.PresetGeometry
 
ACTION_BUTTON_INFORMATION - Static variable in class org.apache.poi.ss.usermodel.ShapeTypes
 
ACTION_BUTTON_MOVIE - Enum constant in enum org.apache.poi.sl.usermodel.ShapeType
 
ACTION_BUTTON_MOVIE - Enum constant in enum org.apache.poi.xddf.usermodel.PresetGeometry
 
ACTION_BUTTON_MOVIE - Static variable in class org.apache.poi.ss.usermodel.ShapeTypes
 
ACTION_BUTTON_RETURN - Enum constant in enum org.apache.poi.sl.usermodel.ShapeType
 
ACTION_BUTTON_RETURN - Enum constant in enum org.apache.poi.xddf.usermodel.PresetGeometry
 
ACTION_BUTTON_RETURN - Static variable in class org.apache.poi.ss.usermodel.ShapeTypes
 
ACTION_BUTTON_SOUND - Enum constant in enum org.apache.poi.sl.usermodel.ShapeType
 
ACTION_BUTTON_SOUND - Enum constant in enum org.apache.poi.xddf.usermodel.PresetGeometry
 
ACTION_BUTTON_SOUND - Static variable in class org.apache.poi.ss.usermodel.ShapeTypes
 
ActionButtonBackPrevious - Static variable in interface org.apache.poi.hssf.usermodel.HSSFShapeTypes
 
ActionButtonBeginning - Static variable in interface org.apache.poi.hssf.usermodel.HSSFShapeTypes
 
ActionButtonBlank - Static variable in interface org.apache.poi.hssf.usermodel.HSSFShapeTypes
 
ActionButtonDocument - Static variable in interface org.apache.poi.hssf.usermodel.HSSFShapeTypes
 
ActionButtonEnd - Static variable in interface org.apache.poi.hssf.usermodel.HSSFShapeTypes
 
ActionButtonForwardNext - Static variable in interface org.apache.poi.hssf.usermodel.HSSFShapeTypes
 
ActionButtonHelp - Static variable in interface org.apache.poi.hssf.usermodel.HSSFShapeTypes
 
ActionButtonHome - Static variable in interface org.apache.poi.hssf.usermodel.HSSFShapeTypes
 
ActionButtonInformation - Static variable in interface org.apache.poi.hssf.usermodel.HSSFShapeTypes
 
ActionButtonMovie - Static variable in interface org.apache.poi.hssf.usermodel.HSSFShapeTypes
 
ActionButtonReturn - Static variable in interface org.apache.poi.hssf.usermodel.HSSFShapeTypes
 
ActionButtonSound - Static variable in interface org.apache.poi.hssf.usermodel.HSSFShapeTypes
 
ACTIVE_BORDER - Enum constant in enum org.apache.poi.xddf.usermodel.SystemColor
 
ACTIVE_CAPTION - Enum constant in enum org.apache.poi.xddf.usermodel.SystemColor
 
ACTIVE_PANE_LOWER_LEFT - Static variable in class org.apache.poi.hssf.record.PaneRecord
 
ACTIVE_PANE_LOWER_RIGHT - Static variable in class org.apache.poi.hssf.record.PaneRecord
 
ACTIVE_PANE_UPPER_LEFT - Static variable in class org.apache.poi.hssf.record.PaneRecord
 
ACTIVE_PANE_UPPER_RIGHT - Static variable in class org.apache.poi.hssf.record.PaneRecord
 
ActiveBorder - Enum constant in enum org.apache.poi.sl.usermodel.PresetColor
The system-defined color of the active window's border.
ActiveCaption - Enum constant in enum org.apache.poi.sl.usermodel.PresetColor
The system-defined color of the background of the active window's title bar.
ActiveCaptionText - Enum constant in enum org.apache.poi.sl.usermodel.PresetColor
The system-defined color of the text in the active window's title bar.
ACTIVEX_BINS - Static variable in class org.apache.poi.xssf.usermodel.XSSFRelation
 
ACTIVEX_CONTROLS - Static variable in class org.apache.poi.xssf.usermodel.XSSFRelation
 
add(int) - Method in class org.apache.poi.util.IntList
Appends the specified element to the end of this list
add(int, int) - Method in class org.apache.poi.util.IntList
add the specified value at the specified index
add(int, Record) - Method in class org.apache.poi.hssf.model.WorkbookRecordList
 
add(CFRecordsAggregate) - Method in class org.apache.poi.hssf.record.aggregates.ConditionalFormattingTable
 
add(UDFFinder) - Method in class org.apache.poi.ss.formula.udf.AggregatingUDFFinder
Add a new toolpack
add(XSSFSheet, XSSFClientAnchor) - Method in class org.apache.poi.xssf.usermodel.XSSFSignatureLine
 
add(XWPFParagraph) - Method in class org.apache.poi.xwpf.usermodel.XWPFSignatureLine
 
add(XmlObject, SignatureLine.AddPictureData) - Method in class org.apache.poi.poifs.crypt.dsig.SignatureLine
 
add(T) - Method in class org.apache.poi.util.IntMapper
Appends the specified element to the end of this list
ADD_GRAY_LEVEL - Enum constant in enum org.apache.poi.ddf.EscherColorRef.SysIndexProcedure
Add a gray level RGB value.
addAbstractNum(XWPFAbstractNum) - Method in class org.apache.poi.xwpf.usermodel.XWPFNumbering
add a new AbstractNum and return its AbstractNumID
addAdjustGuide(AdjustValueIf) - Method in class org.apache.poi.sl.draw.geom.CustomGeometry
 
addAdjustHandle(AdjustHandle) - Method in class org.apache.poi.sl.draw.geom.CustomGeometry
 
addAdjustValue() - Method in class org.apache.poi.xddf.usermodel.XDDFCustomGeometry2D
 
addAdjustValue() - Method in class org.apache.poi.xddf.usermodel.XDDFPresetGeometry2D
 
addAfterLastRunProperties() - Method in class org.apache.poi.xddf.usermodel.text.XDDFTextParagraph
 
addAll(int, IntList) - Method in class org.apache.poi.util.IntList
Inserts all of the elements in the specified collection into this list at the specified position.
addAll(IntList) - Method in class org.apache.poi.util.IntList
Appends all of the elements in the specified collection to the end of this list, in the order that they are returned by the specified collection's iterator.
addArea(int, int, int, int) - Method in class org.apache.poi.hssf.record.aggregates.MergedCellsTable
 
addArrayRecord(ArrayRecord) - Method in class org.apache.poi.hssf.record.aggregates.SharedValueManager
Add specified Array Record.
addBreak() - Method in class org.apache.poi.xwpf.usermodel.XWPFRun
Specifies that a break shall be placed at the current location in the run content.
addBreak(int, int, int) - Method in class org.apache.poi.hssf.record.PageBreakRecord
Adds the page break at the specified parameters
addBreak(BreakClear) - Method in class org.apache.poi.xwpf.usermodel.XWPFRun
Specifies that a break shall be placed at the current location in the run content.
addBreak(BreakType) - Method in class org.apache.poi.xwpf.usermodel.XWPFRun
Specifies that a break shall be placed at the current location in the run content.
addBSERecord(EscherBSERecord) - Method in class org.apache.poi.hssf.model.InternalWorkbook
 
addCachedCertificate(String, byte[]) - Method in class org.apache.poi.poifs.crypt.dsig.SignatureConfig
 
addCachedCertificate(String, X509Certificate) - Method in class org.apache.poi.poifs.crypt.dsig.SignatureConfig
Add certificate into keystore (cache) for further certificate chain lookups
addCarriageReturn() - Method in class org.apache.poi.xwpf.usermodel.XWPFRun
Specifies that a carriage return shall be placed at the current location in the run content.
addCell() - Method in class org.apache.poi.xslf.usermodel.XSLFTableRow
 
addCellRangeAddress(int, int, int, int) - Method in class org.apache.poi.ss.util.CellRangeAddressList
Add a cell range structure.
addCellRangeAddress(CellRangeAddress) - Method in class org.apache.poi.ss.util.CellRangeAddressList
 
addCertificate(X509Certificate) - Method in class org.apache.poi.poifs.crypt.dsig.services.RevocationData
 
addCertificate(SignatureInfo, SignedSignaturePropertiesType) - Method in class org.apache.poi.poifs.crypt.dsig.facets.XAdESSignatureFacet
 
addChar(char, int) - Method in class org.apache.poi.hssf.usermodel.FontDetails
 
addChars(char[], int[]) - Method in class org.apache.poi.hssf.usermodel.FontDetails
 
addChart(String) - Method in class org.apache.poi.xwpf.usermodel.XWPFRun
this method add chart template into document
addChart(String, Rectangle2D) - Method in class org.apache.poi.xslf.usermodel.XSLFDrawing
This method will add chart into slide's graphic frame
addChart(XSLFChart) - Method in class org.apache.poi.xslf.usermodel.XSLFSheet
this method will add chart into slide with default height, width, x and y
addChart(XSLFChart, Rectangle2D) - Method in class org.apache.poi.xslf.usermodel.XSLFSheet
this method will add chart into slide with given height, width, x and y
addChild(Property) - Method in class org.apache.poi.poifs.property.DirectoryProperty
Add a new child to the collection of children
addChild(Property) - Method in interface org.apache.poi.poifs.property.Parent
Add a new child to the collection of children
addChildBefore(EscherRecord, int) - Method in class org.apache.poi.ddf.EscherContainerRecord
Add a child record before the record with given recordId
addChildRecord(EscherRecord) - Method in class org.apache.poi.ddf.EscherContainerRecord
Append a child record
addChildRecord(EscherRecord) - Method in class org.apache.poi.ddf.UnknownEscherRecord
 
addCleanColIntoCols(CTCols, CTCol) - Method in class org.apache.poi.xssf.usermodel.helpers.ColumnHelper
 
addCluster(int, int) - Method in class org.apache.poi.ddf.EscherDggRecord
Add a new cluster
addCluster(int, int, boolean) - Method in class org.apache.poi.ddf.EscherDggRecord
Add a new cluster
addColLabel(int) - Method in class org.apache.poi.xssf.usermodel.XSSFPivotTable
Add a col label using data from the given column.
addColLabel(int, String) - Method in class org.apache.poi.xssf.usermodel.XSSFPivotTable
Add a col label using data from the given column.
addColor(byte, byte, byte) - Method in class org.apache.poi.hssf.usermodel.HSSFPalette
Adds a new color into an empty color slot.
addColumn() - Method in class org.apache.poi.xslf.usermodel.XSLFTable
Add a new column at the end of the table.
addColumnLabel(DataConsolidateFunction, int) - Method in class org.apache.poi.xssf.usermodel.XSSFPivotTable
Add a column label using data from the given column and specified function
addColumnLabel(DataConsolidateFunction, int, String) - Method in class org.apache.poi.xssf.usermodel.XSSFPivotTable
Add a column label using data from the given column and specified function
addColumnLabel(DataConsolidateFunction, int, String, String) - Method in class org.apache.poi.xssf.usermodel.XSSFPivotTable
Add a column label using data from the given column and specified function
addCommand(PathCommand) - Method in class org.apache.poi.sl.draw.geom.Path
 
addCommand(PathCommand) - Method in interface org.apache.poi.sl.draw.geom.PathIf
 
addCommand(PathCommand) - Method in class org.apache.poi.xslf.draw.geom.XSLFPath
 
addCommitmentType(SignatureInfo, SignedPropertiesType) - Method in class org.apache.poi.poifs.crypt.dsig.facets.XAdESSignatureFacet
 
addConditionalFormatting(HSSFConditionalFormatting) - Method in class org.apache.poi.hssf.usermodel.HSSFSheetConditionalFormatting
Adds a copy of HSSFConditionalFormatting object to the sheet
addConditionalFormatting(ConditionalFormatting) - Method in class org.apache.poi.hssf.usermodel.HSSFSheetConditionalFormatting
 
addConditionalFormatting(ConditionalFormatting) - Method in interface org.apache.poi.ss.usermodel.SheetConditionalFormatting
Adds a copy of a ConditionalFormatting object to the sheet
addConditionalFormatting(ConditionalFormatting) - Method in class org.apache.poi.xssf.usermodel.XSSFSheetConditionalFormatting
Adds a copy of HSSFConditionalFormatting object to the sheet
addConditionalFormatting(CellRangeAddress[], HSSFConditionalFormattingRule) - Method in class org.apache.poi.hssf.usermodel.HSSFSheetConditionalFormatting
 
addConditionalFormatting(CellRangeAddress[], HSSFConditionalFormattingRule[]) - Method in class org.apache.poi.hssf.usermodel.HSSFSheetConditionalFormatting
Allows to add a new Conditional Formatting set to the sheet.
addConditionalFormatting(CellRangeAddress[], HSSFConditionalFormattingRule, HSSFConditionalFormattingRule) - Method in class org.apache.poi.hssf.usermodel.HSSFSheetConditionalFormatting
 
addConditionalFormatting(CellRangeAddress[], ConditionalFormattingRule) - Method in class org.apache.poi.hssf.usermodel.HSSFSheetConditionalFormatting
 
addConditionalFormatting(CellRangeAddress[], ConditionalFormattingRule) - Method in interface org.apache.poi.ss.usermodel.SheetConditionalFormatting
Add a new Conditional Formatting to the sheet.
addConditionalFormatting(CellRangeAddress[], ConditionalFormattingRule) - Method in class org.apache.poi.xssf.usermodel.XSSFSheetConditionalFormatting
 
addConditionalFormatting(CellRangeAddress[], ConditionalFormattingRule[]) - Method in class org.apache.poi.hssf.usermodel.HSSFSheetConditionalFormatting
 
addConditionalFormatting(CellRangeAddress[], ConditionalFormattingRule[]) - Method in interface org.apache.poi.ss.usermodel.SheetConditionalFormatting
Add a new Conditional Formatting set to the sheet.
addConditionalFormatting(CellRangeAddress[], ConditionalFormattingRule[]) - Method in class org.apache.poi.xssf.usermodel.XSSFSheetConditionalFormatting
 
addConditionalFormatting(CellRangeAddress[], ConditionalFormattingRule, ConditionalFormattingRule) - Method in class org.apache.poi.hssf.usermodel.HSSFSheetConditionalFormatting
 
addConditionalFormatting(CellRangeAddress[], ConditionalFormattingRule, ConditionalFormattingRule) - Method in interface org.apache.poi.ss.usermodel.SheetConditionalFormatting
Add a new Conditional Formatting consisting of two rules.
addConditionalFormatting(CellRangeAddress[], ConditionalFormattingRule, ConditionalFormattingRule) - Method in class org.apache.poi.xssf.usermodel.XSSFSheetConditionalFormatting
 
addConnectionSite() - Method in class org.apache.poi.xddf.usermodel.XDDFCustomGeometry2D
 
addConnectionSite(ConnectionSiteIf) - Method in class org.apache.poi.sl.draw.geom.CustomGeometry
 
addContentType(PackagePartName, String) - Method in class org.apache.poi.openxml4j.opc.internal.ContentTypeManager
Build association extension-> content type (will be stored in [Content_Types].xml) for example ContentType="image/png" Extension="png"
addCRL(byte[]) - Method in class org.apache.poi.poifs.crypt.dsig.services.RevocationData
Adds a CRL to this revocation data set.
addCRL(String, String, byte[]) - Method in class org.apache.poi.poifs.crypt.dsig.SignatureConfig
 
addCRL(X509CRL) - Method in class org.apache.poi.poifs.crypt.dsig.services.RevocationData
Adds a CRL to this revocation data set.
addDashStop() - Method in class org.apache.poi.xddf.usermodel.XDDFLineProperties
 
addDataColumn(int, boolean) - Method in class org.apache.poi.xssf.usermodel.XSSFPivotTable
Add column containing data from the referenced area.
addDataValidation(DVRecord) - Method in class org.apache.poi.hssf.record.aggregates.DataValidityTable
 
addDbcell(int) - Method in class org.apache.poi.hssf.record.IndexRecord
 
addDefaultDataSpace(DirectoryEntry) - Static method in class org.apache.poi.poifs.crypt.DataSpaceMapUtils
 
addDefaultRunProperties() - Method in class org.apache.poi.xddf.usermodel.text.XDDFParagraphProperties
 
addDefaultRunProperties() - Method in class org.apache.poi.xddf.usermodel.text.XDDFTextParagraph
 
adddiv - Enum constant in enum org.apache.poi.sl.draw.geom.GuideIf.Op
 
addEndnote(XWPFEndnote) - Method in class org.apache.poi.xwpf.usermodel.XWPFEndnotes
add an XWPFEndnote to the document
addEndnote(CTFtnEdn) - Method in class org.apache.poi.xwpf.usermodel.XWPFDocument
Add a CTFtnEdn endnote to the document.
addEndnote(CTFtnEdn) - Method in class org.apache.poi.xwpf.usermodel.XWPFEndnotes
Add an endnote to the document
addEntry() - Method in class org.apache.poi.xddf.usermodel.chart.XDDFChartLegend
 
addEscherProperty(EscherProperty) - Method in class org.apache.poi.ddf.AbstractEscherOptRecord
Add a property to this record.
addEscherRecord(int, EscherRecord) - Method in class org.apache.poi.hssf.record.AbstractEscherHolderRecord
 
addEscherRecord(EscherRecord) - Method in class org.apache.poi.hssf.record.AbstractEscherHolderRecord
 
AddEval - Static variable in class org.apache.poi.ss.formula.eval.TwoOperandNumericOperation
 
addExternalRelationship(String, String) - Method in class org.apache.poi.openxml4j.opc.OPCPackage
Adds an external relationship to a part (except relationships part).
addExternalRelationship(String, String) - Method in class org.apache.poi.openxml4j.opc.PackagePart
Adds an external relationship to a part (except relationships part).
addExternalRelationship(String, String) - Method in interface org.apache.poi.openxml4j.opc.RelationshipSource
Adds an external relationship to a part (except relationships part).
addExternalRelationship(String, String, String) - Method in class org.apache.poi.openxml4j.opc.OPCPackage
Adds an external relationship to a part (except relationships part).
addExternalRelationship(String, String, String) - Method in class org.apache.poi.openxml4j.opc.PackagePart
Adds an external relationship to a part (except relationships part).
addExternalRelationship(String, String, String) - Method in interface org.apache.poi.openxml4j.opc.RelationshipSource
Adds an external relationship to a part (except relationships part).
addExternalWorkbook(String, Workbook) - Method in class org.apache.poi.xssf.usermodel.XSSFCreationHelper
 
addFacet(InputStream) - Method in class org.apache.poi.xslf.usermodel.XSLFFontInfo
 
addFont(InputStream) - Method in interface org.apache.poi.sl.usermodel.SlideShow
Add an EOT font to the slideshow.
addFont(InputStream) - Method in class org.apache.poi.xslf.usermodel.XMLSlideShow
 
addFontToSlideShow(XMLSlideShow, InputStream) - Static method in class org.apache.poi.xslf.usermodel.XSLFFontInfo
Adds or updates a (MTX-) font
addFootnote(XWPFFootnote) - Method in class org.apache.poi.xwpf.usermodel.XWPFFootnotes
Add an XWPFFootnote to the document
addFootnote(CTFtnEdn) - Method in class org.apache.poi.xwpf.usermodel.XWPFDocument
Add a CTFtnEdn footnote to the document.
addFootnote(CTFtnEdn) - Method in class org.apache.poi.xwpf.usermodel.XWPFFootnotes
Add a CT footnote to the document
addFootnoteReference(XWPFAbstractFootnoteEndnote) - Method in class org.apache.poi.xwpf.usermodel.XWPFParagraph
Add a new run with a reference to the specified footnote.
addFormat(String, Format) - Method in class org.apache.poi.ss.usermodel.DataFormatter
Adds a new format to the available formats.
addFormatRun(FormatRun) - Method in class org.apache.poi.hssf.record.common.UnicodeString
Adds a font run to the formatted string.
addGeomGuide(GuideIf) - Method in class org.apache.poi.sl.draw.geom.CustomGeometry
 
addGradientStop() - Method in class org.apache.poi.xddf.usermodel.XDDFGradientFillProperties
 
addGuide() - Method in class org.apache.poi.xddf.usermodel.XDDFCustomGeometry2D
 
addHyperlink(XSSFHyperlink) - Method in class org.apache.poi.xssf.streaming.SXSSFSheet
Register a hyperlink in the collection of hyperlinks on this sheet.
addHyperlink(XSSFHyperlink) - Method in class org.apache.poi.xssf.usermodel.XSSFSheet
Register a hyperlink in the collection of hyperlinks on this sheet.
addIgnoredErrors(CellRangeAddress, IgnoredErrorType...) - Method in class org.apache.poi.xssf.usermodel.XSSFSheet
Ignore errors across a range of cells.
addIgnoredErrors(CellReference, IgnoredErrorType...) - Method in class org.apache.poi.xssf.usermodel.XSSFSheet
Add ignored errors (usually to suppress them in the UI of a consuming application).
addIgnoredErrors(CTIgnoredError, String, IgnoredErrorType...) - Static method in class org.apache.poi.xssf.usermodel.helpers.XSSFIgnoredErrorHelper
 
addKnot(SplineKnot) - Method in class org.apache.poi.xdgf.geom.SplineCollector
 
addLateHeaderFooter(HeaderFooterRecord) - Method in class org.apache.poi.hssf.record.aggregates.PageSettingsBlock
HEADERFOOTER is new in 2007.
addLateRecords(RecordStream) - Method in class org.apache.poi.hssf.record.aggregates.PageSettingsBlock
This method reads PageSettingsBlock records from the supplied RecordStream until the first non-PageSettingsBlock record is encountered.
addLineBreak() - Method in class org.apache.poi.xslf.usermodel.XSLFTextParagraph
Insert a line break
addLineBreak() - Method in class org.apache.poi.xssf.usermodel.XSSFTextParagraph
Insert a line break
addListener(HSSFListener, short) - Method in class org.apache.poi.hssf.eventusermodel.HSSFRequest
add an event listener for a particular record type.
addListenerForAllRecords(HSSFListener) - Method in class org.apache.poi.hssf.eventusermodel.HSSFRequest
This is the equivalent of calling addListener(myListener, sid) for EVERY record in the org.apache.poi.hssf.record package.
addManifestObject(SignatureInfo, Document, List<Reference>, List<XMLObject>) - Method in class org.apache.poi.poifs.crypt.dsig.facets.OOXMLSignatureFacet
 
addManifestReferences(SignatureInfo, List<Reference>) - Method in class org.apache.poi.poifs.crypt.dsig.facets.OOXMLSignatureFacet
 
addMarshaller(String, PartMarshaller) - Method in class org.apache.poi.openxml4j.opc.OPCPackage
Add a marshaller.
addMergedRegion(int, int, int, int) - Method in class org.apache.poi.hssf.model.InternalSheet
 
addMergedRegion(CellRangeAddress) - Method in class org.apache.poi.hssf.usermodel.HSSFSheet
Adds a merged region of cells on a sheet.
addMergedRegion(CellRangeAddress) - Method in interface org.apache.poi.ss.usermodel.Sheet
Adds a merged region of cells (hence those cells form one)
addMergedRegion(CellRangeAddress) - Method in class org.apache.poi.xssf.streaming.SXSSFSheet
Adds a merged region of cells (hence those cells form one)
addMergedRegion(CellRangeAddress) - Method in class org.apache.poi.xssf.usermodel.XSSFSheet
Adds a merged region of cells on a sheet.
addMergedRegionUnsafe(CellRangeAddress) - Method in class org.apache.poi.hssf.usermodel.HSSFSheet
Adds a merged region of cells (hence those cells form one).
addMergedRegionUnsafe(CellRangeAddress) - Method in interface org.apache.poi.ss.usermodel.Sheet
Adds a merged region of cells (hence those cells form one).
addMergedRegionUnsafe(CellRangeAddress) - Method in class org.apache.poi.xssf.streaming.SXSSFSheet
Adds a merged region of cells (hence those cells form one)
addMergedRegionUnsafe(CellRangeAddress) - Method in class org.apache.poi.xssf.usermodel.XSSFSheet
Adds a merged region of cells (hence those cells form one).
addMimeType(String, String) - Method in class org.apache.poi.poifs.crypt.dsig.facets.XAdESSignatureFacet
Adds a mime-type for the given ds:Reference (referred via its @URI).
addMimeTypes(SignatureInfo, SignedPropertiesType) - Method in class org.apache.poi.poifs.crypt.dsig.facets.XAdESSignatureFacet
 
addMultipleBlanks(MulBlankRecord) - Method in class org.apache.poi.hssf.record.aggregates.ValueRecordsAggregate
 
addName(NameRecord) - Method in class org.apache.poi.hssf.model.InternalWorkbook
adds a name record
addNamespaceDeclaration(Element, String, String) - Static method in class org.apache.poi.ooxml.util.DocumentHelper
Adds a namespace declaration attribute to the given element.
addNamespaceDeclaration(Element, Namespace) - Static method in class org.apache.poi.ooxml.util.DocumentHelper
Adds a namespace declaration attribute to the given element.
addNewCol() - Method in class org.apache.poi.xwpf.usermodel.XWPFTable
Add a new cell at the end of each row in this table, creating a new column.
addNewErrorBars() - Method in class org.apache.poi.xddf.usermodel.chart.XDDFScatterChartData.Series
 
addNewParagraph() - Method in class org.apache.poi.xddf.usermodel.text.XDDFTextBody
 
addNewParagraph(CTP) - Method in class org.apache.poi.xwpf.usermodel.XWPFAbstractFootnoteEndnote
Add a new XWPFParagraph to the end of the footnote.
addNewPath() - Method in class org.apache.poi.xddf.usermodel.XDDFCustomGeometry2D
 
addNewTableCell() - Method in class org.apache.poi.xwpf.usermodel.XWPFTableRow
adds a new TableCell at the end of this tableRow
addNewTbl(CTTbl) - Method in class org.apache.poi.xwpf.usermodel.XWPFAbstractFootnoteEndnote
Add a new XWPFTable to the end of the footnote.
addNewTextParagraph() - Method in class org.apache.poi.xslf.usermodel.XSLFTextShape
add a new paragraph run to this shape
addNewTextParagraph() - Method in class org.apache.poi.xssf.usermodel.XSSFSimpleShape
Add a new paragraph run to this shape
addNewTextParagraph(String) - Method in class org.apache.poi.xssf.usermodel.XSSFSimpleShape
Add a new paragraph run to this shape, set to the provided string
addNewTextParagraph(XSSFRichTextString) - Method in class org.apache.poi.xssf.usermodel.XSSFSimpleShape
Add a new paragraph run to this shape, set to the provided rich text string
addNewTextRun() - Method in class org.apache.poi.xslf.usermodel.XSLFTextParagraph
Add a new run of text
addNewTextRun() - Method in class org.apache.poi.xssf.usermodel.XSSFTextParagraph
Add a new run of text
addNum(BigInteger) - Method in class org.apache.poi.xwpf.usermodel.XWPFNumbering
Add a new num with an abstractNumID
addNum(BigInteger, BigInteger) - Method in class org.apache.poi.xwpf.usermodel.XWPFNumbering
Add a new num with an abstractNumID and a numID
addNum(XWPFNum) - Method in class org.apache.poi.xwpf.usermodel.XWPFNumbering
add a new number to the numbering document
addOCSP(byte[]) - Method in class org.apache.poi.poifs.crypt.dsig.services.RevocationData
Adds an OCSP response to this revocation data set.
addOlePackage(byte[], String, String, String) - Method in class org.apache.poi.hssf.usermodel.HSSFWorkbook
 
addOlePackage(byte[], String, String, String) - Method in interface org.apache.poi.ss.usermodel.Workbook
Adds an OLE package manager object with the given content to the sheet
addOlePackage(byte[], String, String, String) - Method in class org.apache.poi.xssf.streaming.SXSSFWorkbook
 
addOlePackage(byte[], String, String, String) - Method in class org.apache.poi.xssf.usermodel.XSSFWorkbook
 
addOlePackage(POIFSFileSystem, String, String, String) - Method in class org.apache.poi.hssf.usermodel.HSSFWorkbook
Adds an OLE package manager object with the given POIFS to the sheet
addPackagePart(PackagePart) - Method in class org.apache.poi.openxml4j.opc.OPCPackage
Add the specified part to the package.
addParagraph() - Method in class org.apache.poi.xwpf.usermodel.XWPFTableCell
Add a Paragraph to this Table Cell
addParagraph(XWPFParagraph) - Method in class org.apache.poi.xwpf.usermodel.XWPFTableCell
add a Paragraph to this TableCell
addPath(PathIf) - Method in class org.apache.poi.sl.draw.geom.CustomGeometry
 
addPicture(byte[], int) - Method in class org.apache.poi.hssf.usermodel.HSSFWorkbook
Adds a picture to the workbook.
addPicture(byte[], int) - Method in interface org.apache.poi.ss.usermodel.Workbook
Adds a picture to the workbook.
addPicture(byte[], int) - Method in class org.apache.poi.xssf.streaming.SXSSFWorkbook
Adds a picture to the workbook.
addPicture(byte[], int) - Method in class org.apache.poi.xssf.usermodel.XSSFWorkbook
Adds a picture to the workbook.
addPicture(byte[], PictureData.PictureType) - Method in interface org.apache.poi.sl.usermodel.SlideShow
Adds a picture to the presentation.
addPicture(byte[], PictureData.PictureType) - Method in class org.apache.poi.xslf.usermodel.XMLSlideShow
Adds a picture to the workbook.
addPicture(File, PictureData.PictureType) - Method in interface org.apache.poi.sl.usermodel.SlideShow
Adds a picture to the presentation.
addPicture(File, PictureData.PictureType) - Method in class org.apache.poi.xslf.usermodel.XMLSlideShow
Adds a picture to the presentation.
addPicture(InputStream, int) - Method in class org.apache.poi.xssf.usermodel.XSSFWorkbook
Adds a picture to the workbook.
addPicture(InputStream, int, String, int, int) - Method in class org.apache.poi.xwpf.usermodel.XWPFRun
Adds a picture to the run.
addPicture(InputStream, PictureType, String, int, int) - Method in class org.apache.poi.xwpf.usermodel.XWPFRun
Adds a picture to the run.
addPicture(InputStream, PictureData.PictureType) - Method in interface org.apache.poi.sl.usermodel.SlideShow
Adds a picture to the presentation.
addPicture(InputStream, PictureData.PictureType) - Method in class org.apache.poi.xslf.usermodel.XMLSlideShow
Adds a picture to the slideshow.
addPictureData(byte[], int) - Method in class org.apache.poi.xwpf.usermodel.XWPFComments
Adds a picture to the comments.
addPictureData(byte[], int) - Method in class org.apache.poi.xwpf.usermodel.XWPFDocument
Adds a picture to the document.
addPictureData(byte[], int) - Method in class org.apache.poi.xwpf.usermodel.XWPFHeaderFooter
Adds a picture to the document.
addPictureData(byte[], PictureType) - Method in interface org.apache.poi.poifs.crypt.dsig.SignatureLine.AddPictureData
Add picture data to the document
addPictureData(byte[], PictureType) - Method in class org.apache.poi.xwpf.usermodel.XWPFComments
Adds a picture to the comments.
addPictureData(byte[], PictureType) - Method in class org.apache.poi.xwpf.usermodel.XWPFDocument
Adds a picture to the document.
addPictureData(byte[], PictureType) - Method in class org.apache.poi.xwpf.usermodel.XWPFHeaderFooter
Adds a picture to the document.
addPictureData(InputStream, int) - Method in class org.apache.poi.xwpf.usermodel.XWPFComments
Adds a picture to the comments.
addPictureData(InputStream, int) - Method in class org.apache.poi.xwpf.usermodel.XWPFDocument
Adds a picture to the document.
addPictureData(InputStream, int) - Method in class org.apache.poi.xwpf.usermodel.XWPFHeaderFooter
Adds a picture to the document.
addPictureData(InputStream, PictureType) - Method in class org.apache.poi.xwpf.usermodel.XWPFComments
Adds a picture to the comments.
addPictureData(InputStream, PictureType) - Method in class org.apache.poi.xwpf.usermodel.XWPFDocument
Adds a picture to the document.
addPictureData(InputStream, PictureType) - Method in class org.apache.poi.xwpf.usermodel.XWPFHeaderFooter
Adds a picture to the document.
addPictureReference(int) - Method in class org.apache.poi.xssf.usermodel.XSSFDrawing
Add the indexed picture to this drawing relations
addPivotCache(String) - Method in class org.apache.poi.xssf.usermodel.XSSFWorkbook
Add pivotCache to the workbook
addPolarAdjustHandle() - Method in class org.apache.poi.xddf.usermodel.XDDFCustomGeometry2D
 
addPolicy(SignatureInfo, SignedSignaturePropertiesType) - Method in class org.apache.poi.poifs.crypt.dsig.facets.XAdESSignatureFacet
 
addProperty(String, boolean) - Method in class org.apache.poi.ooxml.POIXMLProperties.CustomProperties
Add a new boolean property
addProperty(String, double) - Method in class org.apache.poi.ooxml.POIXMLProperties.CustomProperties
Add a new double property
addProperty(String, int) - Method in class org.apache.poi.ooxml.POIXMLProperties.CustomProperties
Add a new integer property
addProperty(String, String) - Method in class org.apache.poi.ooxml.POIXMLProperties.CustomProperties
Add a new string property
addProperty(Property) - Method in class org.apache.poi.poifs.property.PropertyTable
Add a property to the list of properties we manage
addProvider(ExtractorProvider) - Static method in class org.apache.poi.extractor.ExtractorFactory
 
addProvider(SlideShowProvider<?, ?>) - Static method in class org.apache.poi.sl.usermodel.SlideShowFactory
 
addProvider(WorkbookProvider) - Static method in class org.apache.poi.ss.usermodel.WorkbookFactory
 
AddPtg - Class in org.apache.poi.ss.formula.ptg
Addition operator PTG the "+" binomial operator.
addRecords(RecordStream) - Method in class org.apache.poi.hssf.record.aggregates.WorksheetProtectionBlock
This method reads WorksheetProtectionBlock records from the supplied RecordStream until the first non-WorksheetProtectionBlock record is encountered.
addRecords(MergeCellsRecord[]) - Method in class org.apache.poi.hssf.record.aggregates.MergedCellsTable
 
addRef(int, int, int) - Method in class org.apache.poi.hssf.record.ExternSheetRecord
Add a zero-based reference to a SupBookRecord.
addREFRecord(ExternSheetRecord.RefSubRecord) - Method in class org.apache.poi.hssf.record.ExternSheetRecord
adds REF struct (ExternSheetSubRecord)
addRelation(String, POIXMLRelation, POIXMLDocumentPart) - Method in class org.apache.poi.ooxml.POIXMLDocumentPart
Add a new child POIXMLDocumentPart
addRelationship(URI, TargetMode, String) - Method in class org.apache.poi.openxml4j.opc.PackagePart
Add a relationship to a part (except relationships part).
addRelationship(URI, TargetMode, String, String) - Method in class org.apache.poi.openxml4j.opc.PackagePart
Add a relationship to a part (except relationships part).
addRelationship(URI, TargetMode, String, String) - Method in class org.apache.poi.openxml4j.opc.PackageRelationshipCollection
Add a relationship to the collection.
addRelationship(PackagePartName, TargetMode, String) - Method in class org.apache.poi.openxml4j.opc.OPCPackage
Add a package relationship.
addRelationship(PackagePartName, TargetMode, String) - Method in class org.apache.poi.openxml4j.opc.PackagePart
Add a relationship to a part (except relationships part).
addRelationship(PackagePartName, TargetMode, String) - Method in interface org.apache.poi.openxml4j.opc.RelationshipSource
Add a relationship to a part (except relationships part).
addRelationship(PackagePartName, TargetMode, String, String) - Method in class org.apache.poi.openxml4j.opc.OPCPackage
Add a relationship to the package (except relationships part).
addRelationship(PackagePartName, TargetMode, String, String) - Method in class org.apache.poi.openxml4j.opc.PackagePart
Add a relationship to a part (except relationships part).
addRelationship(PackagePartName, TargetMode, String, String) - Method in interface org.apache.poi.openxml4j.opc.RelationshipSource
Add a relationship to a part (except relationships part).
addRelationship(PackageRelationship) - Method in class org.apache.poi.openxml4j.opc.PackageRelationshipCollection
Add the specified relationship to the collection.
addRelationshipReference(String) - Method in class org.apache.poi.poifs.crypt.dsig.services.RelationshipTransformService.RelationshipTransformParameterSpec
 
addRenderingHints(Map) - Method in class org.apache.poi.xslf.draw.SVGPOIGraphics2D
 
addRenderingHints(Map<?, ?>) - Method in class org.apache.poi.hssf.usermodel.EscherGraphics2d
 
addRenderingHints(Map<?, ?>) - Method in class org.apache.poi.sl.draw.SLGraphics
Sets the values of an arbitrary number of preferences for the rendering algorithms.
addRenderingHints(Map<?, ?>) - Method in class org.apache.poi.xslf.util.DummyGraphics2d
 
addReportFilter(int) - Method in class org.apache.poi.xssf.usermodel.XSSFPivotTable
Add filter for the column with the corresponding index and cell value
Address - Class in org.apache.poi.ss.formula.functions
Creates a text reference as text, given specified row and column numbers.
Address() - Constructor for class org.apache.poi.ss.formula.functions.Address
 
addRow() - Method in class org.apache.poi.xslf.usermodel.XSLFTable
 
addRow(int, String, int, String) - Method in class org.apache.poi.xwpf.usermodel.TOC
 
addRow(RowRecord) - Method in class org.apache.poi.hssf.model.InternalSheet
Adds a row record to the sheet
addRow(XWPFTableRow) - Method in class org.apache.poi.xwpf.usermodel.XWPFTable
add a new Row to the table
addRow(XWPFTableRow, int) - Method in class org.apache.poi.xwpf.usermodel.XWPFTable
add a new Row to the table at position pos
addRowLabel(int) - Method in class org.apache.poi.xssf.usermodel.XSSFPivotTable
Add a row label using data from the given column.
addRule(CFRuleBase) - Method in class org.apache.poi.hssf.record.aggregates.CFRecordsAggregate
 
addRule(HSSFConditionalFormattingRule) - Method in class org.apache.poi.hssf.usermodel.HSSFConditionalFormatting
add a Conditional Formatting rule.
addRule(ConditionalFormattingRule) - Method in class org.apache.poi.hssf.usermodel.HSSFConditionalFormatting
 
addRule(ConditionalFormattingRule) - Method in interface org.apache.poi.ss.usermodel.ConditionalFormatting
Add a Conditional Formatting rule.
addRule(ConditionalFormattingRule) - Method in class org.apache.poi.xssf.usermodel.XSSFConditionalFormatting
Add a Conditional Formatting rule.
addRun(XWPFRun) - Method in class org.apache.poi.xwpf.usermodel.XWPFParagraph
adds a new Run to the Paragraph
addRun(CTR) - Method in class org.apache.poi.xwpf.usermodel.XWPFParagraph
add a new run at the end of the position of the content of parameter run
addSection(Section) - Method in class org.apache.poi.hpsf.PropertySet
Adds a section to this property set.
addSeries(XDDFDataSource<?>, XDDFNumericalDataSource<? extends Number>) - Method in class org.apache.poi.xddf.usermodel.chart.XDDFArea3DChartData
 
addSeries(XDDFDataSource<?>, XDDFNumericalDataSource<? extends Number>) - Method in class org.apache.poi.xddf.usermodel.chart.XDDFAreaChartData
 
addSeries(XDDFDataSource<?>, XDDFNumericalDataSource<? extends Number>) - Method in class org.apache.poi.xddf.usermodel.chart.XDDFBar3DChartData
 
addSeries(XDDFDataSource<?>, XDDFNumericalDataSource<? extends Number>) - Method in class org.apache.poi.xddf.usermodel.chart.XDDFBarChartData
 
addSeries(XDDFDataSource<?>, XDDFNumericalDataSource<? extends Number>) - Method in class org.apache.poi.xddf.usermodel.chart.XDDFBubbleChartData
 
addSeries(XDDFDataSource<?>, XDDFNumericalDataSource<? extends Number>) - Method in class org.apache.poi.xddf.usermodel.chart.XDDFChartData
 
addSeries(XDDFDataSource<?>, XDDFNumericalDataSource<? extends Number>) - Method in class org.apache.poi.xddf.usermodel.chart.XDDFDoughnutChartData
 
addSeries(XDDFDataSource<?>, XDDFNumericalDataSource<? extends Number>) - Method in class org.apache.poi.xddf.usermodel.chart.XDDFLine3DChartData
 
addSeries(XDDFDataSource<?>, XDDFNumericalDataSource<? extends Number>) - Method in class org.apache.poi.xddf.usermodel.chart.XDDFLineChartData
 
addSeries(XDDFDataSource<?>, XDDFNumericalDataSource<? extends Number>) - Method in class org.apache.poi.xddf.usermodel.chart.XDDFPie3DChartData
 
addSeries(XDDFDataSource<?>, XDDFNumericalDataSource<? extends Number>) - Method in class org.apache.poi.xddf.usermodel.chart.XDDFPieChartData
 
addSeries(XDDFDataSource<?>, XDDFNumericalDataSource<? extends Number>) - Method in class org.apache.poi.xddf.usermodel.chart.XDDFRadarChartData
 
addSeries(XDDFDataSource<?>, XDDFNumericalDataSource<? extends Number>) - Method in class org.apache.poi.xddf.usermodel.chart.XDDFScatterChartData
 
addSeries(XDDFDataSource<?>, XDDFNumericalDataSource<? extends Number>) - Method in class org.apache.poi.xddf.usermodel.chart.XDDFSurface3DChartData
 
addSeries(XDDFDataSource<?>, XDDFNumericalDataSource<? extends Number>) - Method in class org.apache.poi.xddf.usermodel.chart.XDDFSurfaceChartData
 
addShape(HSSFShape) - Method in class org.apache.poi.hssf.usermodel.HSSFPatriarch
add a shape to this drawing
addShape(HSSFShape) - Method in interface org.apache.poi.hssf.usermodel.HSSFShapeContainer
add shape to the list of child records
addShape(HSSFShape) - Method in class org.apache.poi.hssf.usermodel.HSSFShapeGroup
 
addShape(XSLFShape) - Method in class org.apache.poi.xslf.usermodel.XSLFGroupShape
 
addShape(XSLFShape) - Method in class org.apache.poi.xslf.usermodel.XSLFSheet
 
addShape(S) - Method in interface org.apache.poi.sl.usermodel.ShapeContainer
 
addSharedStringItem(RichTextString) - Method in class org.apache.poi.xssf.model.SharedStringsTable
Add an entry to this Shared String table (a new value is appended to the end).
addSignatureFacet(SignatureFacet) - Method in class org.apache.poi.poifs.crypt.dsig.SignatureConfig
 
addSignatureInfo(SignatureInfo, Document, List<Reference>, List<XMLObject>) - Method in class org.apache.poi.poifs.crypt.dsig.facets.OOXMLSignatureFacet
 
addSignatureTime(SignatureInfo, Document, List<XMLStructure>) - Method in class org.apache.poi.poifs.crypt.dsig.facets.OOXMLSignatureFacet
 
addSigningTime(SignatureInfo, SignedSignaturePropertiesType) - Method in class org.apache.poi.poifs.crypt.dsig.facets.XAdESSignatureFacet
 
addSlide(double, double) - Method in class org.apache.poi.xslf.util.BitmapFormat
 
addSlide(double, double) - Method in class org.apache.poi.xslf.util.DummyFormat
 
addSlide(double, double) - Method in class org.apache.poi.xslf.util.PDFFormat
 
addSlide(double, double) - Method in class org.apache.poi.xslf.util.SVGFormat
 
addSSTString(UnicodeString) - Method in class org.apache.poi.hssf.model.InternalWorkbook
Adds a string to the SST table and returns its index (if its a duplicate just returns its index and update the counts) ASSUMES compressed unicode (meaning 8bit)
addString(UnicodeString) - Method in class org.apache.poi.hssf.record.SSTRecord
Add a string.
addStyle(XWPFStyle) - Method in class org.apache.poi.xwpf.usermodel.XWPFStyles
add a style to the document
addsub - Enum constant in enum org.apache.poi.sl.draw.geom.GuideIf.Op
 
addSubRecord(int, SubRecord) - Method in class org.apache.poi.hssf.record.ObjRecord
 
addSubRecord(SubRecord) - Method in class org.apache.poi.hssf.record.ObjRecord
 
addSvgImage(XSLFSheet, XSLFPictureData, PictureData.PictureType, Rectangle2D) - Static method in class org.apache.poi.xslf.usermodel.XSLFPictureShape
Convenience method for adding SVG images, which generates the preview image
addTab() - Method in class org.apache.poi.xwpf.usermodel.XWPFRun
Specifies that a tab shall be placed at the current location in the run content.
addTabStop() - Method in class org.apache.poi.xddf.usermodel.text.XDDFParagraphProperties
 
addTabStop() - Method in class org.apache.poi.xddf.usermodel.text.XDDFTextParagraph
 
addTabStop(double) - Method in class org.apache.poi.xslf.usermodel.XSLFTextParagraph
 
addTabStop(double) - Method in class org.apache.poi.xssf.usermodel.XSSFTextParagraph
Add a single tab stop to be used on a line of text when there are one or more tab characters present within the text.
addTabStops(double, TabStop.TabStopType) - Method in interface org.apache.poi.sl.usermodel.TextParagraph
Set the TabStop collection
addTabStops(double, TabStop.TabStopType) - Method in class org.apache.poi.xslf.usermodel.XSLFTextParagraph
 
addTailRecord(NoteRecord) - Method in class org.apache.poi.hssf.record.EscherAggregate
Add tail record to existing map
addThumbnail(String) - Method in class org.apache.poi.openxml4j.opc.OPCPackage
Add a thumbnail to the package.
addThumbnail(String, InputStream) - Method in class org.apache.poi.openxml4j.opc.OPCPackage
Add a thumbnail to the package.
addToolPack(UDFFinder) - Method in class org.apache.poi.hssf.usermodel.HSSFWorkbook
Register a new toolpack in this workbook.
addToolPack(UDFFinder) - Method in interface org.apache.poi.ss.usermodel.Workbook
Register a new toolpack in this workbook.
addToolPack(UDFFinder) - Method in class org.apache.poi.xssf.streaming.SXSSFWorkbook
Register a new toolpack in this workbook.
addToolPack(UDFFinder) - Method in class org.apache.poi.xssf.usermodel.XSSFWorkbook
Register a new toolpack in this workbook.
addToPath(Path2D.Double, XDGFShape) - Method in class org.apache.poi.xdgf.geom.SplineCollector
 
addToPath(Path2D.Double, XDGFShape) - Method in class org.apache.poi.xdgf.usermodel.section.geometry.ArcTo
 
addToPath(Path2D.Double, XDGFShape) - Method in class org.apache.poi.xdgf.usermodel.section.geometry.Ellipse
 
addToPath(Path2D.Double, XDGFShape) - Method in class org.apache.poi.xdgf.usermodel.section.geometry.EllipticalArcTo
 
addToPath(Path2D.Double, XDGFShape) - Method in interface org.apache.poi.xdgf.usermodel.section.geometry.GeometryRow
 
addToPath(Path2D.Double, XDGFShape) - Method in class org.apache.poi.xdgf.usermodel.section.geometry.InfiniteLine
 
addToPath(Path2D.Double, XDGFShape) - Method in class org.apache.poi.xdgf.usermodel.section.geometry.LineTo
 
addToPath(Path2D.Double, XDGFShape) - Method in class org.apache.poi.xdgf.usermodel.section.geometry.MoveTo
 
addToPath(Path2D.Double, XDGFShape) - Method in class org.apache.poi.xdgf.usermodel.section.geometry.NURBSTo
 
addToPath(Path2D.Double, XDGFShape) - Method in class org.apache.poi.xdgf.usermodel.section.geometry.PolyLineTo
 
addToPath(Path2D.Double, XDGFShape) - Method in class org.apache.poi.xdgf.usermodel.section.geometry.RelCubBezTo
 
addToPath(Path2D.Double, XDGFShape) - Method in class org.apache.poi.xdgf.usermodel.section.geometry.RelEllipticalArcTo
 
addToPath(Path2D.Double, XDGFShape) - Method in class org.apache.poi.xdgf.usermodel.section.geometry.RelLineTo
 
addToPath(Path2D.Double, XDGFShape) - Method in class org.apache.poi.xdgf.usermodel.section.geometry.RelMoveTo
 
addToPath(Path2D.Double, XDGFShape) - Method in class org.apache.poi.xdgf.usermodel.section.geometry.RelQuadBezTo
 
addToPath(Path2D.Double, XDGFShape) - Method in class org.apache.poi.xdgf.usermodel.section.geometry.SplineKnot
 
addToPath(Path2D.Double, XDGFShape) - Method in class org.apache.poi.xdgf.usermodel.section.geometry.SplineStart
 
addToShapeIndex(XDGFShape) - Method in class org.apache.poi.xdgf.usermodel.XDGFBaseContents
 
addUnmarshaller(String, PartUnmarshaller) - Method in class org.apache.poi.openxml4j.opc.OPCPackage
Add an unmarshaller.
addValidationData(DataValidation) - Method in class org.apache.poi.hssf.usermodel.HSSFSheet
Creates a data validation object
addValidationData(DataValidation) - Method in interface org.apache.poi.ss.usermodel.Sheet
Creates a data validation object
addValidationData(DataValidation) - Method in class org.apache.poi.xssf.streaming.SXSSFSheet
Creates a data validation object
addValidationData(DataValidation) - Method in class org.apache.poi.xssf.usermodel.XSSFSheet
 
addValueRecord(int, CellValueRecordInterface) - Method in class org.apache.poi.hssf.model.InternalSheet
Adds a value record to the sheet's contained binary records (i.e.
addXadesObject(SignatureInfo, Document, QualifyingPropertiesType) - Method in class org.apache.poi.poifs.crypt.dsig.facets.XAdESSignatureFacet
 
addXadesReference(SignatureInfo) - Method in class org.apache.poi.poifs.crypt.dsig.facets.XAdESSignatureFacet
 
addXadesRole(SignatureInfo, SignedSignaturePropertiesType) - Method in class org.apache.poi.poifs.crypt.dsig.facets.XAdESSignatureFacet
 
addXYAdjustHandle() - Method in class org.apache.poi.xddf.usermodel.XDDFCustomGeometry2D
 
adjustCellReferencesInsideFormula(Cell, Sheet, int, int) - Method in class org.apache.poi.hssf.usermodel.HSSFRangeCopier
 
adjustCellReferencesInsideFormula(Cell, Sheet, int, int) - Method in class org.apache.poi.ss.usermodel.RangeCopier
 
adjustCellReferencesInsideFormula(Cell, Sheet, int, int) - Method in class org.apache.poi.xssf.usermodel.XSSFRangeCopier
 
adjustDictionaryOffset(int) - Method in class org.apache.poi.util.LZWDecompresser
Adjusts the position offset if needed when looking something up in the dictionary.
adjustFormula(Ptg[], int) - Method in class org.apache.poi.ss.formula.FormulaShifter
 
AdjustHandle - Interface in org.apache.poi.sl.draw.geom
 
adjustInBothDirections(Ptg[], int, int, int) - Method in class org.apache.poi.ss.usermodel.RangeCopier
 
AdjustPoint - Class in org.apache.poi.sl.draw.geom
Java class for CT_AdjPoint2D complex type.
AdjustPoint() - Constructor for class org.apache.poi.sl.draw.geom.AdjustPoint
 
AdjustPointIf - Interface in org.apache.poi.sl.draw.geom
 
AdjustValue - Class in org.apache.poi.sl.draw.geom
Represents a shape adjust values (see section 20.1.9.5 in the spec)
AdjustValue() - Constructor for class org.apache.poi.sl.draw.geom.AdjustValue
 
AdjustValueIf - Interface in org.apache.poi.sl.draw.geom
 
aes - Enum constant in enum org.apache.poi.poifs.crypt.CipherProvider
 
aes128 - Enum constant in enum org.apache.poi.poifs.crypt.CipherAlgorithm
 
aes192 - Enum constant in enum org.apache.poi.poifs.crypt.CipherAlgorithm
 
aes256 - Enum constant in enum org.apache.poi.poifs.crypt.CipherAlgorithm
 
AesZipFileZipEntrySource - Class in org.apache.poi.poifs.crypt.temp
An example ZipEntrySource that has encrypted temp files to ensure that sensitive data is not stored in raw format on disk.
AF - Enum constant in enum org.apache.poi.util.LocaleID
 
AF_ZA - Enum constant in enum org.apache.poi.util.LocaleID
 
AFTER - Static variable in class org.apache.poi.ss.format.CellNumberStringMod
 
afterRecordSerialize(int, short, int, EscherRecord) - Method in interface org.apache.poi.ddf.EscherSerializationListener
Fired after a record has been serialized.
afterRecordSerialize(int, short, int, EscherRecord) - Method in class org.apache.poi.ddf.NullEscherSerializationListener
 
afterRemove(HSSFPatriarch) - Method in class org.apache.poi.hssf.usermodel.HSSFComment
 
afterRemove(HSSFPatriarch) - Method in class org.apache.poi.hssf.usermodel.HSSFObjectData
 
afterRemove(HSSFPatriarch) - Method in class org.apache.poi.hssf.usermodel.HSSFPolygon
 
afterRemove(HSSFPatriarch) - Method in class org.apache.poi.hssf.usermodel.HSSFShape
remove escher container from the patriarch.escherAggregate remove obj, textObj and note records if it's necessary in case of ShapeGroup remove all contained shapes
afterRemove(HSSFPatriarch) - Method in class org.apache.poi.hssf.usermodel.HSSFShapeGroup
 
afterRemove(HSSFPatriarch) - Method in class org.apache.poi.hssf.usermodel.HSSFSimpleShape
 
afterRemove(HSSFPatriarch) - Method in class org.apache.poi.hssf.usermodel.HSSFTextbox
 
aggregateDrawingRecords(DrawingManager2, boolean) - Method in class org.apache.poi.hssf.model.InternalSheet
Finds the DrawingRecord for our sheet, and attaches it to the DrawingManager (which knows about the overall DrawingGroup for our workbook).
AggregateFunction - Class in org.apache.poi.ss.formula.functions
 
AggregateFunction() - Constructor for class org.apache.poi.ss.formula.functions.AggregateFunction
 
AggregateFunction(boolean) - Constructor for class org.apache.poi.ss.formula.functions.AggregateFunction
 
aggregateMatchingCells(Baseifs.Aggregator, AreaEval, AreaEval, CountUtils.I_MatchPredicate) - Method in class org.apache.poi.ss.formula.functions.AverageIf
 
AggregatingUDFFinder - Class in org.apache.poi.ss.formula.udf
Collects add-in libraries and VB macro functions together into one UDF finder
AggregatingUDFFinder(UDFFinder...) - Constructor for class org.apache.poi.ss.formula.udf.AggregatingUDFFinder
 
agile - Enum constant in enum org.apache.poi.poifs.crypt.EncryptionMode
 
AgileDecryptor - Class in org.apache.poi.poifs.crypt.agile
Decryptor implementation for Agile Encryption
AgileDecryptor() - Constructor for class org.apache.poi.poifs.crypt.agile.AgileDecryptor
 
AgileDecryptor(AgileDecryptor) - Constructor for class org.apache.poi.poifs.crypt.agile.AgileDecryptor
 
AgileEncryptionHeader - Class in org.apache.poi.poifs.crypt.agile
 
AgileEncryptionHeader(String) - Constructor for class org.apache.poi.poifs.crypt.agile.AgileEncryptionHeader
 
AgileEncryptionHeader(AgileEncryptionHeader) - Constructor for class org.apache.poi.poifs.crypt.agile.AgileEncryptionHeader
 
AgileEncryptionHeader(EncryptionDocument) - Constructor for class org.apache.poi.poifs.crypt.agile.AgileEncryptionHeader
 
AgileEncryptionHeader(CipherAlgorithm, HashAlgorithm, int, int, ChainingMode) - Constructor for class org.apache.poi.poifs.crypt.agile.AgileEncryptionHeader
 
AgileEncryptionInfoBuilder - Class in org.apache.poi.poifs.crypt.agile
 
AgileEncryptionInfoBuilder() - Constructor for class org.apache.poi.poifs.crypt.agile.AgileEncryptionInfoBuilder
 
AgileEncryptionVerifier - Class in org.apache.poi.poifs.crypt.agile
Used when checking if a key is valid for a document
AgileEncryptionVerifier(String) - Constructor for class org.apache.poi.poifs.crypt.agile.AgileEncryptionVerifier
 
AgileEncryptionVerifier(AgileEncryptionVerifier) - Constructor for class org.apache.poi.poifs.crypt.agile.AgileEncryptionVerifier
 
AgileEncryptionVerifier(EncryptionDocument) - Constructor for class org.apache.poi.poifs.crypt.agile.AgileEncryptionVerifier
 
AgileEncryptionVerifier(CipherAlgorithm, HashAlgorithm, int, int, ChainingMode) - Constructor for class org.apache.poi.poifs.crypt.agile.AgileEncryptionVerifier
 
AgileEncryptor - Class in org.apache.poi.poifs.crypt.agile
 
AgileEncryptor() - Constructor for class org.apache.poi.poifs.crypt.agile.AgileEncryptor
 
AgileEncryptor(AgileEncryptor) - Constructor for class org.apache.poi.poifs.crypt.agile.AgileEncryptor
 
ALICE_BLUE - Enum constant in enum org.apache.poi.xddf.usermodel.PresetColor
 
AliceBlue - Enum constant in enum org.apache.poi.sl.usermodel.PresetColor
 
ALIGN_RULE - Enum constant in enum org.apache.poi.ddf.EscherRecordTypes
 
ALIGNMENT - Static variable in class org.apache.poi.ss.util.CellUtil
 
ALL - Enum constant in enum org.apache.poi.sl.usermodel.TextRun.TextCap
 
ALL - Enum constant in enum org.apache.poi.ss.usermodel.BorderExtent
All borders, that is top, bottom, left and right, including interior borders for the range.
ALL - Enum constant in enum org.apache.poi.xddf.usermodel.text.CapsType
 
ALL - Enum constant in enum org.apache.poi.xssf.usermodel.TextCap
 
ALL - Enum constant in enum org.apache.poi.xwpf.usermodel.BreakClear
Specifies that the text wrapping break shall advance the text to the next line in the WordprocessingML document which spans the full width of the line.
allCellsIterator() - Method in class org.apache.poi.xssf.streaming.SXSSFRow
 
allCellsSpliterator() - Method in class org.apache.poi.xssf.streaming.SXSSFRow
 
allocateShapeId() - Method in class org.apache.poi.xslf.usermodel.XSLFSheet
 
allocateShapeId(EscherDgRecord) - Method in class org.apache.poi.hssf.model.DrawingManager2
Allocates new shape id for the drawing group
allocateShapeId(EscherDgRecord, boolean) - Method in class org.apache.poi.ddf.EscherDggRecord
Allocates new shape id for the drawing group
allowedKeySize - Variable in enum org.apache.poi.poifs.crypt.CipherAlgorithm
 
allowEmptyMatchField() - Method in class org.apache.poi.ss.formula.functions.DCount
 
allowEmptyMatchField() - Method in class org.apache.poi.ss.formula.functions.DCountA
 
allowEmptyMatchField() - Method in interface org.apache.poi.ss.formula.functions.IDStarAlgorithm
Whether the field value (the 2nd param in DCOUNT, DGET, etc.) can evaluate to empty.
ALPHA_LC_PARENT_BOTH - Enum constant in enum org.apache.poi.xssf.usermodel.ListAutoNumber
(a), (b), (c), ...
ALPHA_LC_PARENT_R - Enum constant in enum org.apache.poi.xssf.usermodel.ListAutoNumber
a), b), c), ...
ALPHA_LC_PERIOD - Enum constant in enum org.apache.poi.xssf.usermodel.ListAutoNumber
a., b., c., ...
ALPHA_UC_PARENT_BOTH - Enum constant in enum org.apache.poi.xssf.usermodel.ListAutoNumber
(A), (B), (C), ...
ALPHA_UC_PARENT_R - Enum constant in enum org.apache.poi.xssf.usermodel.ListAutoNumber
A), B), C), ...
ALPHA_UC_PERIOD - Enum constant in enum org.apache.poi.xssf.usermodel.ListAutoNumber
A., B., C., ...
ALPHABETIC_LOWERCASE_PARENTHESES_BOTH - Enum constant in enum org.apache.poi.xddf.usermodel.text.AutonumberScheme
 
ALPHABETIC_LOWERCASE_PARENTHESIS_RIGHT - Enum constant in enum org.apache.poi.xddf.usermodel.text.AutonumberScheme
 
ALPHABETIC_LOWERCASE_PERIOD - Enum constant in enum org.apache.poi.xddf.usermodel.text.AutonumberScheme
 
ALPHABETIC_UPPERCASE_PARENTHESES_BOTH - Enum constant in enum org.apache.poi.xddf.usermodel.text.AutonumberScheme
 
ALPHABETIC_UPPERCASE_PARENTHESIS_RIGHT - Enum constant in enum org.apache.poi.xddf.usermodel.text.AutonumberScheme
 
ALPHABETIC_UPPERCASE_PERIOD - Enum constant in enum org.apache.poi.xddf.usermodel.text.AutonumberScheme
 
alphaLcParenBoth - Enum constant in enum org.apache.poi.sl.usermodel.AutoNumberingScheme
Lowercase alphabetic character enclosed in parentheses.
alphaLcParenRight - Enum constant in enum org.apache.poi.sl.usermodel.AutoNumberingScheme
Lowercase alphabetic character followed by a closing parenthesis.
alphaLcPeriod - Enum constant in enum org.apache.poi.sl.usermodel.AutoNumberingScheme
Lowercase Latin character followed by a period.
alphaUcParenBoth - Enum constant in enum org.apache.poi.sl.usermodel.AutoNumberingScheme
Uppercase alphabetic character enclosed in parentheses.
alphaUcParenRight - Enum constant in enum org.apache.poi.sl.usermodel.AutoNumberingScheme
Uppercase alphabetic character followed by a closing parenthesis.
alphaUcPeriod - Enum constant in enum org.apache.poi.sl.usermodel.AutoNumberingScheme
Uppercase Latin character followed by a period.
ALT_BARS - Enum constant in enum org.apache.poi.ss.usermodel.FillPatternType
Wide dots
ALT_BARS - Static variable in class org.apache.poi.hssf.record.cf.PatternFormatting
Wide dots
ALT_BARS - Static variable in class org.apache.poi.hssf.record.ExtendedFormatRecord
 
ALT_BARS - Static variable in interface org.apache.poi.ss.usermodel.PatternFormatting
Wide dots
AM - Enum constant in enum org.apache.poi.util.LocaleID
 
AM_ET - Enum constant in enum org.apache.poi.util.LocaleID
 
AnalysisToolPak - Class in org.apache.poi.ss.formula.atp
Analysis Toolpack Function Definitions
anchor - Variable in class org.apache.poi.xssf.usermodel.XSSFShape
anchor that is used by this shape
ANCHOR - Enum constant in enum org.apache.poi.ddf.EscherRecordTypes
 
ANCHOR_ID_CHART_TITLE - Static variable in class org.apache.poi.hssf.record.chart.ObjectLinkRecord
 
ANCHOR_ID_SERIES_OR_POINT - Static variable in class org.apache.poi.hssf.record.chart.ObjectLinkRecord
 
ANCHOR_ID_X_AXIS - Static variable in class org.apache.poi.hssf.record.chart.ObjectLinkRecord
 
ANCHOR_ID_Y_AXIS - Static variable in class org.apache.poi.hssf.record.chart.ObjectLinkRecord
 
ANCHOR_ID_Z_AXIS - Static variable in class org.apache.poi.hssf.record.chart.ObjectLinkRecord
 
AnchorType - Enum in org.apache.poi.xddf.usermodel.text
 
AND - Static variable in class org.apache.poi.ss.formula.functions.BooleanFunction
 
Angles - Class in org.apache.poi.xddf.usermodel
 
Angles() - Constructor for class org.apache.poi.xddf.usermodel.Angles
 
ANSI - Enum constant in enum org.apache.poi.common.usermodel.fonts.FontCharset
Specifies the English character set.
ANSI - Enum constant in enum org.apache.poi.ss.usermodel.FontCharset
Deprecated.
 
ANSI_CHARSET - Static variable in interface org.apache.poi.ss.usermodel.Font
ANSI character set
ANTIQUE_WHITE - Enum constant in enum org.apache.poi.xddf.usermodel.PresetColor
 
AntiqueWhite - Enum constant in enum org.apache.poi.sl.usermodel.PresetColor
 
ANY - Enum constant in enum org.apache.poi.common.usermodel.fonts.FontHeader.PanoseArmStyle
 
ANY - Enum constant in enum org.apache.poi.common.usermodel.fonts.FontHeader.PanoseContrast
 
ANY - Enum constant in enum org.apache.poi.common.usermodel.fonts.FontHeader.PanoseFamily
 
ANY - Enum constant in enum org.apache.poi.common.usermodel.fonts.FontHeader.PanoseLetterForm
 
ANY - Enum constant in enum org.apache.poi.common.usermodel.fonts.FontHeader.PanoseMidLine
 
ANY - Enum constant in enum org.apache.poi.common.usermodel.fonts.FontHeader.PanoseProportion
 
ANY - Enum constant in enum org.apache.poi.common.usermodel.fonts.FontHeader.PanoseSerif
 
ANY - Enum constant in enum org.apache.poi.common.usermodel.fonts.FontHeader.PanoseStroke
 
ANY - Enum constant in enum org.apache.poi.common.usermodel.fonts.FontHeader.PanoseWeight
 
ANY - Enum constant in enum org.apache.poi.common.usermodel.fonts.FontHeader.PanoseXHeight
 
ANY - Enum constant in enum org.apache.poi.ss.formula.DataValidationEvaluator.ValidationEnum
 
ANY - Static variable in class org.apache.poi.ss.usermodel.DataValidationConstraint.ValidationType
'Any value' type - value not restricted
APMHEADER_KEY - Static variable in class org.apache.poi.sl.image.ImageHeaderWMF
 
append(String) - Method in class org.apache.poi.xssf.usermodel.XSSFRichTextString
Append new text to this text run
append(String, XSSFFont) - Method in class org.apache.poi.xssf.usermodel.XSSFRichTextString
Append new text to this text run and apply the specify font to it
append(RecordBase) - Method in class org.apache.poi.hssf.record.aggregates.CustomViewSettingsRecordAggregate
 
appendBodyElementText(StringBuilder, IBodyElement) - Method in class org.apache.poi.xwpf.extractor.XWPFWordExtractor
 
appendContent(XSLFSheet) - Method in class org.apache.poi.xslf.usermodel.XSLFSheet
Append content to this sheet.
appendField(String, String, String) - Method in class org.apache.poi.xddf.usermodel.text.XDDFTextParagraph
Append a new text field.
appendFormat(Appendable, String) - Static method in class org.apache.poi.ss.formula.SheetNameFormatter
Convenience method for (SheetNameFormatter.format(String)) when a StringBuffer is already available.
appendFormat(Appendable, String, String) - Static method in class org.apache.poi.ss.formula.SheetNameFormatter
Convenience method for (SheetNameFormatter.format(String)) when a StringBuffer is already available.
appendLineBreak() - Method in class org.apache.poi.xddf.usermodel.text.XDDFTextParagraph
Append a line break.
appendParagraphText(StringBuilder, XWPFParagraph) - Method in class org.apache.poi.xwpf.extractor.XWPFWordExtractor
 
appendRegularRun(String) - Method in class org.apache.poi.xddf.usermodel.text.XDDFTextParagraph
Append a new run of text.
appendText(String, boolean) - Method in interface org.apache.poi.sl.usermodel.TextShape
Adds the supplied text onto the end of the TextParagraphs, creating a new RichTextRun for it to sit in.
appendText(String, boolean) - Method in class org.apache.poi.xslf.usermodel.XSLFTextShape
 
APPLES - Enum constant in enum org.apache.poi.xwpf.usermodel.Borders
Specifies an art border consisting of a repeated image of an apple
APPLICATION_WORKSPACE - Enum constant in enum org.apache.poi.xddf.usermodel.SystemColor
 
applies - Variable in class org.apache.poi.ss.format.CellFormatResult
This is true if no condition was given that applied to the value, or if the condition is satisfied.
applies(Object) - Method in class org.apache.poi.ss.format.CellFormatPart
Returns true if this format part applies to the given value.
appliesTo(Table, Cell) - Method in enum org.apache.poi.ss.usermodel.TableStyleType
A range is returned only for the part of the table matching this enum instance and containing the given cell.
appliesTo(Table, CellReference) - Method in enum org.apache.poi.ss.usermodel.TableStyleType
A range is returned only for the part of the table matching this enum instance and containing the given cell reference.
apply(Object) - Method in class org.apache.poi.ss.format.CellFormat
Returns the result of applying the format to the given value.
apply(Object) - Method in class org.apache.poi.ss.format.CellFormatPart
Apply this format part to the given value.
apply(JLabel, Object) - Method in class org.apache.poi.ss.format.CellFormat
Uses the result of applying this format to the value, setting the text and color of a label before returning the result.
apply(JLabel, Object) - Method in class org.apache.poi.ss.format.CellFormatPart
Apply this format part to the given value, applying the result to the given label.
apply(JLabel, Cell) - Method in class org.apache.poi.ss.format.CellFormat
Fetches the appropriate value from the cell, and uses the result, setting the text and color of a label before returning the result.
apply(RecordInputStream) - Method in interface org.apache.poi.hssf.record.HSSFRecordTypes.RecordConstructor
 
apply(Cell) - Method in class org.apache.poi.ss.format.CellFormat
Fetches the appropriate value from the cell, and returns the result of applying it to the appropriate format.
apply(LittleEndianInput, int, int) - Method in interface org.apache.poi.hssf.record.SubRecord.SubRecordTypes.RecordConstructor
read a sub-record from the supplied stream
applyBorders(Sheet) - Method in class org.apache.poi.ss.util.PropertyTemplate
Applies the drawn borders to a Sheet.
applyColorTransform(ColorStyle) - Static method in class org.apache.poi.sl.draw.DrawPaint
Convert color transformations in ColorStyle to a Color instance
applyDefaultCellStyleIfNecessary() - Method in class org.apache.poi.xssf.usermodel.XSSFCell
 
applyFont(int, int, short) - Method in class org.apache.poi.hssf.usermodel.HSSFRichTextString
Applies a font to the specified characters of a string.
applyFont(int, int, short) - Method in interface org.apache.poi.ss.usermodel.RichTextString
Applies a font to the specified characters of a string.
applyFont(int, int, short) - Method in class org.apache.poi.xssf.usermodel.XSSFRichTextString
Applies a font to the specified characters of a string.
applyFont(int, int, Font) - Method in class org.apache.poi.hssf.usermodel.HSSFRichTextString
Applies a font to the specified characters of a string.
applyFont(int, int, Font) - Method in interface org.apache.poi.ss.usermodel.RichTextString
Applies a font to the specified characters of a string.
applyFont(int, int, Font) - Method in class org.apache.poi.xssf.usermodel.XSSFRichTextString
Applies a font to the specified characters of a string.
applyFont(short) - Method in class org.apache.poi.hssf.usermodel.HSSFRichTextString
Applies the specified font to the entire string.
applyFont(short) - Method in interface org.apache.poi.ss.usermodel.RichTextString
Applies the specified font to the entire string.
applyFont(short) - Method in class org.apache.poi.xssf.usermodel.XSSFRichTextString
Applies the specified font to the entire string.
applyFont(Font) - Method in class org.apache.poi.hssf.usermodel.HSSFRichTextString
Sets the font of the entire string.
applyFont(Font) - Method in interface org.apache.poi.ss.usermodel.RichTextString
Sets the font of the entire string.
applyFont(Font) - Method in class org.apache.poi.xssf.usermodel.XSSFRichTextString
Sets the font of the entire string.
applyPaint(SimpleShape<?, ?>) - Method in class org.apache.poi.sl.draw.SLGraphics
 
applyR1C1Reference(CellReference, String) - Static method in class org.apache.poi.ss.formula.OperationEvaluationContext
 
applyStroke(SimpleShape<?, ?>) - Method in class org.apache.poi.sl.draw.SLGraphics
 
applyTransform(Graphics2D) - Method in interface org.apache.poi.sl.draw.Drawable
Apply 2-D transforms before drawing this shape.
applyTransform(Graphics2D) - Method in class org.apache.poi.sl.draw.DrawNothing
Apply 2-D transforms before drawing this shape.
applyTransform(Graphics2D) - Method in class org.apache.poi.sl.draw.DrawShape
Apply 2-D transforms before drawing this shape.
applyTransform(Graphics2D) - Method in class org.apache.poi.sl.draw.DrawSheet
 
applyTransform(Graphics2D) - Method in class org.apache.poi.sl.draw.DrawTableShape
 
applyTransform(Graphics2D) - Method in class org.apache.poi.sl.draw.DrawTextFragment
 
applyTransform(Graphics2D) - Method in class org.apache.poi.sl.draw.DrawTextParagraph
 
AppWorkspace - Enum constant in enum org.apache.poi.sl.usermodel.PresetColor
The application workspace is the area in a multiple-document view that is not being occupied by documents.
Aqua - Enum constant in enum org.apache.poi.sl.usermodel.PresetColor
 
AQUA - Enum constant in enum org.apache.poi.hssf.util.HSSFColor.HSSFColorPredefined
 
AQUA - Enum constant in enum org.apache.poi.ss.usermodel.IndexedColors
 
AQUA - Enum constant in enum org.apache.poi.xddf.usermodel.PresetColor
 
Aquamarine - Enum constant in enum org.apache.poi.sl.usermodel.PresetColor
 
AQUAMARINE - Enum constant in enum org.apache.poi.xddf.usermodel.PresetColor
 
AR - Enum constant in enum org.apache.poi.util.LocaleID
 
AR_145 - Enum constant in enum org.apache.poi.util.LocaleID
 
AR_AE - Enum constant in enum org.apache.poi.util.LocaleID
 
AR_BH - Enum constant in enum org.apache.poi.util.LocaleID
 
AR_DZ - Enum constant in enum org.apache.poi.util.LocaleID
 
AR_EG - Enum constant in enum org.apache.poi.util.LocaleID
 
AR_IQ - Enum constant in enum org.apache.poi.util.LocaleID
 
AR_JO - Enum constant in enum org.apache.poi.util.LocaleID
 
AR_KW - Enum constant in enum org.apache.poi.util.LocaleID
 
AR_LB - Enum constant in enum org.apache.poi.util.LocaleID
 
AR_LY - Enum constant in enum org.apache.poi.util.LocaleID
 
AR_MA - Enum constant in enum org.apache.poi.util.LocaleID
 
AR_OM - Enum constant in enum org.apache.poi.util.LocaleID
 
AR_PLOC_SA - Enum constant in enum org.apache.poi.util.LocaleID
 
AR_QA - Enum constant in enum org.apache.poi.util.LocaleID
 
AR_SA - Enum constant in enum org.apache.poi.util.LocaleID
 
AR_SY - Enum constant in enum org.apache.poi.util.LocaleID
 
AR_TN - Enum constant in enum org.apache.poi.util.LocaleID
 
AR_YE - Enum constant in enum org.apache.poi.util.LocaleID
 
ARABIC - Enum constant in enum org.apache.poi.common.usermodel.fonts.FontCharset
Specifies the Arabic character set.
ARABIC - Enum constant in enum org.apache.poi.ss.usermodel.FontCharset
Deprecated.
 
ARABIC_1_MINUS - Enum constant in enum org.apache.poi.xddf.usermodel.text.AutonumberScheme
 
ARABIC_2_MINUS - Enum constant in enum org.apache.poi.xddf.usermodel.text.AutonumberScheme
 
ARABIC_DOUBLE_BYTE_PERIOD - Enum constant in enum org.apache.poi.xddf.usermodel.text.AutonumberScheme
 
ARABIC_DOUBLE_BYTE_PLAIN - Enum constant in enum org.apache.poi.xddf.usermodel.text.AutonumberScheme
 
ARABIC_PARENT_BOTH - Enum constant in enum org.apache.poi.xssf.usermodel.ListAutoNumber
(1), (2), (3), ...
ARABIC_PARENT_R - Enum constant in enum org.apache.poi.xssf.usermodel.ListAutoNumber
1), 2), 3), ...
ARABIC_PARENTHESES_BOTH - Enum constant in enum org.apache.poi.xddf.usermodel.text.AutonumberScheme
 
ARABIC_PARENTHESIS_RIGHT - Enum constant in enum org.apache.poi.xddf.usermodel.text.AutonumberScheme
 
ARABIC_PERIOD - Enum constant in enum org.apache.poi.xddf.usermodel.text.AutonumberScheme
 
ARABIC_PERIOD - Enum constant in enum org.apache.poi.xssf.usermodel.ListAutoNumber
1., 2., 3., ...
ARABIC_PLAIN - Enum constant in enum org.apache.poi.xddf.usermodel.text.AutonumberScheme
 
ARABIC_PLAIN - Enum constant in enum org.apache.poi.xssf.usermodel.ListAutoNumber
1, 2, 3, ...
arabic1Minus - Enum constant in enum org.apache.poi.sl.usermodel.AutoNumberingScheme
Bidi Arabic 1 (AraAlpha) with ANSI minus symbol.
arabic2Minus - Enum constant in enum org.apache.poi.sl.usermodel.AutoNumberingScheme
Bidi Arabic 2 (AraAbjad) with ANSI minus symbol.
arabicDbPeriod - Enum constant in enum org.apache.poi.sl.usermodel.AutoNumberingScheme
Double-byte Arabic numbers with double-byte period.
arabicDbPlain - Enum constant in enum org.apache.poi.sl.usermodel.AutoNumberingScheme
Double-byte Arabic numbers.
arabicParenBoth - Enum constant in enum org.apache.poi.sl.usermodel.AutoNumberingScheme
Arabic numeral enclosed in parentheses.
arabicParenRight - Enum constant in enum org.apache.poi.sl.usermodel.AutoNumberingScheme
Arabic numeral followed by a closing parenthesis.
arabicPeriod - Enum constant in enum org.apache.poi.sl.usermodel.AutoNumberingScheme
Arabic numeral followed by a period.
arabicPlain - Enum constant in enum org.apache.poi.sl.usermodel.AutoNumberingScheme
Arabic numeral.
Arc - Static variable in interface org.apache.poi.hssf.usermodel.HSSFShapeTypes
 
ARC - Enum constant in enum org.apache.poi.sl.usermodel.ShapeType
 
ARC - Enum constant in enum org.apache.poi.xddf.usermodel.PresetGeometry
 
ARC - Static variable in class org.apache.poi.ss.usermodel.ShapeTypes
 
ARC_RULE - Enum constant in enum org.apache.poi.ddf.EscherRecordTypes
 
ARCHED_SCALLOPS - Enum constant in enum org.apache.poi.xwpf.usermodel.Borders
Specifies an art border consisting of a repeated image of a shell pattern
ArcTo - Class in org.apache.poi.xdgf.usermodel.section.geometry
 
ArcTo(RowType) - Constructor for class org.apache.poi.xdgf.usermodel.section.geometry.ArcTo
 
ArcToCommand - Class in org.apache.poi.sl.draw.geom
ArcTo command within a shape path in DrawingML: &lt;arcTo wR="wr" hR="hr" stAng="stAng" swAng="swAng"/&gt;
ArcToCommand() - Constructor for class org.apache.poi.sl.draw.geom.ArcToCommand
 
ArcToCommandIf - Interface in org.apache.poi.sl.draw.geom
 
Area - Enum constant in enum org.apache.poi.hssf.usermodel.HSSFChart.HSSFChartType
 
AREA - Enum constant in enum org.apache.poi.hssf.record.HSSFRecordTypes
 
AREA - Enum constant in enum org.apache.poi.xddf.usermodel.chart.ChartTypes
 
AREA_FORMAT - Enum constant in enum org.apache.poi.hssf.record.HSSFRecordTypes
 
Area2DPtgBase - Class in org.apache.poi.ss.formula.ptg
Common superclass of 2-D area refs
Area2DPtgBase(int, int, int, int, boolean, boolean, boolean, boolean) - Constructor for class org.apache.poi.ss.formula.ptg.Area2DPtgBase
 
Area2DPtgBase(Area2DPtgBase) - Constructor for class org.apache.poi.ss.formula.ptg.Area2DPtgBase
 
Area2DPtgBase(AreaReference) - Constructor for class org.apache.poi.ss.formula.ptg.Area2DPtgBase
 
Area2DPtgBase(LittleEndianInput) - Constructor for class org.apache.poi.ss.formula.ptg.Area2DPtgBase
 
AREA3D - Enum constant in enum org.apache.poi.xddf.usermodel.chart.ChartTypes
 
Area3DPtg - Class in org.apache.poi.ss.formula.ptg
Area 3D Ptg - 3D reference (Sheet + Area)
Area3DPtg(int, int, int, int, boolean, boolean, boolean, boolean, int) - Constructor for class org.apache.poi.ss.formula.ptg.Area3DPtg
 
Area3DPtg(String, int) - Constructor for class org.apache.poi.ss.formula.ptg.Area3DPtg
 
Area3DPtg(Area3DPtg) - Constructor for class org.apache.poi.ss.formula.ptg.Area3DPtg
 
Area3DPtg(AreaReference, int) - Constructor for class org.apache.poi.ss.formula.ptg.Area3DPtg
 
Area3DPtg(LittleEndianInput) - Constructor for class org.apache.poi.ss.formula.ptg.Area3DPtg
 
Area3DPxg - Class in org.apache.poi.ss.formula.ptg
XSSF Area 3D Reference (Sheet + Area)
Area3DPxg(int, SheetIdentifier, String) - Constructor for class org.apache.poi.ss.formula.ptg.Area3DPxg
 
Area3DPxg(int, SheetIdentifier, AreaReference) - Constructor for class org.apache.poi.ss.formula.ptg.Area3DPxg
 
Area3DPxg(Area3DPxg) - Constructor for class org.apache.poi.ss.formula.ptg.Area3DPxg
 
Area3DPxg(SheetIdentifier, String) - Constructor for class org.apache.poi.ss.formula.ptg.Area3DPxg
 
Area3DPxg(SheetIdentifier, AreaReference) - Constructor for class org.apache.poi.ss.formula.ptg.Area3DPxg
 
AreaErrPtg - Class in org.apache.poi.ss.formula.ptg
AreaErr - handles deleted cell area references.
AreaErrPtg() - Constructor for class org.apache.poi.ss.formula.ptg.AreaErrPtg
 
AreaErrPtg(LittleEndianInput) - Constructor for class org.apache.poi.ss.formula.ptg.AreaErrPtg
 
AreaEval - Interface in org.apache.poi.ss.formula.eval
Evaluation of 2D (Row+Column) and 3D (Sheet+Row+Column) areas
AreaEvalBase - Class in org.apache.poi.ss.formula.eval
 
AreaEvalBase(int, int, int, int) - Constructor for class org.apache.poi.ss.formula.eval.AreaEvalBase
 
AreaEvalBase(AreaI) - Constructor for class org.apache.poi.ss.formula.eval.AreaEvalBase
 
AreaEvalBase(AreaI, SheetRange) - Constructor for class org.apache.poi.ss.formula.eval.AreaEvalBase
 
AreaEvalBase(SheetRange, int, int, int, int) - Constructor for class org.apache.poi.ss.formula.eval.AreaEvalBase
 
AreaFormatRecord - Class in org.apache.poi.hssf.record.chart
The area format record is used to define the colours and patterns for an area.
AreaFormatRecord() - Constructor for class org.apache.poi.hssf.record.chart.AreaFormatRecord
 
AreaFormatRecord(AreaFormatRecord) - Constructor for class org.apache.poi.hssf.record.chart.AreaFormatRecord
 
AreaFormatRecord(RecordInputStream) - Constructor for class org.apache.poi.hssf.record.chart.AreaFormatRecord
 
AreaI - Interface in org.apache.poi.ss.formula.ptg
Common interface for AreaPtg and Area3DPtg, and their child classes.
AreaI.OffsetArea - Class in org.apache.poi.ss.formula.ptg
 
areAllRowsFlushed() - Method in class org.apache.poi.xssf.streaming.SXSSFSheet
Are all rows flushed to disk?
AreaNPtg - Class in org.apache.poi.ss.formula.ptg
Specifies a rectangular area of cells A1:A4 for instance.
AreaNPtg(AreaNPtg) - Constructor for class org.apache.poi.ss.formula.ptg.AreaNPtg
 
AreaNPtg(LittleEndianInput) - Constructor for class org.apache.poi.ss.formula.ptg.AreaNPtg
 
AreaPtg - Class in org.apache.poi.ss.formula.ptg
Specifies a rectangular area of cells A1:A4 for instance.
AreaPtg(int, int, int, int, boolean, boolean, boolean, boolean) - Constructor for class org.apache.poi.ss.formula.ptg.AreaPtg
 
AreaPtg(AreaPtg) - Constructor for class org.apache.poi.ss.formula.ptg.AreaPtg
 
AreaPtg(AreaReference) - Constructor for class org.apache.poi.ss.formula.ptg.AreaPtg
 
AreaPtg(LittleEndianInput) - Constructor for class org.apache.poi.ss.formula.ptg.AreaPtg
 
AreaPtgBase - Class in org.apache.poi.ss.formula.ptg
Specifies a rectangular area of cells A1:A4 for instance.
AreaPtgBase() - Constructor for class org.apache.poi.ss.formula.ptg.AreaPtgBase
 
AreaPtgBase(int, int, int, int, boolean, boolean, boolean, boolean) - Constructor for class org.apache.poi.ss.formula.ptg.AreaPtgBase
 
AreaPtgBase(AreaPtgBase) - Constructor for class org.apache.poi.ss.formula.ptg.AreaPtgBase
 
AreaPtgBase(AreaReference) - Constructor for class org.apache.poi.ss.formula.ptg.AreaPtgBase
 
AreaRecord - Class in org.apache.poi.hssf.record.chart
The area record is used to define a area chart.
AreaRecord() - Constructor for class org.apache.poi.hssf.record.chart.AreaRecord
 
AreaRecord(AreaRecord) - Constructor for class org.apache.poi.hssf.record.chart.AreaRecord
 
AreaRecord(RecordInputStream) - Constructor for class org.apache.poi.hssf.record.chart.AreaRecord
 
AreaReference - Class in org.apache.poi.ss.util
 
AreaReference(String, SpreadsheetVersion) - Constructor for class org.apache.poi.ss.util.AreaReference
Create an area ref from a string representation.
AreaReference(CellReference, CellReference, SpreadsheetVersion) - Constructor for class org.apache.poi.ss.util.AreaReference
Creates an area ref from a pair of Cell References.
Areas - Class in org.apache.poi.ss.formula.functions
Returns the number of areas in a reference.
Areas() - Constructor for class org.apache.poi.ss.formula.functions.Areas
 
areDirectoriesIdentical(DirectoryEntry, DirectoryEntry) - Static method in class org.apache.poi.poifs.filesystem.EntryUtils
Checks to see if the two Directories hold the same contents.
areDocumentsIdentical(DocumentEntry, DocumentEntry) - Static method in class org.apache.poi.poifs.filesystem.EntryUtils
Compares two DocumentEntry instances of a POI file system.
areFieldsStripped() - Method in class org.apache.poi.xssf.usermodel.extensions.XSSFHeaderFooter
Are fields currently being stripped from the text that this XSSFHeaderFooter returns? Default is false, but can be changed
ARN - Enum constant in enum org.apache.poi.util.LocaleID
 
ARN_CL - Enum constant in enum org.apache.poi.util.LocaleID
 
Array - Class in org.apache.poi.hpsf
 
Array() - Constructor for class org.apache.poi.hpsf.Array
 
ARRAY - Enum constant in enum org.apache.poi.ddf.EscherPropertyTypesHolder
 
ARRAY - Enum constant in enum org.apache.poi.hssf.record.HSSFRecordTypes
 
ARRAY - Enum constant in enum org.apache.poi.ss.formula.FormulaType
An Array formula ("{=SUM(A1:E1*{1,2,3,4,5}}") https://support.office.com/en-us/article/Guidelines-and-examples-of-array-formulas-7D94A64E-3FF3-4686-9372-ECFD5CAA57C7
ArrayFunction - Interface in org.apache.poi.ss.formula.functions
Common Interface for any excel built-in function that has implemented array formula functionality.
ArrayMode - Interface in org.apache.poi.ss.formula.functions
Interface for those functions that evaluate arguments in array mode depending on context.
arrayMoveWithin(Object[], int, int, int) - Static method in class org.apache.poi.util.ArrayUtil
Moves a number of entries in an array to another point in the array, shifting those inbetween as required.
ArrayPtg - Class in org.apache.poi.ss.formula.ptg
ArrayPtg - handles arrays The ArrayPtg is a little weird, the size of the Ptg when parsing initially only includes the Ptg sid and the reserved bytes.
ArrayPtg(Object[][]) - Constructor for class org.apache.poi.ss.formula.ptg.ArrayPtg
 
ArrayPtg(ArrayPtg) - Constructor for class org.apache.poi.ss.formula.ptg.ArrayPtg
 
ArrayRecord - Class in org.apache.poi.hssf.record
ARRAY (0x0221)
ArrayRecord(ArrayRecord) - Constructor for class org.apache.poi.hssf.record.ArrayRecord
 
ArrayRecord(RecordInputStream) - Constructor for class org.apache.poi.hssf.record.ArrayRecord
 
ArrayRecord(Formula, CellRangeAddress8Bit) - Constructor for class org.apache.poi.hssf.record.ArrayRecord
 
ArrayUtil - Class in org.apache.poi.util
Utility classes for dealing with arrays.
Arrow - Static variable in interface org.apache.poi.hssf.usermodel.HSSFShapeTypes
 
ARROW - Enum constant in enum org.apache.poi.sl.usermodel.LineDecoration.DecorationShape
 
ARROW - Enum constant in enum org.apache.poi.xddf.usermodel.LineEndType
 
AS - Enum constant in enum org.apache.poi.util.LocaleID
 
AS_DISPLAYED - Enum constant in enum org.apache.poi.ss.usermodel.PrintCellComments
Print cell comments as displayed.
AS_IN - Enum constant in enum org.apache.poi.util.LocaleID
 
ascii - Enum constant in enum org.apache.poi.xwpf.usermodel.XWPFRun.FontCharRange
 
asFormulaString() - Method in class org.apache.poi.ss.formula.SheetIdentifier
 
asFormulaString(StringBuilder) - Method in class org.apache.poi.ss.formula.SheetIdentifier
 
asFormulaString(StringBuilder) - Method in class org.apache.poi.ss.formula.SheetRangeIdentifier
 
ASIN - Static variable in class org.apache.poi.ss.formula.functions.NumericFunction
 
ASINH - Static variable in class org.apache.poi.ss.formula.functions.NumericFunction
 
associateShapeToObjRecord(EscherRecord, Record) - Method in class org.apache.poi.hssf.record.EscherAggregate
Associates an escher record to an OBJ record or a TXO record.
AT_END - Enum constant in enum org.apache.poi.ss.usermodel.PrintCellComments
Print cell comments at end of document.
AT_LEAST - Enum constant in enum org.apache.poi.xwpf.usermodel.LineSpacingRule
Specifies that the height of the line shall be at least the value specified, but may be expanded to fit its content as needed.
AT_LEAST - Enum constant in enum org.apache.poi.xwpf.usermodel.TableRowHeightRule
 
at2 - Enum constant in enum org.apache.poi.sl.draw.geom.GuideIf.Op
 
ATAN - Static variable in class org.apache.poi.ss.formula.functions.NumericFunction
 
ATAN2 - Static variable in class org.apache.poi.ss.formula.functions.NumericFunction
 
ATANH - Static variable in class org.apache.poi.ss.formula.functions.NumericFunction
 
attach(String, XWPFRun) - Method in class org.apache.poi.xwpf.usermodel.XWPFChart
Attach this chart known by its relation id to the given text run.
attributeToDegrees(int) - Static method in class org.apache.poi.xddf.usermodel.Angles
 
AttrPtg - Class in org.apache.poi.ss.formula.ptg
"Special Attributes"
AttrPtg(LittleEndianInput) - Constructor for class org.apache.poi.ss.formula.ptg.AttrPtg
 
AttrPtg.SpaceType - Class in org.apache.poi.ss.formula.ptg
 
AUTO - Enum constant in enum org.apache.poi.sl.usermodel.TextParagraph.FontAlign
 
AUTO - Enum constant in enum org.apache.poi.xddf.usermodel.BlackWhiteMode
 
AUTO - Enum constant in enum org.apache.poi.xssf.usermodel.TextFontAlign
Automatic alignment
AUTO - Enum constant in enum org.apache.poi.xwpf.usermodel.LineSpacingRule
Specifies that the line spacing of the parent object shall be automatically determined by the size of its contents, with no predetermined minimum or maximum size.
AUTO - Enum constant in enum org.apache.poi.xwpf.usermodel.TableRowHeightRule
 
AUTO - Enum constant in enum org.apache.poi.xwpf.usermodel.TableWidthType
 
AUTO - Enum constant in enum org.apache.poi.xwpf.usermodel.TextAlignment
Specifies that all text in the parent object shall be aligned automatically when displayed.
AUTO_FILTER_INFO - Enum constant in enum org.apache.poi.hssf.record.HSSFRecordTypes
 
AUTO_LOAD_BIT - Static variable in class org.apache.poi.hssf.record.FtPioGrbitSubRecord
A bit that specifies whether the OLE server for the object is called to load the object's data automatically when the parent workbook is opened.
AUTO_PICT_BIT - Static variable in class org.apache.poi.hssf.record.FtPioGrbitSubRecord
A bit that specifies whether the picture's aspect ratio is preserved when rendered in different views (Normal view, Page Break Preview view, Page Layout view and printing).
AUTO_ZERO - Enum constant in enum org.apache.poi.xddf.usermodel.chart.AxisCrosses
 
AutoFilter - Interface in org.apache.poi.ss.usermodel
Represents autofiltering for the specified worksheet.
AutoFilterInfoRecord - Class in org.apache.poi.hssf.record
The AutoFilterInfo record specifies the number of columns that have AutoFilter enabled and indicates the beginning of the collection of AutoFilter records.
AutoFilterInfoRecord() - Constructor for class org.apache.poi.hssf.record.AutoFilterInfoRecord
 
AutoFilterInfoRecord(AutoFilterInfoRecord) - Constructor for class org.apache.poi.hssf.record.AutoFilterInfoRecord
 
AutoFilterInfoRecord(RecordInputStream) - Constructor for class org.apache.poi.hssf.record.AutoFilterInfoRecord
 
AUTOMATIC - Enum constant in enum org.apache.poi.hssf.util.HSSFColor.HSSFColorPredefined
Special Default/Normal/Automatic color.
AUTOMATIC - Enum constant in enum org.apache.poi.ss.usermodel.IndexedColors
 
AUTOMATIC - Enum constant in enum org.apache.poi.xddf.usermodel.text.FontAlignment
 
AUTOMATIC - Static variable in class org.apache.poi.hssf.record.CalcModeRecord
automatically calculate formulas (1)
AUTOMATIC_EXCEPT_TABLES - Static variable in class org.apache.poi.hssf.record.CalcModeRecord
automatically calculate formulas except for tables (-1)
autoNbrIdx - Variable in class org.apache.poi.sl.draw.DrawTextParagraph
 
AutoNumberingScheme - Enum in org.apache.poi.sl.usermodel
 
AutonumberScheme - Enum in org.apache.poi.xddf.usermodel.text
 
AutoShape<S extends Shape<S,P>,P extends TextParagraph<S,P,? extends TextRun>> - Interface in org.apache.poi.sl.usermodel
 
autoSizeColumn(int) - Method in class org.apache.poi.hssf.usermodel.HSSFSheet
Adjusts the column width to fit the contents.
autoSizeColumn(int) - Method in interface org.apache.poi.ss.usermodel.Sheet
Adjusts the column width to fit the contents.
autoSizeColumn(int) - Method in class org.apache.poi.xssf.streaming.SXSSFSheet
Adjusts the column width to fit the contents.
autoSizeColumn(int) - Method in class org.apache.poi.xssf.usermodel.XSSFSheet
Adjusts the column width to fit the contents.
autoSizeColumn(int, boolean) - Method in class org.apache.poi.hssf.usermodel.HSSFSheet
Adjusts the column width to fit the contents.
autoSizeColumn(int, boolean) - Method in interface org.apache.poi.ss.usermodel.Sheet
Adjusts the column width to fit the contents.
autoSizeColumn(int, boolean) - Method in class org.apache.poi.xssf.streaming.SXSSFSheet
Adjusts the column width to fit the contents.
autoSizeColumn(int, boolean) - Method in class org.apache.poi.xssf.usermodel.XSSFSheet
Adjusts the column width to fit the contents.
available() - Method in interface org.apache.poi.hssf.record.BiffHeaderInput
 
available() - Method in class org.apache.poi.hssf.record.cont.ContinuableRecordInput
 
available() - Method in class org.apache.poi.hssf.record.crypto.Biff8DecryptingStream
 
available() - Method in class org.apache.poi.hssf.record.RecordInputStream
 
available() - Method in class org.apache.poi.poifs.crypt.ChunkedCipherInputStream
 
available() - Method in class org.apache.poi.poifs.filesystem.DocumentInputStream
 
available() - Method in interface org.apache.poi.util.LittleEndianInput
 
available() - Method in class org.apache.poi.util.LittleEndianInputStream
 
available() - Method in class org.apache.poi.util.RLEDecompressingInputStream
 
AVEDEV - Static variable in class org.apache.poi.ss.formula.functions.AggregateFunction
 
AVERAGE - Enum constant in enum org.apache.poi.ss.usermodel.DataConsolidateFunction
 
AVERAGE - Static variable in class org.apache.poi.ss.formula.functions.AggregateFunction
 
AVERAGEA - Static variable in class org.apache.poi.ss.formula.functions.AggregateFunction
 
AverageIf - Class in org.apache.poi.ss.formula.functions
Handler for singular AverageIf which has different operand handling than the generic AverageIfs version.
AverageIf() - Constructor for class org.apache.poi.ss.formula.functions.AverageIf
 
Averageifs - Class in org.apache.poi.ss.formula.functions
Implementation for the Excel function AVERAGEIFS
Averageifs() - Constructor for class org.apache.poi.ss.formula.functions.Averageifs
 
aw - Variable in class org.apache.poi.util.GenericRecordJsonWriter
 
axes - Variable in class org.apache.poi.xddf.usermodel.chart.XDDFChart
 
AXIS - Enum constant in enum org.apache.poi.hssf.record.HSSFRecordTypes
 
AXIS_LINE_FORMAT - Enum constant in enum org.apache.poi.hssf.record.HSSFRecordTypes
 
AXIS_OPTIONS - Enum constant in enum org.apache.poi.hssf.record.HSSFRecordTypes
 
AXIS_PARENT - Enum constant in enum org.apache.poi.hssf.record.HSSFRecordTypes
 
AXIS_TYPE_AXIS_LINE - Static variable in class org.apache.poi.hssf.record.chart.AxisLineFormatRecord
 
AXIS_TYPE_CATEGORY_OR_X_AXIS - Static variable in class org.apache.poi.hssf.record.chart.AxisRecord
 
AXIS_TYPE_MAIN - Static variable in class org.apache.poi.hssf.record.chart.AxisParentRecord
 
AXIS_TYPE_MAJOR_GRID_LINE - Static variable in class org.apache.poi.hssf.record.chart.AxisLineFormatRecord
 
AXIS_TYPE_MINOR_GRID_LINE - Static variable in class org.apache.poi.hssf.record.chart.AxisLineFormatRecord
 
AXIS_TYPE_SECONDARY - Static variable in class org.apache.poi.hssf.record.chart.AxisParentRecord
 
AXIS_TYPE_SERIES_AXIS - Static variable in class org.apache.poi.hssf.record.chart.AxisRecord
 
AXIS_TYPE_VALUE_AXIS - Static variable in class org.apache.poi.hssf.record.chart.AxisRecord
 
AXIS_TYPE_WALLS_OR_FLOOR - Static variable in class org.apache.poi.hssf.record.chart.AxisLineFormatRecord
 
AXIS_USED - Enum constant in enum org.apache.poi.hssf.record.HSSFRecordTypes
 
AxisCrossBetween - Enum in org.apache.poi.xddf.usermodel.chart
 
AxisCrosses - Enum in org.apache.poi.xddf.usermodel.chart
 
AxisLabelAlignment - Enum in org.apache.poi.xddf.usermodel.chart
 
AxisLineFormatRecord - Class in org.apache.poi.hssf.record.chart
The axis line format record defines the axis type details.
AxisLineFormatRecord() - Constructor for class org.apache.poi.hssf.record.chart.AxisLineFormatRecord
 
AxisLineFormatRecord(AxisLineFormatRecord) - Constructor for class org.apache.poi.hssf.record.chart.AxisLineFormatRecord
 
AxisLineFormatRecord(RecordInputStream) - Constructor for class org.apache.poi.hssf.record.chart.AxisLineFormatRecord
 
AxisOptionsRecord - Class in org.apache.poi.hssf.record.chart
The axis options record provides unit information and other various tidbits about the axis.
AxisOptionsRecord() - Constructor for class org.apache.poi.hssf.record.chart.AxisOptionsRecord
 
AxisOptionsRecord(AxisOptionsRecord) - Constructor for class org.apache.poi.hssf.record.chart.AxisOptionsRecord
 
AxisOptionsRecord(RecordInputStream) - Constructor for class org.apache.poi.hssf.record.chart.AxisOptionsRecord
 
AxisOrientation - Enum in org.apache.poi.xddf.usermodel.chart
 
AxisParentRecord - Class in org.apache.poi.hssf.record.chart
The axis size and location
AxisParentRecord() - Constructor for class org.apache.poi.hssf.record.chart.AxisParentRecord
 
AxisParentRecord(AxisParentRecord) - Constructor for class org.apache.poi.hssf.record.chart.AxisParentRecord
 
AxisParentRecord(RecordInputStream) - Constructor for class org.apache.poi.hssf.record.chart.AxisParentRecord
 
AxisPosition - Enum in org.apache.poi.xddf.usermodel.chart
 
AxisRecord - Class in org.apache.poi.hssf.record.chart
The axis record defines the type of an axis.
AxisRecord() - Constructor for class org.apache.poi.hssf.record.chart.AxisRecord
 
AxisRecord(AxisRecord) - Constructor for class org.apache.poi.hssf.record.chart.AxisRecord
 
AxisRecord(RecordInputStream) - Constructor for class org.apache.poi.hssf.record.chart.AxisRecord
 
AxisTickLabelPosition - Enum in org.apache.poi.xddf.usermodel.chart
 
AxisTickMark - Enum in org.apache.poi.xddf.usermodel.chart
 
AxisUsedRecord - Class in org.apache.poi.hssf.record.chart
The number of axes used on a chart.
AxisUsedRecord() - Constructor for class org.apache.poi.hssf.record.chart.AxisUsedRecord
 
AxisUsedRecord(AxisUsedRecord) - Constructor for class org.apache.poi.hssf.record.chart.AxisUsedRecord
 
AxisUsedRecord(RecordInputStream) - Constructor for class org.apache.poi.hssf.record.chart.AxisUsedRecord
 
AZ - Enum constant in enum org.apache.poi.util.LocaleID
 
AZ_CYRL - Enum constant in enum org.apache.poi.util.LocaleID
 
AZ_CYRL_AZ - Enum constant in enum org.apache.poi.util.LocaleID
 
AZ_LATN - Enum constant in enum org.apache.poi.util.LocaleID
 
AZ_LATN_AZ - Enum constant in enum org.apache.poi.util.LocaleID
 
Azure - Enum constant in enum org.apache.poi.sl.usermodel.PresetColor
 
AZURE - Enum constant in enum org.apache.poi.xddf.usermodel.PresetColor
 
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z _ 
All Classes and Interfaces|All Packages|Constant Field Values|Serialized Form