Page History

{description}
{excerpt}The [ColumnProperties|ColumnProperties] class represents a single column in a worksheet.{excerpt}
{signature:C#}
 public sealed class ColumnProperties
{signature}{signature:vb.net}
Public NotInheritable Class ColumnProperties
{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.
{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)
        {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}|