Version

Cells Property (WorksheetRow)

Gets the collection of cells in the row.
Syntax
public WorksheetCellCollection Cells {get;}

Property Value

The collection of cells in the row.
Remarks

The collection of cells is a fixed length collection, with the maximum number of cells in the collection being Workbook.MaxExcelColumnCount or Workbook.MaxExcel2007ColumnCount, depending on the Workbook.CurrentFormat. Internally, the cells are only created and added to the collection when they are requested.

Note: Iterating the collection will not create all cells. It will only iterate the cells which have already been used. To create and iterate all cells in the worksheet use a For loop, iterating from 0 to one less than MaxExcelColumnCount, and pass in each index to the collection's indexer.

Requirements

Target Platforms: Android 4.4+, iOS 8+

Development Environments: Visual Studio 2015+, Visual Studio for Mac Preview, Xamarin for Visual Studio 4.2+

See Also