OfficeWriter Documentation
.
ExcelWriter v8 Docs
Space Shortcuts
Page tree
ConfigureSpace tools

Versions Compared

Old Version 1

changes.mady.by.user Wiki Administrator

Saved on

compared with

New Version 2

changes.mady.by.user Anonymous

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 4.0
Description

Excerpt

The ColumnProperties class represents a single column in a worksheet.


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

          ExcelApplication xla = new ExcelApplication();
          Workbook wb = xla.Create();
          Worksheet ws = wb.Worksheets[0];
          ColumnProperties colProps = ws.GetColumnProperties(0);
        
{code}
{code: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)
Signature
C#C#
Wiki Markup
{description}
{excerpt}The [ColumnProperties|ColumnProperties] class represents a single column in a worksheet.{excerpt}
{signature:C#}
 public sealed class ColumnProperties
Signature
{signature}{signature:vb.net
vb.net
}
Public NotInheritable Class ColumnProperties
Remarks
To return a ColumnProperties object, use 
{signature}
{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.
Example
Code Block
csharpcsharp
titleC#
Code Block
vb.nettitle
Properties

...

Name

...

Description

...

ColumnNumber

...

{code}

{example}
{properties}
||Name||Description||
|[ColumnNumber|ColumnProperties.ColumnNumber]|{excerpt-include:ColumnProperties.ColumnNumber

...

Hidden

|nopanel=true}|
|[Hidden|ColumnProperties.Hidden]|{excerpt-include

...

:ColumnProperties.Hidden

...

OutlineCollapsed

|nopanel=true}|
|[OutlineCollapsed|ColumnProperties.OutlineCollapsed]|{excerpt-include

...

:ColumnProperties.OutlineCollapsed

...

OutlineLevel

|nopanel=true}|
|[OutlineLevel|ColumnProperties.OutlineLevel]|{excerpt-include

...

:ColumnProperties.OutlineLevel

...

PaddingInChars

|nopanel=true}|
|[PaddingInChars|ColumnProperties.PaddingInChars]|{excerpt-include

...

:ColumnProperties.PaddingInChars

...

Style

|nopanel=true}|
|[Style|ColumnProperties.Style]|{excerpt-include

...

:ColumnProperties.Style

...

Width

|nopanel=true}|
|[Width|ColumnProperties.Width]|{excerpt-include

...

:ColumnProperties.Width

...

WidthInChars

|nopanel=true}|
|[WidthInChars|ColumnProperties.WidthInChars]|{excerpt-include

...

:ColumnProperties.WidthInChars

...

Methods

...

Name

...

Description

|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}|