Uses of Enum Class
org.apache.poi.ss.SpreadsheetVersion
Packages that use SpreadsheetVersion
Package
Description
usermodel package maps HSSF low level strutures to familiar workbook/sheet model
This package contains common internal POI code for manipulating formulas.
-
Uses of SpreadsheetVersion in org.apache.poi.hssf.usermodel
Methods in org.apache.poi.hssf.usermodel that return SpreadsheetVersionModifier and TypeMethodDescriptionHSSFEvaluationWorkbook.getSpreadsheetVersion()HSSFWorkbook.getSpreadsheetVersion()Returns the spreadsheet version (EXCLE97) of this workbook -
Uses of SpreadsheetVersion in org.apache.poi.ss
Methods in org.apache.poi.ss that return SpreadsheetVersionModifier and TypeMethodDescriptionstatic SpreadsheetVersionReturns the enum constant of this class with the specified name.static SpreadsheetVersion[]SpreadsheetVersion.values()Returns an array containing the constants of this enum class, in the order they are declared. -
Uses of SpreadsheetVersion in org.apache.poi.ss.formula
Methods in org.apache.poi.ss.formula that return SpreadsheetVersionModifier and TypeMethodDescriptionEvaluationWorkbook.getSpreadsheetVersion()FormulaParsingWorkbook.getSpreadsheetVersion()Returns an enum holding spreadhseet properties specific to an Excel version ( max column and row numbers, max arguments to a function, etc.)Methods in org.apache.poi.ss.formula with parameters of type SpreadsheetVersionModifier and TypeMethodDescriptionstatic FormulaShifterFormulaShifter.createForColumnCopy(int externSheetIndex, String sheetName, int firstMovedColumnIndex, int lastMovedColumnIndex, int numberOfColumnsToMove, SpreadsheetVersion version) static FormulaShifterFormulaShifter.createForColumnShift(int externSheetIndex, String sheetName, int firstMovedColumnIndex, int lastMovedColumnIndex, int numberOfColumnsToMove, SpreadsheetVersion version) static FormulaShifterFormulaShifter.createForRowCopy(int externSheetIndex, String sheetName, int firstMovedRowIndex, int lastMovedRowIndex, int numberOfRowsToMove, SpreadsheetVersion version) static FormulaShifterFormulaShifter.createForRowShift(int externSheetIndex, String sheetName, int firstMovedRowIndex, int lastMovedRowIndex, int numberOfRowsToMove, SpreadsheetVersion version) Constructors in org.apache.poi.ss.formula with parameters of type SpreadsheetVersion -
Uses of SpreadsheetVersion in org.apache.poi.ss.usermodel
Methods in org.apache.poi.ss.usermodel that return SpreadsheetVersionModifier and TypeMethodDescriptionWorkbook.getSpreadsheetVersion()Returns the spreadsheet version of this workbook -
Uses of SpreadsheetVersion in org.apache.poi.ss.util
Methods in org.apache.poi.ss.util with parameters of type SpreadsheetVersionModifier and TypeMethodDescriptionstatic booleanCellReference.cellReferenceIsWithinRange(String colStr, String rowStr, SpreadsheetVersion ssVersion) Used to decide whether a name of the form "[A-Z]*[0-9]*" that appears in a formula can be interpreted as a cell reference.static CellReference.NameTypeCellReference.classifyCellReference(String str, SpreadsheetVersion ssVersion) Classifies an identifier as either a simple (2D) cell reference or a named range namestatic AreaReference[]AreaReference.generateContiguous(SpreadsheetVersion version, String reference) Takes a non-contiguous area reference, and returns an array of contiguous area referencesstatic AreaReferenceAreaReference.getWholeColumn(SpreadsheetVersion version, String start, String end) static AreaReferenceAreaReference.getWholeRow(SpreadsheetVersion version, String start, String end) static booleanCellReference.isColumnWithinRange(String colStr, SpreadsheetVersion ssVersion) static booleanCellReference.isRowWithinRange(int rowNum, SpreadsheetVersion ssVersion) Determines whetherrowis a valid row number for a given SpreadsheetVersion.static booleanCellReference.isRowWithinRange(String rowStr, SpreadsheetVersion ssVersion) Determines whetherrowStris a valid row number for a given SpreadsheetVersion.static booleanAreaReference.isWholeColumnReference(SpreadsheetVersion version, CellReference topLeft, CellReference botRight) Is the reference for a whole-column reference, such as C:C or D:G ?voidCellRangeAddressBase.validate(SpreadsheetVersion ssVersion) Validate the range limits against the supplied version of ExcelConstructors in org.apache.poi.ss.util with parameters of type SpreadsheetVersionModifierConstructorDescriptionAreaReference(String reference, SpreadsheetVersion version) Create an area ref from a string representation.AreaReference(CellReference topLeft, CellReference botRight, SpreadsheetVersion version) Creates an area ref from a pair of Cell References. -
Uses of SpreadsheetVersion in org.apache.poi.xssf.streaming
Methods in org.apache.poi.xssf.streaming that return SpreadsheetVersionModifier and TypeMethodDescriptionSXSSFWorkbook.getSpreadsheetVersion()Returns the spreadsheet version (EXCLE2007) of this workbook -
Uses of SpreadsheetVersion in org.apache.poi.xssf.usermodel
Methods in org.apache.poi.xssf.usermodel that return SpreadsheetVersionModifier and TypeMethodDescriptionBaseXSSFEvaluationWorkbook.getSpreadsheetVersion()XSSFWorkbook.getSpreadsheetVersion()Returns the spreadsheet version (EXCLE2007) of this workbook