LoadStreamingMode Enum

Namespace:

GemBox.Spreadsheet

Assembly:

GemBox.Spreadsheet.dll

Represents a mode of streamlined loading of an ExcelFile.

• C#
• VB.NET

public enum LoadStreamingMode

Public Enum LoadStreamingMode

Fields

None

No streamlined loading of an ExcelFile. All rows of each ExcelWorksheet are loaded and held in memory.

Read

The ExcelFile is loaded in a streamlined fashion. A chunk of ExcelRows of each ExcelWorksheet are loaded and held in memory. If the requested ExcelRow is not in the loaded chunk, the currently loaded chunk is discarded and a chunk containing the requested ExcelRow is loaded and held in memory. When the ExcelFile is loaded in Read mode, the modification of rows, column collection, and cells (values, styles, formula) is not generally supported and might have unpredictable behavior.