Top Classes
[default module]

Package org.apache.poi.ss.util


Class Summary

Modifier and TypeClass and Description
public class
public class
CellAddress

This class is a container for POI usermodel row=0 column=0 cell references.

public class
CellRangeAddress

See OOO documentation: excelfileformat.pdf sec 2.5.14 - 'Cell Range Address'

In the Microsoft documentation, this is also known as a Ref8U - see page 831 of version 1.0 of the documentation.

public abstract class
CellRangeAddressBase

See OOO documentation: excelfileformat.pdf sec 2.5.14 - 'Cell Range Address'

Common superclass of 8-bit and 16-bit versions

public class
CellRangeAddressList

Implementation of the cell range address lists,like is described in OpenOffice.org's Excel Documentation: excelfileformat.pdf sec 2.5.14 - 'Cell Range Address List' In BIFF8 there is a common way to store absolute cell range address lists in several records (not formulas).

public class
CellRangeUtil

Utility class that builds on CellRangeAddress Portions of this class may be moved to CellRangeAddressBase

public class
CellReference

Common conversion functions between Excel style A1, C27 style cell references, and POI usermodel style row=0, column=0 style references.

public class
CellUtil

Various utility functions that make working with a cells and rows easier.

public class
DateFormatConverter

Convert java DateFormat patterns into Excel custom number formats.

public class
DateParser

Parser for java dates.

pack-priv class
ExpandedDouble

Represents a 64 bit IEEE double quantity expressed with both decimal and binary exponents Does not handle negative numbers or zero

The value of a ExpandedDouble is given by a × 2b where: a = significand b = binaryExponent - bitLength(significand) + 1

pack-priv class
IEEEDouble

For working with the internals of IEEE 754-2008 'binary64' (double precision) floating point numbers

public class
pack-priv class
pack-priv class
NormalisedDecimal

Represents a transformation of a 64 bit IEEE double quantity having a decimal exponent and a fixed point (15 decimal digit) significand.

public class
NumberComparer

Excel compares numbers using different rules to those of java, so Double#compare(double, double) won't do.

public class
NumberToTextConverter

Excel converts numbers to text with different rules to those of java, so Double.toString(value) won't do.

public class
PaneInformation

Holds information regarding a split plane or freeze plane for a sheet.

public class
PropertyTemplate

A PropertyTemplate is a template that can be applied to any sheet in a project.

public class
RegionUtil

Various utility functions that make working with a region of cells easier.

public class
SheetBuilder

Class SheetBuilder provides an easy way of building workbook sheets from 2D array of Objects.

public class
SheetUtil

Helper methods for when working with Usermodel sheets

public class
SSCellRange<K extends Cell>

For POI internal use only

public class
WorkbookUtil

Helper methods for when working with Usermodel Workbooks