- A1 - Static variable in class org.apache.poi.ss.util.CellAddress
-
A constant for references to the first cell in a sheet.
- 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_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_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_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, POIFSFileSystem) - Method in class org.apache.poi.hssf.eventusermodel.HSSFEventFactory
-
Processes a file into essentially record events.
- abortableProcessWorkbookEvents(HSSFRequest, DirectoryNode) - Method in class org.apache.poi.hssf.eventusermodel.HSSFEventFactory
-
Processes a file into essentially record events.
- ABS - Static variable in class org.apache.poi.ss.formula.functions.NumericFunction
-
- 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.
- 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.
- 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
-
- 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
-
- ACCENT_BORDER_CALLOUT_1 - Static variable in class org.apache.poi.ss.usermodel.ShapeTypes
-
- ACCENT_BORDER_CALLOUT_2 - Static variable in class org.apache.poi.ss.usermodel.ShapeTypes
-
- ACCENT_BORDER_CALLOUT_3 - Static variable in class org.apache.poi.ss.usermodel.ShapeTypes
-
- ACCENT_CALLOUT_1 - Static variable in class org.apache.poi.ss.usermodel.ShapeTypes
-
- ACCENT_CALLOUT_2 - Static variable in class org.apache.poi.ss.usermodel.ShapeTypes
-
- ACCENT_CALLOUT_3 - Static variable in class org.apache.poi.ss.usermodel.ShapeTypes
-
- 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
-
- 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 interface org.apache.poi.sl.usermodel.SlideShowProvider
-
- accepts(FileMagic) - Method in interface org.apache.poi.ss.usermodel.WorkbookProvider
-
- 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 - Static variable in class org.apache.poi.ss.usermodel.ShapeTypes
-
- ACTION_BUTTON_BEGINNING - Static variable in class org.apache.poi.ss.usermodel.ShapeTypes
-
- ACTION_BUTTON_BLANK - Static variable in class org.apache.poi.ss.usermodel.ShapeTypes
-
- ACTION_BUTTON_DOCUMENT - Static variable in class org.apache.poi.ss.usermodel.ShapeTypes
-
- ACTION_BUTTON_END - Static variable in class org.apache.poi.ss.usermodel.ShapeTypes
-
- ACTION_BUTTON_FORWARD_NEXT - Static variable in class org.apache.poi.ss.usermodel.ShapeTypes
-
- ACTION_BUTTON_HELP - Static variable in class org.apache.poi.ss.usermodel.ShapeTypes
-
- ACTION_BUTTON_HOME - Static variable in class org.apache.poi.ss.usermodel.ShapeTypes
-
- ACTION_BUTTON_INFORMATION - Static variable in class org.apache.poi.ss.usermodel.ShapeTypes
-
- ACTION_BUTTON_MOVIE - Static variable in class org.apache.poi.ss.usermodel.ShapeTypes
-
- ACTION_BUTTON_RETURN - Static variable in class org.apache.poi.ss.usermodel.ShapeTypes
-
- 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_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
-
- 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(int, int) - Method in class org.apache.poi.util.IntList
-
add the specified value at the specified index
- add(int) - Method in class org.apache.poi.util.IntList
-
Appends the specified element to the end of this list
- add(T) - Method in class org.apache.poi.util.IntMapper
-
Appends the specified element to the end of this list
- addAdjustGuide(AdjustValueIf) - Method in class org.apache.poi.sl.draw.geom.CustomGeometry
-
- addAdjustHandle(AdjustHandle) - Method in class org.apache.poi.sl.draw.geom.CustomGeometry
-
- 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.
- 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.
- 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(int, int, int) - Method in class org.apache.poi.hssf.record.PageBreakRecord
-
Adds the page break at the specified parameters
- addBSERecord(EscherBSERecord) - Method in class org.apache.poi.hssf.model.InternalWorkbook
-
- 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
-
- addChar(char, int) - Method in class org.apache.poi.hssf.usermodel.FontDetails
-
- addChars(char[], int[]) - Method in class org.apache.poi.hssf.usermodel.FontDetails
-
- 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
-
- 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
- addColor(byte, byte, byte) - Method in class org.apache.poi.hssf.usermodel.HSSFPalette
-
Adds a new color into an empty color slot.
- addCommand(PathCommand) - Method in class org.apache.poi.sl.draw.geom.Path
-
- addCommand(PathCommand) - Method in interface org.apache.poi.sl.draw.geom.PathIf
-
- 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(CellRangeAddress[], HSSFConditionalFormattingRule[]) - Method in class org.apache.poi.hssf.usermodel.HSSFSheetConditionalFormatting
-
Allows to add a new Conditional Formatting set to the sheet.
- addConditionalFormatting(CellRangeAddress[], ConditionalFormattingRule[]) - Method in class org.apache.poi.hssf.usermodel.HSSFSheetConditionalFormatting
-
- addConditionalFormatting(CellRangeAddress[], HSSFConditionalFormattingRule) - Method in class org.apache.poi.hssf.usermodel.HSSFSheetConditionalFormatting
-
- addConditionalFormatting(CellRangeAddress[], ConditionalFormattingRule) - Method in class org.apache.poi.hssf.usermodel.HSSFSheetConditionalFormatting
-
- addConditionalFormatting(CellRangeAddress[], HSSFConditionalFormattingRule, HSSFConditionalFormattingRule) - Method in class org.apache.poi.hssf.usermodel.HSSFSheetConditionalFormatting
-
- addConditionalFormatting(CellRangeAddress[], ConditionalFormattingRule, 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, ConditionalFormattingRule) - Method in interface org.apache.poi.ss.usermodel.SheetConditionalFormatting
-
Add a new Conditional Formatting consisting of two rules.
- addConditionalFormatting(CellRangeAddress[], ConditionalFormattingRule[]) - Method in interface org.apache.poi.ss.usermodel.SheetConditionalFormatting
-
Add a new Conditional Formatting set to the sheet.
- addConditionalFormatting(ConditionalFormatting) - Method in interface org.apache.poi.ss.usermodel.SheetConditionalFormatting
-
Adds a copy of a ConditionalFormatting object to the sheet
- addConnectionSite(ConnectionSiteIf) - Method in class org.apache.poi.sl.draw.geom.CustomGeometry
-
- 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
-
- 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
-
- addFont(InputStream) - Method in interface org.apache.poi.sl.usermodel.SlideShow
-
Add an EOT font to the slideshow.
- 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
-
- 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.
- 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.
- 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)
- 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).
- 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
- 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
- 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
- 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[], PictureData.PictureType) - Method in interface org.apache.poi.sl.usermodel.SlideShow
-
Adds a picture to the presentation.
- addPicture(InputStream, PictureData.PictureType) - Method in interface org.apache.poi.sl.usermodel.SlideShow
-
Adds a picture to the presentation.
- addPicture(File, PictureData.PictureType) - Method in interface org.apache.poi.sl.usermodel.SlideShow
-
Adds a picture to the presentation.
- addPicture(byte[], int) - Method in interface org.apache.poi.ss.usermodel.Workbook
-
Adds a picture to the workbook.
- 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(MergeCellsRecord[]) - Method in class org.apache.poi.hssf.record.aggregates.MergedCellsTable
-
- 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.
- addRef(int, int, int) - Method in class org.apache.poi.hssf.record.ExternSheetRecord
-
- addREFRecord(ExternSheetRecord.RefSubRecord) - Method in class org.apache.poi.hssf.record.ExternSheetRecord
-
adds REF struct (ExternSheetSubRecord)
- 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.
- 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(RowRecord) - Method in class org.apache.poi.hssf.model.InternalSheet
-
Adds a row record to the sheet
- 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.
- addSection(Section) - Method in class org.apache.poi.hpsf.PropertySet
-
Adds a section to this property set.
- 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(S) - Method in interface org.apache.poi.sl.usermodel.ShapeContainer
-
- 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.
- addSubRecord(int, SubRecord) - Method in class org.apache.poi.hssf.record.ObjRecord
-
- addSubRecord(SubRecord) - Method in class org.apache.poi.hssf.record.ObjRecord
-
- addTabStops(double, TabStop.TabStopType) - Method in interface org.apache.poi.sl.usermodel.TextParagraph
-
- addTailRecord(NoteRecord) - Method in class org.apache.poi.hssf.record.EscherAggregate
-
Add tail record to existing map
- 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.
- 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
- 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.
- 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
-
- 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
-
- 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
-
- 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(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
-
- AgileEncryptionVerifier(AgileEncryptionVerifier) - 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
-
- ALIGNMENT - Static variable in class org.apache.poi.ss.util.CellUtil
-
- allocateShapeId(EscherDgRecord, boolean) - Method in class org.apache.poi.ddf.EscherDggRecord
-
Allocates new shape id for the drawing group
- allocateShapeId(EscherDgRecord) - Method in class org.apache.poi.hssf.model.DrawingManager2
-
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.
- 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
- AnalysisToolPak - Class in org.apache.poi.ss.formula.atp
-
Analysis Toolpack Function Definitions
- 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
-
- AND - Static variable in class org.apache.poi.ss.formula.functions.BooleanFunction
-
- ANSI_CHARSET - Static variable in interface org.apache.poi.ss.usermodel.Font
-
ANSI character set
- 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(RecordBase) - Method in class org.apache.poi.hssf.record.aggregates.CustomViewSettingsRecordAggregate
-
- appendFormat(Appendable, String) - Static method in class org.apache.poi.ss.formula.SheetNameFormatter
-
- appendFormat(Appendable, String, String) - Static method in class org.apache.poi.ss.formula.SheetNameFormatter
-
- 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.
- applies(Object) - Method in class org.apache.poi.ss.format.CellFormatPart
-
Returns true if this format part applies to the given value.
- 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.
- 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(RecordInputStream) - Method in interface org.apache.poi.hssf.record.HSSFRecordTypes.RecordConstructor
-
- apply(LittleEndianInput, int, int) - Method in interface org.apache.poi.hssf.record.SubRecord.SubRecordTypes.RecordConstructor
-
read a sub-record from the supplied stream
- apply(Object) - Method in class org.apache.poi.ss.format.CellFormat
-
Returns the result of applying the format to the given value.
- 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(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, 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(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.CellFormatPart
-
Apply this format part to the given value, applying the result to the
given label.
- 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
-
- 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, Font) - Method in class org.apache.poi.hssf.usermodel.HSSFRichTextString
-
Applies a font to the specified characters of a string.
- applyFont(Font) - Method in class org.apache.poi.hssf.usermodel.HSSFRichTextString
-
Sets the font of the entire string.
- applyFont(short) - Method in class org.apache.poi.hssf.usermodel.HSSFRichTextString
-
Applies the specified font to the entire 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, Font) - Method in interface org.apache.poi.ss.usermodel.RichTextString
-
Applies a font to the specified characters of a string.
- applyFont(Font) - Method in interface org.apache.poi.ss.usermodel.RichTextString
-
Sets the font of the entire string.
- applyFont(short) - Method in interface org.apache.poi.ss.usermodel.RichTextString
-
Applies the specified font to 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
-
- Arc - Static variable in interface org.apache.poi.hssf.usermodel.HSSFShapeTypes
-
- ARC - Static variable in class org.apache.poi.ss.usermodel.ShapeTypes
-
- 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
-
- 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
-
- Area3DPtg - Class in org.apache.poi.ss.formula.ptg
-
Area 3D Ptg - 3D reference (Sheet + Area)
- 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(LittleEndianInput) - Constructor for class org.apache.poi.ss.formula.ptg.Area3DPtg
-
- Area3DPtg(int, int, int, int, boolean, boolean, boolean, boolean, int) - Constructor for class org.apache.poi.ss.formula.ptg.Area3DPtg
-
- Area3DPtg(AreaReference, int) - 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(Area3DPxg) - Constructor for class org.apache.poi.ss.formula.ptg.Area3DPxg
-
- 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(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(SheetRange, int, int, int, int) - Constructor for class org.apache.poi.ss.formula.eval.AreaEvalBase
-
- 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
-
- 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(RecordInputStream) - Constructor for class org.apache.poi.hssf.record.chart.AreaFormatRecord
-
- AreaFormatRecord(AreaFormatRecord) - 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
-
- 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(LittleEndianInput) - Constructor for class org.apache.poi.ss.formula.ptg.AreaPtg
-
- AreaPtg(AreaReference) - 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(AreaPtgBase) - Constructor for class org.apache.poi.ss.formula.ptg.AreaPtgBase
-
- AreaPtgBase(AreaReference) - 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
-
- AreaRecord - Class in org.apache.poi.hssf.record.chart
-
The area record is used to define an 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
-
- Array - Class in org.apache.poi.hpsf
-
- Array() - Constructor for class org.apache.poi.hpsf.Array
-
- 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(ArrayPtg) - Constructor for class org.apache.poi.ss.formula.ptg.ArrayPtg
-
- ArrayPtg(Object[][]) - 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
-
- asFormulaString(StringBuilder) - Method in class org.apache.poi.ss.formula.SheetIdentifier
-
- asFormulaString() - 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.
- 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
-
- 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_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).
- 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 - 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
-
- 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, boolean) - 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, boolean) - Method in interface org.apache.poi.ss.usermodel.Sheet
-
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 - 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
-
- 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
-
- 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
-
- 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
-
- 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
-
- 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
-