Paper Office
paper-xlsxAPI referenceworksheet.dimensions

ColumnDimension

paper-xlsx 0.2.1 API reference

Information about the display properties of a column.

ColumnDimension(worksheet, index='A', width=DEFAULT_COLUMN_WIDTH, bestFit=False, hidden=False, outlineLevel=0, outline_level=None, collapsed=False, style=None, min=None, max=None, customWidth=False, visible=None, auto_size=None)

Attributes

alignment

attributealignment
= StyleDescriptor('_alignments', 'alignmentId')

auto_size

attributeauto_size
= Alias('bestFit')

bestFit

attributebestFit
= bestFit

border

attributeborder
= StyleDescriptor('_borders', 'borderId')

collapsed

attributecollapsed
= collapsed

customWidth

attributecustomWidth

Always true if there is a width for the column

fill

attributefill
= StyleDescriptor('_fills', 'fillId')

font

attributefont
= StyleDescriptor('_fonts', 'fontId')

has_style

attributehas_style

hidden

attributehidden
= hidden

index

attributeindex
= String()

max

attributemax
= max

min

attributemin
= min

number_format

attributenumber_format
= NumberFormatDescriptor()

outlineLevel

attributeoutlineLevel
= outlineLevel

outline_level

attributeoutline_level
= Alias('outlineLevel')

parent

attributeparent
= sheet

pivotButton

attributepivotButton
= StyleArrayDescriptor('pivotButton')

protection

attributeprotection
= StyleDescriptor('_protections', 'protectionId')

quotePrefix

attributequotePrefix
= StyleArrayDescriptor('quotePrefix')

range

attributerange

Return the range of cells actually covered

style

attributestyle
= Alias('style_id')

style_id

attributestyle_id

width

attributewidth
= width

Functions

__iter__

func__iter__()

reindex

funcreindex()

Set boundaries for column definition

to_tree

functo_tree()

On this page