Spread WPF Documentation
LoadExcelOnDemand Property
Example 


GrapeCity.Windows.SpreadSheet.Data Namespace > Workbook Class : LoadExcelOnDemand Property
Gets or sets whether to load data on demand to reduce the time for opening an excel file.
Syntax
'Declaration
 
<System.ComponentModel.DefaultValueAttribute()>
Public Property LoadExcelOnDemand As System.Boolean
'Usage
 
Dim instance As Workbook
Dim value As System.Boolean
 
instance.LoadExcelOnDemand = value
 
value = instance.LoadExcelOnDemand
[System.ComponentModel.DefaultValue()]
public System.bool LoadExcelOnDemand {get; set;}
Remarks
Rows and cell data are loaded as needed for display. Use the DataCalculated event to determine when all data has been loaded and calculated. Set this property before loading an Excel-formatted file to speed up loading.
Example
This example sets the LoadExcelOnDemand property.
GcSpreadSheet1.Workbook.LoadExcelOnDemand=true;
GcSpreadSheet1.Workbook.LoadExcelOnDemand=True
See Also

Reference

Workbook Class
Workbook Members