Package org.apache.poi.ss.util
package org.apache.poi.ss.util
-
ClassDescriptionThis class is a container for POI usermodel row=0 column=0 cell references.See OOO documentation: excelfileformat.pdf sec 2.5.14 - 'Cell Range Address'See OOO documentation: excelfileformat.pdf sec 2.5.14 - 'Cell Range Address'Indicates a cell or range is in the given relative position in a range.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).Utility class that builds on
CellRangeAddressPortions of this class may be moved toCellRangeAddressBaseCommon conversion functions between Excel style A1, C27 style cell references, and POI usermodel style row=0, column=0 style references.Used to classify identifiers found in formulas as cell references or not.Various utility functions that make working with a cells and rows easier.Convert java DateFormat patterns into Excel custom number formats.Parser for java dates.Excel compares numbers using different rules to those of java, soDouble.compare(double, double)won't do.Excel converts numbers to text with different rules to those of java, soDouble.toString(value)won't do.Holds information regarding a split plane or freeze plane for a sheet.A PropertyTemplate is a template that can be applied to any sheet in a project.Various utility functions that make working with a region of cells easier.ClassSheetBuilderprovides an easy way of building workbook sheets from 2D array of Objects.Helper methods for when working with Usermodel sheetsSSCellRange<K extends Cell>For POI internal use onlyHelper methods for when working with Usermodel Workbooks