Index
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
andEscherTertiaryOptRecord
- 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 aColor
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:
<arcTo wR="wr" hR="hr" stAng="stAng" swAng="swAng"/>
- 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
All Classes and Interfaces|All Packages|Constant Field Values|Serialized Form