Item Property (AlternatingRows)

Gets a new alternating row for the specified alternating row.

Syntax

Visual Basic
C#

'Declaration
 
Public ReadOnly Default Property Item( _
   ByVal index As Integer _
) As AlternatingRow

'Usage
 
Dim instance As AlternatingRows
Dim index As Integer
Dim value As AlternatingRow
 
value = instance.Item(index)

public AlternatingRow this[ 
   int index
]; {get;}

Parameters

index: Index of the alternating row (zero based)

Property Value

AlternatingRow object

Exceptions

Exception	Description
System.IndexOutOfRangeException	Specified alternating row index is less than 0 or greater than or equal to the alternating row count

Remarks

To create alternating rows, first set the AlternatingRows.Count property to specify the number of alternating row patterns, then set the properties for each pattern.

Example

This example changes the background color of the specified alternating row.

ColorDialog cd = new ColorDialog();

if (cd.ShowDialog() == DialogResult.OK)

{

fpSpread1.ActiveSheet.AlternatingRows[0].BackColor = cd.Color;

}

Visual Basic

Dim cd As New ColorDialog()

If cd.ShowDialog = DialogResult.OK Then

FpSpread1.ActiveSheet.AlternatingRows.Item(0).BackColor = cd.Color

End If

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

Reference

AlternatingRows Class
AlternatingRows Members

User-Task Documentation

Creating Alternating Rows