Top Description Interfaces Classes
[default module]

Package org.apache.poi.hssf.usermodel


The usermodel package maps HSSF low level structures to familiar workbook/sheet model

Interface Summary

Modifier and TypeInterface and Description
public interface
HSSFShapeContainer

An interface that indicates whether a class can contain children.

public interface

Class Summary

Modifier and TypeClass and Description
public class
DVConstraint

Data Validation Constraint

public class
EscherGraphics

Translates Graphics calls into escher calls.

public class
EscherGraphics2d

Translates Graphics2d calls into escher calls.

public class
FontDetails

Stores width and height details about a font.

public abstract class
HeaderFooter

Common class for HSSFHeader and HSSFFooter.

public abstract class
HSSFAnchor

An anchor is what specifics the position of a shape within a client object or within another containing shape.

public class
HSSFAutoFilter

Represents autofiltering for the specified worksheet.

public class
HSSFBorderFormatting

High level representation for Border Formatting component of Conditional Formatting settings

public class
HSSFCell

High level representation of a cell in a row of a spreadsheet.

public class
HSSFCellStyle

High level representation of the style of a cell in a sheet of a workbook.

public class
HSSFChart

Has methods for construction of a chart object.

public class
public class
HSSFClientAnchor

A client anchor is attached to an excel worksheet.

public class
HSSFColorScaleFormatting

High level representation for Color Scale / Color Gradient Formatting component of Conditional Formatting settings

public class
public class
HSSFComment

Represents a cell comment - a sticky note associated with a cell.

public class
HSSFConditionalFormatting

HSSFConditionalFormatting class encapsulates all settings of Conditional Formatting.

public class
HSSFConditionalFormattingRule

High level representation of Conditional Formatting Rule.

public class
HSSFConditionalFormattingThreshold

High level representation for Icon / Multi-State / Databar / Colour Scale change thresholds

public class
public class
HSSFDataBarFormatting

High level representation for DataBar / Data-Bar Formatting component of Conditional Formatting settings

public class
HSSFDataFormat

Identifies both built-in and user defined formats within a workbook.

public class
HSSFDataFormatter

HSSFDataFormatter contains methods for formatting the value stored in an HSSFCell.

public class
HSSFDataValidation

Utility class for creating data validation cells

public class
HSSFDataValidationHelper

Helper for working with Data Validation

pack-priv class
HSSFEvaluationCell

HSSF wrapper for a cell under evaluation

pack-priv class
HSSFEvaluationSheet

HSSF wrapper for a sheet under evaluation

public class
HSSFEvaluationWorkbook

Internal POI use only

public class
HSSFExtendedColor

The 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.

public class
HSSFFont

Represents a Font used in a workbook.

public class
HSSFFontFormatting

High level representation for Font Formatting component of Conditional Formatting settings

public class
HSSFFooter

Class to read and manipulate the footer.

public class
HSSFFormulaEvaluator

Evaluates formula cells.

public class
HSSFHeader

Class to read and manipulate the header.

public class
HSSFHyperlink

Represents an Excel hyperlink.

public class
HSSFIconMultiStateFormatting

High level representation for Icon / Multi-State Formatting component of Conditional Formatting settings

public class
HSSFName

High Level Representation of a 'defined name' which could be a 'built-in' name, 'named range' or name of a user defined function.

public class
HSSFObjectData

Represents binary object (i.e. OLE) data stored in the file.

public class
HSSFOptimiser

Excel can get cranky if you give it files containing too many (especially duplicate) objects, and this class can help to avoid those.

public class
HSSFPalette

Represents a workbook color palette.

public class
HSSFPatriarch

The patriarch is the toplevel container for shapes in a sheet.

public class
HSSFPatternFormatting

High level representation for Conditional Formatting settings

public class
HSSFPicture

Represents an escher picture.

public class
HSSFPictureData

Represents binary data stored in the file.

public class
public class
HSSFPrintSetup

Used to modify the print setup.

public class
public class
HSSFRichTextString

Rich text unicode string.

public class
HSSFRow

High level representation of a row of a spreadsheet.

public abstract class
HSSFShape

An abstract shape.

public class
HSSFShapeFactory

Factory class for producing Excel Shapes from Escher records

public class
HSSFShapeGroup

A shape group may contain other shapes.

public class
HSSFSheet

High level representation of a worksheet.

public class
HSSFSheetConditionalFormatting

The 'Conditional Formatting' facet of HSSFSheet

public class
HSSFSimpleShape

Represents a simple shape such as a line, rectangle or oval.

public class
HSSFTextbox

A textbox is a shape that may hold a rich text string.

public class
HSSFWorkbook

High level representation of a workbook.

public class
HSSFWorkbookFactory

Helper class which is instantiated by reflection from WorkbookFactory#create(java.io.File) and similar

pack-priv class
StaticFontMetrics

Allows the user to lookup the font metrics for a particular font without actually having the font on the system.