Class RowCollection
Represents a collection of rows in a sheet.
Inheritance
System.Object
RowCollection
Assembly: DRIT.Spreadsheet.dll
Syntax
public class RowCollection : INotifyCollectionChanged, IEnumerable<Row>
Properties
DefaultLength
Declaration
protected double DefaultLength { get; }
Property Value
| Type |
Description |
| System.Double |
|
Height
Sets the Height of all rows on the worksheet.
Declaration
public double Height { set; }
Property Value
| Type |
Description |
| System.Double |
|
Item[Int32]
Declaration
public Row this[int index] { get; }
Parameters
| Type |
Name |
Description |
| System.Int32 |
index |
|
Property Value
Workbook
Declaration
protected Workbook Workbook { get; }
Property Value
Worksheet
Get the sheet which contains the current collection.
Declaration
public Worksheet Worksheet { get; }
Property Value
Methods
Autofit()
Declaration
Delete(Int32)
Declaration
public void Delete(int index)
Parameters
| Type |
Name |
Description |
| System.Int32 |
index |
|
Delete(Int32, Int32)
Declaration
public void Delete(int fromIndex, int toIndex)
Parameters
| Type |
Name |
Description |
| System.Int32 |
fromIndex |
|
| System.Int32 |
toIndex |
|
GetEnumerator()
Declaration
public IEnumerator<Row> GetEnumerator()
Returns
| Type |
Description |
| IEnumerator<Row> |
|
GetRowIndexAtXPixels(Double)
Declaration
public int GetRowIndexAtXPixels(double x)
Parameters
| Type |
Name |
Description |
| System.Double |
x |
|
Returns
| Type |
Description |
| System.Int32 |
|
Group(Int32, Int32, Boolean)
Declaration
public void Group(int fromIndex, int toIndex, bool collapse)
Parameters
| Type |
Name |
Description |
| System.Int32 |
fromIndex |
|
| System.Int32 |
toIndex |
|
| System.Boolean |
collapse |
|
Hide(Int32, Int32)
Declaration
public void Hide(int fromIndex, int toIndex)
Parameters
| Type |
Name |
Description |
| System.Int32 |
fromIndex |
|
| System.Int32 |
toIndex |
|
Insert(Int32)
Declaration
public void Insert(int index)
Parameters
| Type |
Name |
Description |
| System.Int32 |
index |
|
Insert(Int32, Int32)
Declaration
public void Insert(int index, int number)
Parameters
| Type |
Name |
Description |
| System.Int32 |
index |
|
| System.Int32 |
number |
Number of rows to insert.
|
Ungroup(Int32, Int32)
Declaration
public void Ungroup(int fromIndex, int toIndex)
Parameters
| Type |
Name |
Description |
| System.Int32 |
fromIndex |
|
| System.Int32 |
toIndex |
|
Events
CollectionChanged
Occurs when the collection changes.
Declaration
public event NotifyCollectionChangedEventHandler CollectionChanged
Event Type
| Type |
Description |
| NotifyCollectionChangedEventHandler |
|
Implements
IEnumerable<>