GrapeCity.Xaml.SpreadSheet.Data
LoadExcelOnDemand Property
Example 


GrapeCity.Xaml.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
 
<DefaultValueAttribute()>
Public Property LoadExcelOnDemand As Boolean
'Usage
 
Dim instance As Workbook
Dim value As Boolean
 
instance.LoadExcelOnDemand = value
 
value = instance.LoadExcelOnDemand
[DefaultValue()]
public bool LoadExcelOnDemand {get; set;}
Remarks
Rows and cell data are loaded as needed for display when the LoadExcelOnDemand property is true. Use the DataCalculated event to determine when all data has been loaded and calculated. Set the LoadExcelOnDemand property before loading an Excel-formatted file to speed up loading.
Example
This example uses the LoadExcelOnDemand property.
GcSpreadSheet1.Workbook.LoadExcelOnDemand=true;
GcSpreadSheet1.Workbook.LoadExcelOnDemand=True
See Also

Reference

Workbook Class
Workbook Members