ExcelFile.VirtualMode Property
Set this value to true to turn Virtual Mode on. Look at 'Virtual mode' in the Performance Guide for more information.
Syntax
Namespace: FlexCel.Core
public Boolean VirtualMode { get; set; }
Examples
You can find a full example of Virtual mode in the sample: 10.API\22.Virtual Mode But here we will show a simpler example which reads only the first row of cells from the first sheet and then exits.
static void ReadFirstRowOfAllSheets(string fileName)
{
XlsFile xls = new XlsFile(); //Create the object but don't open the file yet.
xls.VirtualMode = true; //Set the mode to Virtual.
xls.VirtualCellRead += (sender, e) =>
{
if (e.Cell.Row > 1)
{
if (e.Cell.Sheet < e.SheetNames.Length) e.NextSheet = e.SheetNames[e.Cell.Sheet]; //Stop reading this sheet, move to the next.
else e.NextSheet = null; //Stop reading the file.
}
else
{
Console.WriteLine("Cell: " + new TCellAddress(e.SheetNames[e.Cell.Sheet - 1], e.Cell.Row, e.Cell.Col, false, false).CellRef);
Console.Write("Value: ");
Console.WriteLine(e.Cell.Value);
}
};
xls.Open(fileName);
}