Skip to main content

Module constants

Module constants 

Source
Expand description

Excel limit constants and default values.

These constants mirror the hard limits enforced by Microsoft Excel 2007+ (OOXML / .xlsx format).

Constantsยง

DEFAULT_COL_WIDTH
Default column width used when no explicit width is set (character-width units).
DEFAULT_ROW_HEIGHT
Default row height in points.
MAX_CELL_CHARS
Maximum number of characters that a single cell can contain.
MAX_CELL_STYLES
Maximum number of cell styles that can be stored in a workbook.
MAX_COLUMNS
Maximum number of columns (XFD = 16 384 = 2^14).
MAX_COLUMN_WIDTH
Maximum column width in character-width units.
MAX_FONT_SIZE
Maximum font size in points.
MAX_ROWS
Maximum number of rows (1 048 576 = 2^20).
MAX_ROW_HEIGHT
Maximum row height in points.
MAX_SHEET_NAME_LENGTH
Maximum length (in characters) of a sheet name.
SHEET_NAME_INVALID_CHARS
Characters that are not allowed in Excel sheet names.
STREAM_CHUNK_SIZE
Chunk size used by the streaming writer (16 MiB).