OpenXml.Excel.Data.ExcelDataReader.ExcelDataReader C# (CSharp) Method

ExcelDataReader() public method

public ExcelDataReader ( Stream stream, int sheetIndex, bool firstRowAsHeader = true ) : System
stream Stream
sheetIndex int
firstRowAsHeader bool
return System
        public ExcelDataReader(Stream stream, int sheetIndex = 0, bool firstRowAsHeader = true)
        {
            _document = SpreadsheetDocument.Open(stream, false);
            _sharedStrings = GetSharedStrings(_document);

            var worksheetPart = _document.WorkbookPart.GetPartById(GetSheetByIndex(sheetIndex).Id.Value);
            _reader = OpenXmlReader.Create(worksheetPart);
            _headers = firstRowAsHeader ? GetFirstRowAsHeaders() : GetRangeHeaders(worksheetPart);
        }

Same methods

ExcelDataReader::ExcelDataReader ( Stream stream, string sheetName, bool firstRowAsHeader = true ) : System
ExcelDataReader::ExcelDataReader ( string path, int sheetIndex, bool firstRowAsHeader = true ) : System
ExcelDataReader::ExcelDataReader ( string path, string sheetName, bool firstRowAsHeader = true ) : System