Top Description Methods
org.apache.poi.ss.usermodel

public Interface CreationHelper

Known Direct Implementers
org.apache.poi.hssf.usermodel.HSSFCreationHelper
Imports
org.apache.poi.common.usermodel.HyperlinkType, org.apache.poi.ss.util.AreaReference, .CellReference

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.

Method Summary

Modifier and TypeMethod and Description
public AreaReference

Returns:

an AreaReference instance
createAreaReference
(String
cell reference
reference
)

Creates an AreaReference.

public AreaReference

Returns:

an AreaReference instance
createAreaReference
(CellReference
cell reference
topLeft
,
CellReference
cell reference
bottomRight
)

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

public ClientAnchor

Returns:

a ClientAnchor instance
createClientAnchor
()

Creates a ClientAnchor.

public DataFormat
createDataFormat()

Creates a new DataFormat instance

public ExtendedColor
createExtendedColor()

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

public FormulaEvaluator

Returns:

a FormulaEvaluator instance
createFormulaEvaluator
()

Creates FormulaEvaluator - an object that evaluates formula cells.

public RichTextString
createRichTextString(String
The text to initialise the RichTextString with
text
)

Creates a new RichTextString instance

Method Detail

createAreaReferenceback to summary
public AreaReference createAreaReference(String reference)

Creates an AreaReference.

Parameters
reference:String

cell reference

Returns:AreaReference

an AreaReference instance

createAreaReferenceback to summary
public AreaReference createAreaReference(CellReference topLeft, CellReference bottomRight)

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

Parameters
topLeft:CellReference

cell reference

bottomRight:CellReference

cell reference

Returns:AreaReference

an AreaReference instance

createClientAnchorback to summary
public ClientAnchor createClientAnchor()

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

Returns:ClientAnchor

a ClientAnchor instance

See Also
org.apache.poi.ss.usermodel.Drawing
createDataFormatback to summary
public DataFormat createDataFormat()

Creates a new DataFormat instance

createExtendedColorback to summary
public ExtendedColor createExtendedColor()

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

createFormulaEvaluatorback to summary
public FormulaEvaluator createFormulaEvaluator()

Creates FormulaEvaluator - an object that evaluates formula cells.

Returns:FormulaEvaluator

a FormulaEvaluator instance

createRichTextStringback to summary
public RichTextString createRichTextString(String text)

Creates a new RichTextString instance

Parameters
text:String

The text to initialise the RichTextString with