private void ParseStream() { byte[] bytes; using (var fileStream = new FileStream(ExcelImport.FullName, FileMode.Open)) { bytes = fileStream.ReadFully(); } using (var stream = ExcelImport.GetXlsContent(ExcelImport.FullName, bytes)){ using (var excelDataReader = ExcelReaderFactory.CreateReader(stream)){ ExcelImport.SheetNames = excelDataReader.Sheets().ToList(); } } }
private void ParseStream(UploadedFile uploadedFile) { using (var stream = ExcelImport.GetXlsContent(uploadedFile.FileName, uploadedFile.FileBytes)){ var temp = new DirectoryInfo(Path.GetTempPath()); temp = temp.CreateSubdirectory(Application.Title); var path = Path.Combine(temp.FullName, $"{ExcelImport.Oid}{Path.GetExtension(uploadedFile.FileName)}"); using (var fileStream = File.Create(path)){ stream.CopyTo(fileStream); } using (var excelDataReader = ExcelReaderFactory.CreateReader(stream)){ ExcelImport.SheetNames = excelDataReader.Sheets().ToList(); } } }