CellRange CellList Property |
Returns a Range object that represents the cells in the specified range.
Examples
Examples
The following code illustrates how to access CellList property of the Range:
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Set text. The content contained by ![CDATA[]] will be expressed as plain text</para><para>ListCellRange cells = worksheet["A1:E8"].CellList;</para><para>//Do some manipulations</para><para>foreach (CellRange Range in cells)</para><para>Range.Text = Range.RangeAddressLocal;</para><para>//Save to file</para><para>workbook.SaveToFile("CellList.xlsx");</para>
Namespace: Spire.Xls
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
See Also
