Spread Windows Forms 11.0 Product Documentation
Workbook Property
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > ChildWorkbookCreatedEventArgs Class : Workbook Property
Gets the child SpreadView object being created.
Syntax
'Declaration
 
Public ReadOnly Property Workbook As SpreadView
'Usage
 
Dim instance As ChildWorkbookCreatedEventArgs
Dim value As SpreadView
 
value = instance.Workbook
public SpreadView Workbook {get;}

Property Value

SpreadView object containing the child view
Example
This example changes the back color of the alternating rows in the workbook.
fpSpread1.ChildWorkbookCreated += new FarPoint.Win.Spread.ChildWorkbookCreatedEventHandler(fpSpread1ChildWorkbookCreated);

private void fpSpread1ChildWorkbookCreated(object sender, FarPoint.Win.Spread.ChildWorkbookCreatedEventArgs e)
{
      e.Workbook.Sheets[e.Workbook.ActiveSheetIndex].AlternatingRows[0].BackColor = Color.Yellow;
}
Dim eh As FarPoint.Win.Spread.ChildWorkbookCreatedEventHandler = AddressOf FpSpread1ChildWorkbookCreated
AddHandler FpSpread1.ChildWorkbookCreated, eh

Private Sub FpSpread1ChildWorkbookCreated(ByVal sender As Object, ByVal e As FarPoint.Win.Spread.ChildWorkbookCreatedEventArgs)
Handles FpSpread1.ChildWorkbookCreated
      e.Workbook.Sheets(e.Workbook.ActiveSheetIndex).AlternatingRows(0).BackColor = Color.Yellow
End Sub
See Also

Reference

ChildWorkbookCreatedEventArgs Class
ChildWorkbookCreatedEventArgs Members