| Name | Description | |
|---|---|---|
 | Address | Gets the address of this Cell, which is composed of a letter (for the Column) and a number (for the Row). The first Column starts at “A” and first Row starts at “1”; this means that the top left Cell is located at the “A1” address. |
| ColumnId | Gets the Id of the column associated to this cell, the first column starting at Id 0. The maximum numbers of column allowed for a worksheet is 16384. |
| DataType | Gets the DataType in the Cell. The default type is Number. |
| Formula | Gets or sets the formula used for this cell. A formula always starts with the equal sign (“=”) and uses comma (“,”) as parameter separators. Example: “=SUM(A1, A2, A4)”. A formula can include constant (“=A1 + 5*4%”), references (“=A1*A3”), ranges of references (“=SUM(A1:A3, B1:B3)”) or functions (“=SUM(A1:A3) + AVERAGE(B1:B3)”). Note that each functions have their own characteristics and that you should refer to their specific pages for more information. The formula will be calculated once the workbook is opened with MS Excel and the Value property will be updated once the workbook is saved with MS Excel. The formula can also be calculated by using Worksheet.CalculateFormulas() since this call will automatically set the Value property. The default value is null. |
| RowId | Gets the Id of the row associated to this cell, the first row starting at Id 0. The maximum number of rows allowed for a worksheet is 1048576. |
| Style | Gets the Style object for a worksheet element. The default value is a default style object. (Inherited from Xceed.Workbooks.NET.StyledWorksheetElement) |
| Value | Gets or sets the value for this Cell. Currently, the valid value types can be numerics ( int, double, float, byte, decimal, short, long, sbyte, ushort, uint, ulong), string, DateTime, TimeSpan or bool. The default value is null. |
Xceed Workbooks for .NET v1.4 Documentation
Cell Class Members
