The ColumnProperties class represents a single column in a worksheet.

 public sealed class ColumnProperties

Public NotInheritable Class ColumnProperties

To return a ColumnProperties object, use Worksheet.GetColumnProperties(). The following sample gets the column properties for the first column of the first worksheet.


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

          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)

Name

Description

ColumnNumber

Hidden

OutlineCollapsed

OutlineLevel

PaddingInChars

Style

Width

WidthInChars

Name

Description

ApplyStyle(Style)

AutoFitWidth()