Page History

...

Description

Excerpt
The ColumnProperties class represents a single column in a worksheet.

Signature

	C#
	C#

 public sealed class ColumnProperties
{signature}{signature:

}

Signature

	vb.net


	vb.net

Public NotInheritable Class ColumnProperties
{signature}
{remarks}
To return a {{ColumnProperties}} object, use [

Remarks

To return a ColumnProperties object, use Worksheet.GetColumnProperties()

|Worksheet

.

GetColumnProperties(Int32)].

The

following

sample

gets

the

column

properties

for

the

first

column

of

the

first

worksheet.

{remarks} {example}{code:csharp|title=C#}

Example

Code Block

	csharp
	csharp
title	C#



          ExcelApplication xla = new ExcelApplication();
          Workbook wb = xla.Create();
          Worksheet ws = wb.Worksheets[0];
          ColumnProperties colProps = ws.GetColumnProperties(0);

{code} {code:

Code Block

	vb.net

|title=


	vb.net
title	vb.net

}



          Dim xla As New ExcelApplication()
          Dim wb As Workbook = xla.Create()
          Dim ws As Worksheet = wb.Worksheets(0)
          Dim colProps As ColumnProperties = ws.GetColumnProperties(0)

{code} {example} {properties} ||Name||Description|| |[ColumnNumber|ColumnProperties.ColumnNumber]|{excerpt-include:ColumnProperties.ColumnNumber|nopanel=true}| |[Hidden|ColumnProperties.Hidden]|{excerpt-include:ColumnProperties.Hidden|nopanel=true}| |[OutlineCollapsed|ColumnProperties.OutlineCollapsed]|{excerpt-include:ColumnProperties.OutlineCollapsed|nopanel=true}| |[OutlineLevel|ColumnProperties.OutlineLevel]|{excerpt-include:ColumnProperties.OutlineLevel|nopanel=true}| |[PaddingInChars|ColumnProperties.PaddingInChars]|{excerpt-include:ColumnProperties.PaddingInChars|nopanel=true}| |[Style|ColumnProperties.Style]|{excerpt-include:ColumnProperties.Style|nopanel=true}| |[Width|ColumnProperties.Width]|{excerpt-include:ColumnProperties.Width|nopanel=true}| |[WidthInChars|ColumnProperties.WidthInChars]|{excerpt-include:ColumnProperties.WidthInChars|nopanel=true}| {methods} ||Name||Description|| |[ApplyStyle(Style)|ColumnProperties.ApplyStyle(Style)]|{excerpt-include:ColumnProperties.ApplyStyle(Style)|nopanel=true}| |[AutoFitWidth()|ColumnProperties.AutoFitWidth()]|{excerpt-include:ColumnProperties.AutoFitWidth()|nopanel=true}|

Properties

Name

Description

ColumnNumber

Excerpt Include

	ColumnProperties.ColumnNumber
	ColumnProperties.ColumnNumber
nopanel	true

Hidden

Excerpt Include

	ColumnProperties.Hidden
	ColumnProperties.Hidden
nopanel	true

OutlineCollapsed

Excerpt Include

	ColumnProperties.OutlineCollapsed
	ColumnProperties.OutlineCollapsed
nopanel	true

OutlineLevel

Excerpt Include

	ColumnProperties.OutlineLevel
	ColumnProperties.OutlineLevel
nopanel	true

PaddingInChars

Excerpt Include

	ColumnProperties.PaddingInChars
	ColumnProperties.PaddingInChars
nopanel	true

Style

Excerpt Include

	ColumnProperties.Style
	ColumnProperties.Style
nopanel	true

Width

Excerpt Include

	ColumnProperties.Width
	ColumnProperties.Width
nopanel	true

WidthInChars

Excerpt Include

	ColumnProperties.WidthInChars
	ColumnProperties.WidthInChars
nopanel	true

Methods

Name

Description

ApplyStyle(Style)

Excerpt Include

	ColumnProperties.ApplyStyle(Style)
	ColumnProperties.ApplyStyle(Style)
nopanel	true

AutoFitWidth()

Excerpt Include

	ColumnProperties.AutoFitWidth()
	ColumnProperties.AutoFitWidth()
nopanel	true

Space Shortcuts

Page tree

Versions Compared

Old Version 6

New Version Current

Key