public SheetReader(Stream sheetXmlStream, XslxSharedStringsStream xlsxSharedStringsStream,
XslxIsDateTimeStream xlsxIsDateTimeStream)
{
_xlsxSharedStringsStream = xlsxSharedStringsStream;
_xlsxIsDateTimeStream = xlsxIsDateTimeStream;
_values = new Dictionary <string, object>();
_xmlReader = XmlReader.Create(sheetXmlStream);
GetDimension();
}
private void Initialize()
{
_archive = new ZipArchive(_fileStream, ZipArchiveMode.Read);
//CSH 28012020 - We order by the length of the name string then by the name itself, so that Sheet10 appears immediately
//after Sheet9 rather than after Sheet1
_worksheetEntries = _archive.Entries.Where(x => x.FullName.StartsWith("xl/worksheets/sheet"))
.OrderBy(x => x.Name.Length)
.ThenBy(x => x.Name)
.ToArray();
SharedStringsStream =
new XslxSharedStringsStream(
_archive.Entries.First(x => x.FullName.EndsWith("sharedStrings.xml")).Open());
IsDateTimeStream =
new XslxIsDateTimeStream(_archive.Entries.First(x => x.FullName.EndsWith("styles.xml")).Open());
}