Cells Properties

The Cells type exposes the following members.

Properties
  NameDescription
Public propertyColumns
Gets the collection of Column objects that represents the individual columns in this worksheet.
Public propertyCount
Gets the total count of instantiated Cell objects.
Public propertyCountLarge
Gets the total count of instantiated Cell objects.
Public propertyFirstCell
Gets the first cell in this worksheet.
Public propertyIsDefaultRowHeightMatched
Indicates that row height and default font height matches
Public propertyIsDefaultRowHidden
Indicates whether the row is default hidden.
Public propertyItemInt32 Obsolete.
Gets Cell item within the worksheet
Public propertyCode exampleItemString
Gets the Cell element at the specified cell name.
Public propertyCode exampleItemInt32, Int32
Gets the Cell element at the specified cell row index and column index.
Public propertyLastCell
Gets the last cell in this worksheet.
Public propertyMaxColumn
Maximum column index of cell which contains data or style.
Public propertyMaxDataColumn
Maximum column index of cell which contains data.
Public propertyMaxDataRow
Maximum row index of cell which contains data.
Public propertyMaxDisplayRange
Gets the max range which includes data, merged cells and shapes.
Public propertyMaxRow
Maximum row index of cell which contains data or style.
Public propertyMemorySetting
Gets or sets the memory usage option for this cells.
Public propertyMergedCells
Gets the collection of merged cells.
Public propertyMinColumn
Minimum column index of cell which contains data or style.
Public propertyMinDataColumn
Minimum column index of cell which contains data.
Public propertyMinDataRow
Minimum row index of cell which contains data.
Public propertyMinRow
Minimum row index of cell which contains data or style.
Public propertyMultiThreadReading
Gets or sets whether the cells data model should support Multi-Thread reading. Default value of this property is false. If there are multiple threads to read Row/Cell objects in this collection concurrently, this property should be set as true, otherwise unexpected result may be produced. Supporting Multi-Thread reading may degrade the performance for accessing Row/Cell objects from this collection.
Public propertyOdsCellFields
Gets the list of fields of ods.
Public propertyPreserveString
Gets or sets a value indicating whether all worksheet values are preserved as strings. Default is false.
Public propertyRanges
Gets the collection of Range objects created at run time.
Public propertyRows
Gets the collection of Row objects that represents the individual rows in this worksheet.
Public propertyStandardHeight
Gets or sets the default row height in this worksheet, in unit of points.
Public propertyStandardHeightPixels
Gets or sets the default row height in this worksheet, in unit of pixels.
Public propertyStandardWidth
Gets or sets the default column width in the worksheet, in unit of characters.
Public propertyStandardWidthInch
Gets or sets the default column width in the worksheet, in unit of inches.
Public propertyStandardWidthPixels
Gets or sets the default column width in the worksheet, in unit of pixels.
Public propertyStyle
Gets and sets the default style.
See Also