Package org.apache.poi.ss.usermodel

Interface CreationHelper

  • All Known Implementing Classes:
    HSSFCreationHelper, SXSSFCreationHelper, XSSFCreationHelper
    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.

    • Method Detail

      • 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