Column Class

Represents a column in a Worksheet.

Syntax

Visual Basic
C#

'Declaration

 

Public Class Column 

   Inherits LinearWorksheetElement

'Usage

 

Dim instance As Column

public class Column : LinearWorksheetElement

Remarks

Derives from LinearWorksheetElement.

Example

using( var doc = Workbook.Load( "test.xlsx") )

  {

    var worksheet = doc.Worksheets[ 0 ];        

    worksheet.Columns[ 1 ].Cells[ 1 ].Value =  new DateTime( 2021, 7, 1, 10, 22, 33 );   // Sets “B2”.

    worksheet.Columns[ 2 ].Width = 65d;

    doc.Save();

  }

Inheritance Hierarchy

System.Object
   Xceed.Workbooks.NET.WorkbookElement
      Xceed.Workbooks.NET.WorksheetElement
         Xceed.Workbooks.NET.StyledWorksheetElement
            Xceed.Workbooks.NET.LinearWorksheetElement
               Xceed.Workbooks.NET.Column

Requirements

Target Platforms: Windows 11, Windows 10, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

Column Members
Xceed.Workbooks.NET Namespace