Methods

applyStyle(style, flag)

Applies formats for a whole column.

Parameters

Name Type Optional Description

style

Style

 

The style object which will be applied.

flag

StyleFlag

 

Flags which indicates applied formatting properties.

getGroupLevel()

Gets the group level of the column.

getIndex()

Gets the index of this column.

getStyle()

Gets the style of this column. Modifying the returned style object directly takes no effect for this column or any cells in this column. You have to call applyStyle(com.aspose.cells.Style, com.aspose.cells.StyleFlag) or setStyle(com.aspose.cells.Style) method to apply the change to this column. Column's style is the style which will be inherited by cells in this column(those cells that have no custom style settings, such as existing cells that have not been set style explicitly, or those that have not been instantiated)

getWidth()

Gets and sets the column width in unit of characters. For spreadsheet, column width is measured as the number of characters of the maximum digit width of the numbers 0~9 as rendered in the normal style's font.

hasCustomStyle()

Indicates whether this column has custom style settings(different from the default one inherited from workbook).

isCollapsed()

whether the column is collapsed

isHidden()

Indicates whether the column is hidden.

setCollapsed()

whether the column is collapsed

setGroupLevel()

Gets the group level of the column.

setHidden()

Indicates whether the column is hidden.

setStyle(style)

Sets the style of this column. This method only sets the given style as the default style for this column, without changing the style settings for existing cells in this column. To update style settings of existing cells to the specified style at the same time, please use applyStyle(com.aspose.cells.Style, com.aspose.cells.StyleFlag)

Parameter

Name Type Optional Description

style

Style

 

the style to be used as the default style for cells in this column.

setWidth()

Gets and sets the column width in unit of characters. For spreadsheet, column width is measured as the number of characters of the maximum digit width of the numbers 0~9 as rendered in the normal style's font.