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();
}
}
}
