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


In This Topic
    Cell Class
    In This Topic
    A cell represents a rectangle in a Worksheet. Each cell is the intersection of a Row and a Column. It can be accessed by using an address (a combination of a letter and a number, like A1, B2, C3…, where the letter is the Column Id and the number is the Row Id) or by coordinates (by specifying the Row Id first & then the Column Id, for example, 0,0; 2,3; 5;5...). Note that indexes for Rows & Columns always start at 0.
    Object Model
    Cell ClassDataValidation ClassFormattedTextList ClassFormattedText ClassStyle ClassStyle Class
    Syntax
    'Declaration
 

    Public Class Cell 
   Inherits StyledWorksheetElement
    'Usage
 

    Dim instance As Cell
    public class Cell : StyledWorksheetElement
    Remarks

    Each cell is the intersection of a Row and a Column.

    It can be accessed by using an address (a combination of a letter and a number, like A1, B2, C3…, where the letter is the Column Id and the number is the Row Id) or by coordinates (by specifying the Row Id first & then the Column Id, for example, 0,0; 2,3; 5;5...).

    Note that indexes for Rows & Columns always start at 0.

    Example
    using( var doc = Workbook.Load( "test.xlsx") )
  {
    var worksheet = doc.Worksheets[ 0 ];        
    worksheet.Cells[ "A1" ].Value =  new DateTime( 2021, 7, 1, 10, 22, 33 );  
    worksheet.Cells[0, 1].Formula = “SUM(A2*4%)”;
    doc.Save();
  }
    Inheritance Hierarchy

    System.Object
       Xceed.Workbooks.NET.WorkbookElement
          Xceed.Workbooks.NET.WorksheetElement
             Xceed.Workbooks.NET.StyledWorksheetElement
                Xceed.Workbooks.NET.Cell

    Public Properties
     NameDescription
    Public PropertyAddressGets the address of the Cell.  
    Public PropertyColumnIdGets the Id of the Column associated with the Cell.  
    Public PropertyDataTypeGets the Cell's DataType.  
    Public PropertyDataValidationGets or sets the Cell's DataValidation.  
    Public PropertyFormula

    Gets or sets the Cell's formula.

     
    Public PropertyRowIdGets the Id of the Row associated with the Cell.  
    Public PropertyStyleGets the Style used by the Worksheet element. (Inherited from Xceed.Workbooks.NET.StyledWorksheetElement)
    Public PropertyValueGets or sets the Cell's value.  
    Top
    Public Methods
     NameDescription
    Public MethodAddConditionalFormattingAdds ConditionalFormatting to the Cell.  
    Public MethodCalculateFormulaStarts the calculation process in order to get a value from the Cell's formula.  
    Public MethodClearConditionalFormattingsRemoves all ConditionalFormattings from the Cell.  
    Public MethodCopyAndPasteToCopies or cuts a Cell & pastes it into another Cell.  
    Public MethodFormatTextFormats a specific section of the text with a selected Font.  
    Public MethodGetConditionalFormattingsGets the Cell's ConditionalFormattings.  
    Public MethodGetValidationResultGets the result of the DataValidation process.   
    Public MethodRemoveConditionalFormattingRemoves a specific ConditionalFormatting from the Cell.  
    Top
    Protected Methods
     NameDescription
    Protected Internal MethodGetNewStyleOverridden.   
    Protected Internal MethodReadStyleOverridden.   
    Protected Internal MethodResetOverridden.   
    Protected Internal MethodUpdateChildrenStyleProperty (Inherited from Xceed.Workbooks.NET.StyledWorksheetElement)
    Protected Internal MethodUpdateStyleBordersOverridden.   
    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

    Cell Members
    Xceed.Workbooks.NET Namespace

    Send Feedback