Search
ColumnRange Members
Methods
 


Identifies a range of columns in a Worksheet.

The following tables list the members exposed by the ColumnRange type.

 Public Methods

  Name Description

getConditionalFormats

Gets a list with format objects that can be used to customize the appearance of the columns in the range based on various conditions.

getEnumerator

Returns an iterator object that can be used to iterate through the columns in the range.

getIsHidden

Gets a value indicating whether the columns in the range are hidden.

getLeft

Gets the left column of the range.

getOutlineLevel

Gets the outline level of the columns in the range.

getRight

Gets the right column of the range.

getStyle

Gets an IColumnStyle object that can be used to customize the appearance of all columns in the range.

getValidation

Gets an IValidation object that can be used to specify validation rules for the data in the range.

getWidth

Gets the width of all columns in the range.

group

Increases the outline level of all columns in the range.

iterator

 

setIsHidden

Sets a value indicating whether the columns in the range are hidden.

setOutlineLevel

Sets the outline level of the columns in the range.

setWidth

Sets the width of all columns in the range.

ungroup

Decreases the outline level of all columns in the range.

 See Also