org.apache.poi.ss.usermodel
Interface CreationHelper

All Known Implementing Classes:

HSSFCreationHelper

public interface CreationHelper

An object that handles instantiating concrete classes of the various instances one needs for HSSF and XSSF. Works around a limitation in Java where we cannot have static methods on interfaces or abstract classes. This allows you to get the appropriate class for a given interface, without you having to worry about if you're dealing with HSSF or XSSF.

createRichTextString

RichTextString createRichTextString(java.lang.String text)

Creates a new RichTextString instance

Parameters:

text - The text to initialise the RichTextString with

createDataFormat

DataFormat createDataFormat()

Creates a new DataFormat instance

createHyperlink

Hyperlink createHyperlink(HyperlinkType type)

Creates a new Hyperlink, of the given type

createFormulaEvaluator

FormulaEvaluator createFormulaEvaluator()

Creates FormulaEvaluator - an object that evaluates formula cells.

Returns:

a FormulaEvaluator instance

createExtendedColor

ExtendedColor createExtendedColor()

Creates a XSSF-style Color object, used for extended sheet formattings and conditional formattings

createClientAnchor

ClientAnchor createClientAnchor()

Creates a ClientAnchor. Use this object to position drawing object in a sheet

Returns:

a ClientAnchor instance

See Also:

Drawing

createAreaReference

AreaReference createAreaReference(java.lang.String reference)

Creates an AreaReference.

Parameters:

reference - cell reference

Returns:

an AreaReference instance

createAreaReference

AreaReference createAreaReference(CellReference topLeft,
                                  CellReference bottomRight)

Creates an area ref from a pair of Cell References..

Parameters:

topLeft - cell reference

bottomRight - cell reference

Returns:

an AreaReference instance