LoadExcelOnDemand Property

Gets or sets whether to load data on demand to reduce the time for opening an excel file.

Syntax

Visual Basic
C#

'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 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 sets the LoadExcelOnDemand property.

GcSpreadSheet1.Workbook.LoadExcelOnDemand=true;

VB.NET

GcSpreadSheet1.Workbook.LoadExcelOnDemand=True

Reference

Workbook Class
Workbook Members