Syntax
| Visual Basic (Declaration) | |
|---|---|
Public ReadOnly Default Property Item( _ ByVal index As Integer _ ) As AlternatingRow | |
| Visual Basic (Usage) |  Copy Code |
|---|---|
Dim instance As AlternatingRows Dim index As Integer Dim value As AlternatingRow value = instance.Item(index) | |
| C# | |
|---|---|
public AlternatingRow this[ int index ]; {get;} | |
Parameters
- index
- Index of the alternating row in the collection
Property Value
AlternatingRow object containing the specified alternating row styleExceptions
| Exception | Description |
|---|---|
| System.IndexOutOfRangeException | Specified alternating row index is less than 0 or greater than or equal to the alternating row count |
Remarks
The index is the zero-based index number of the AlternatingRow object in the collection. The index of the first row is 0. Subsequent indices are 1 for the second row, 2 for the third row, and so on.
Example
This example sets up three alternating rows and uses the Item property and its index to set change the background color of the rows. Note: In C#, the indexer is used instead of the Item property.
| C# | Copy Code |
|---|---|
FpSpread1.Sheets[0].AlternatingRows.Count = 3; FpSpread1.Sheets[0].AlternatingRows.Item[0].BackColor = Color.Red; FpSpread1.Sheets[0].AlternatingRows.Item[1].BackColor = Color.Blue; FpSpread1.Sheets[0].AlternatingRows.Item[2].BackColor = Color.Green; | |
| Visual Basic | Copy Code |
|---|---|
FpSpread1.Sheets(0).AlternatingRows.Count = 3 FpSpread1.Sheets(0).AlternatingRows.Parent(0).BackColor = Color.Red FpSpread1.Sheets(0).AlternatingRows.Parent(1).BackColor = Color.Blue FpSpread1.Sheets(0).AlternatingRows.Parent(2).BackColor = Color.Green | |
Requirements
Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6