Xceed Logo
Shop
Xceed Workbooks for .NET v3.0 Documentation
Xceed.Workbooks.NET Assembly / Xceed.Workbooks.NET Namespace / Column Class
Example


In This Topic
    Column Class
    In This Topic
    Represents a column in a Worksheet.
    Object Model
    Column ClassColumnCellCollection ClassCell ClassDataValidation ClassStyle ClassStyle Class
    Syntax
    '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

    Public Properties
     NameDescription
    Public PropertyBestFitGets or sets if the Column's Width will be adjusted to fit the Cells' largest content.  
    Public PropertyCellsGets the ColumnCellCollection.  
    Public PropertyDataValidationSets the Column's DataValidation.  
    Public PropertyIdGets the Id of a specific column in a worksheet. The first column starts at Id 0 and last column is located at Id 16383. (Inherited from Xceed.Workbooks.NET.LinearWorksheetElement)
    Public PropertyIdNameGets the index of the Column and returns it as a letter.  
    Public PropertyIsHiddenGets or sets if the Row or Column is hidden or not. (Inherited from Xceed.Workbooks.NET.LinearWorksheetElement)
    Public PropertyStyleGets the Style used by the Worksheet element. (Inherited from Xceed.Workbooks.NET.StyledWorksheetElement)
    Public PropertyWidthGets or sets the Column's width.  
    Top
    Public Methods
     NameDescription
    Public MethodAddConditionalFormattingAdds ConditionalFormatting to the Column.  
    Public MethodAutoFitOverridden. Adjusts the Column's Width based on the Cell with the widest content.  
    Public MethodClearRemoves specific elements from the LinearWorksheetElement. (Inherited from Xceed.Workbooks.NET.LinearWorksheetElement)
    Public MethodClearConditionalFormattingsRemoves all ConditionalFormattings from the Column.  
    Public MethodGetConditionalFormattingsGets the Column's ConditionalFormattings.  
    Public MethodRemoveConditionalFormattingRemoves a specific ConditionalFormatting from the Column.  
    Public MethodReplaceContentSearches into the content of the Column and replaces all occurences of a specific value with a new value. (Inherited from Xceed.Workbooks.NET.LinearWorksheetElement)
    Public MethodReplaceContents<TSearch,TNew>Searches into the content of the LinearWorksheetElement and replaces all instances of the searchValues with their corresponding newValues. (Inherited from Xceed.Workbooks.NET.LinearWorksheetElement)
    Top
    Protected Methods
     NameDescription
    Protected Internal MethodAddCellOverridden.   
    Protected Internal MethodCanWriteOverridden.   
    Protected Internal MethodGetCellsOverridden.   
    Protected Internal MethodGetNewStyle (Inherited from Xceed.Workbooks.NET.StyledWorksheetElement)
    Protected Internal MethodReadOverridden.   
    Protected Internal MethodReadStyleOverridden.   
    Protected Internal MethodRemoveCellOverridden.   
    Protected Internal MethodResetOverridden.   
    Protected Internal MethodUpdateChildrenStyleProperty (Inherited from Xceed.Workbooks.NET.LinearWorksheetElement)
    Protected Internal MethodUpdateStyleBordersOverridden.   
    Protected Internal MethodWrite (Inherited from Xceed.Workbooks.NET.LinearWorksheetElement)
    Protected Internal MethodWriteStyleOverridden.   
    Top
    Supported Frameworks

    .NET: net5.0, net5.0-windows, net6.0, net6.0-macos, net6.0-windows, net7.0, net7.0-macos, net7.0-windows, net8.0, net8.0-browser, net8.0-macos, net8.0-windows, net9.0, net9.0-browser, net9.0-macos, net9.0-windows, net10.0, net10.0-browser, net10.0-macos, net10.0-windows.

    .NET Framework: net40, net403, net45, net451, net452, net46, net461, net462, net463, net47, net471, net472, net48, net481.

    See Also

    Reference

    Column Members
    Xceed.Workbooks.NET Namespace

    Send Feedback