Class RowCollection

Represents a collection of rows in a sheet.

Inheritance

object

RowCollection

Implements

INotifyCollectionChanged

IEnumerable<Row>

IEnumerable

Inherited Members

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

Namespace: DRIT.Spreadsheet

Assembly: DRIT.Spreadsheet.dll

Syntax

public class RowCollection : INotifyCollectionChanged, IEnumerable<Row>, IEnumerable

Properties

DefaultLength

Exposes the default length associated with RowCollection.

Declaration

protected double DefaultLength { get; }

Property Value

Type	Description
double	The default length returned by the operation.

Height

Sets the Height of all rows on the worksheet.

Declaration

public double Height { set; }

Property Value

Type	Description
double

this[int]

Provides indexed access to values in the RowCollection.

Declaration

public Row this[int index] { get; }

Parameters

Type	Name	Description
int	index

Property Value

Type	Description
Row	The this returned by the operation.

Workbook

Exposes the workbook associated with RowCollection.

Declaration

protected Workbook Workbook { get; }

Property Value

Type	Description
Workbook	The workbook returned by the operation.

Worksheet

Get the sheet which contains the current collection.

Declaration

public Worksheet Worksheet { get; }

Property Value

Type	Description
Worksheet

Methods

Autofit()

Exposes the autofit associated with RowCollection.

Declaration

public void Autofit()

Delete(int)

Removes the selected item from the RowCollection.

Declaration

public void Delete(int index)

Parameters

Type	Name	Description
int	index	The index used by the operation.

Delete(int, int)

Removes the selected item from the RowCollection.

Declaration

public void Delete(int fromIndex, int toIndex)

Parameters

Type	Name	Description
int	fromIndex	The from index used by the operation.
int	toIndex	The to index used by the operation.

GetEnumerator()

Retrieves the requested enumerator from the RowCollection.

Declaration

public IEnumerator<Row> GetEnumerator()

Returns

Type	Description
IEnumerator<Row>	The get enumerator returned by the operation.

GetRowIndexAtXPixels(double)

Retrieves the requested row index at xpixels from the RowCollection.

Declaration

public int GetRowIndexAtXPixels(double x)

Parameters

Type	Name	Description
double	x	The x used by the operation.

Returns

Type	Description
int	The get row index at xpixels returned by the operation.

Group(int, int, bool)

Exposes the group associated with RowCollection.

Declaration

public void Group(int fromIndex, int toIndex, bool collapse)

Parameters

Type	Name	Description
int	fromIndex	The from index used by the operation.
int	toIndex	The to index used by the operation.
bool	collapse	The collapse used by the operation.

Hide(int, int)

Exposes the hide associated with RowCollection.

Declaration

public void Hide(int fromIndex, int toIndex)

Parameters

Type	Name	Description
int	fromIndex	The from index used by the operation.
int	toIndex	The to index used by the operation.

Insert(int)

Adds the supplied ert to the RowCollection.

Declaration

public void Insert(int index)

Parameters

Type	Name	Description
int	index	The index used by the operation.

Insert(int, int)

Inserts an item at the specified index.

Declaration

public void Insert(int index, int number)

Parameters

Type	Name	Description
int	index
int	number	Number of rows to insert.

Ungroup(int, int)

Exposes the ungroup associated with RowCollection.

Declaration

public void Ungroup(int fromIndex, int toIndex)

Parameters

Type	Name	Description
int	fromIndex	The from index used by the operation.
int	toIndex	The to index used by the operation.

Events

CollectionChanged

Occurs when the collection changes.

Declaration

public event NotifyCollectionChangedEventHandler CollectionChanged

Event Type

Type	Description
NotifyCollectionChangedEventHandler

Implements

INotifyCollectionChanged

IEnumerable<T>

IEnumerable