Package org.apache.poi.hssf.usermodel
package org.apache.poi.hssf.usermodel
The usermodel package maps HSSF low level structures to familiar workbook/sheet model
-
ClassDescriptionData Validation ConstraintTranslates Graphics calls into escher calls.Translates Graphics2d calls into escher calls.Stores width and height details about a font.Common class for
HSSFHeaderandHSSFFooter.An anchor is what specifics the position of a shape within a client object or within another containing shape.Represents autofiltering for the specified worksheet.High level representation for Border Formatting component of Conditional Formatting settingsHigh level representation of a cell in a row of a spreadsheet.High level representation of the style of a cell in a sheet of a workbook.Has methods for construction of a chart object.A series in a chartA client anchor is attached to an excel worksheet.High level representation for Color Scale / Color Gradient Formatting component of Conditional Formatting settingsRepresents a cell comment - a sticky note associated with a cell.HSSFConditionalFormatting class encapsulates all settings of Conditional Formatting.High level representation of Conditional Formatting Rule.High level representation for Icon / Multi-State / Databar / Colour Scale change thresholdsHigh level representation for DataBar / Data-Bar Formatting component of Conditional Formatting settingsIdentifies both built-in and user defined formats within a workbook.HSSFDataFormatter contains methods for formatting the value stored in an HSSFCell.Utility class for creating data validation cellsHelper for working with Data ValidationInternal POI use onlyThe HSSF file format normally stores Color information in the Palette (see PaletteRecord), but for a few cases (eg Conditional Formatting, Sheet Extensions), this XSSF-style color record can be used.Represents a Font used in a workbook.High level representation for Font Formatting component of Conditional Formatting settingsClass to read and manipulate the footer.Evaluates formula cells.Class to read and manipulate the header.Represents an Excel hyperlink.High level representation for Icon / Multi-State Formatting component of Conditional Formatting settingsHigh Level Representation of a 'defined name' which could be a 'built-in' name, 'named range' or name of a user defined function.Represents binary object (i.e.Excel can get cranky if you give it files containing too many (especially duplicate) objects, and this class can help to avoid those.Represents a workbook color palette.The patriarch is the toplevel container for shapes in a sheet.High level representation for Conditional Formatting settingsRepresents a escher picture.Represents binary data stored in the file.Used to modify the print setup.Rich text unicode string.High level representation of a row of a spreadsheet.An abstract shape.An interface that indicates whether a class can contain children.Factory class for producing Excel Shapes from Escher recordsA shape group may contain other shapes.High level representation of a worksheet.The 'Conditional Formatting' facet ofHSSFSheetRepresents a simple shape such as a line, rectangle or oval.A textbox is a shape that may hold a rich text string.High level representation of a workbook.Helper class which is instantiated by reflection fromWorkbookFactory.create(java.io.File)and similar