Nevron Open Vision Documentation
Nevron.Nov.Formats.Excel Namespace / NExcelReader Class / ReadRange Method
The System.IO.Stream from which to read the Excel data.
The name of the sheet that contains the data.
The range of cells in Excel annotaion.

For example "A1:G20"

Indicates whether the first row of each table contains column names.


In This Topic
    ReadRange Method
    In This Topic
    Reads a range of cells from the provided stream.
    Syntax
    'Declaration
     
    
    Public Shared Function ReadRange( _
       ByVal stream As System.IO.Stream, _
       ByVal sheetName As System.String, _
       ByVal range As System.String, _
       ByVal headerRow As System.Boolean _
    ) As NDataSet
    'Usage
     
    
    Dim stream As System.IO.Stream
    Dim sheetName As System.String
    Dim range As System.String
    Dim headerRow As System.Boolean
    Dim value As NDataSet
     
    value = NExcelReader.ReadRange(stream, sheetName, range, headerRow)
    public static NDataSet ReadRange( 
       System.IO.Stream stream,
       System.string sheetName,
       System.string range,
       System.bool headerRow
    )

    Parameters

    stream
    The System.IO.Stream from which to read the Excel data.
    sheetName
    The name of the sheet that contains the data.
    range
    The range of cells in Excel annotaion.

    For example "A1:G20"

    headerRow
    Indicates whether the first row of each table contains column names.

    Return Value

    An Nevron.Nov.Data.NDataSet with a table for each Excel sheet.
    Requirements

    Target Platforms: Windows 11, Windows 10, Windows 7, Windows Server 2019, Windows Server 2016, Windows Server 2012 R2, Windows Server 2012, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later)

    See Also