Java org.apache.poi.ss SpreadsheetVersion fields, constructors, methods, implement or subclass

Example usage for Java org.apache.poi.ss SpreadsheetVersion fields, constructors, methods, implement or subclass

  1. HOME
  2. Java
  3. org.apache.poi
  4. org.apache.poi.ss.*
  5. SpreadsheetVersion

Introduction

In this page you can find the methods, fields and constructors for org.apache.poi.ss SpreadsheetVersion.

The text is from its open source code.

Field

SpreadsheetVersionEXCEL97
Excel97 format aka BIFF8
  • The total number of available rows is 64k (2^16)
  • The total number of available columns is 256 (2^8)
  • The maximum number of arguments to a function is 30
  • Number of conditional format conditions on a cell is 3
  • Number of cell styles is 4000
  • Length of text cell contents is 32767
SpreadsheetVersionEXCEL2007
Excel2007
  • The total number of available rows is 1M (2^20)
  • The total number of available columns is 16K (2^14)
  • The maximum number of arguments to a function is 255
  • Number of conditional format conditions on a cell is unlimited (actually limited by available memory in Excel)
  • Number of cell styles is 64000
  • Length of text cell contents is 32767

Method

intgetMaxColumns()