This project is read-only.
1
Vote

excel data reader does not allow to read excel file simultaneously

description

Hi,

I am using excel data reader for reading excel files simultaneously using some queueing mechnism.
I am facing below mentioned issue when two excel files have same data. I have tried to dig into code of excel data reader and may be the problem is at logger level. I tried to put lock before ExcelReaderFactory.CreateOpenXmlReader and it resolved below issue but then it does not allow to read
excel files simultaneously as it locks one file and starts to read new only when first is done. (as ExcelReaderFactory is a static class)

--------------Below is error details ----------------------------

ArgumentException
at System.Collections.Generic.Dictionary2.Insert(TKey key, TValue value, Boolean add)
at Excel.Log.LogManager.Log(String objectName) in LogManager.cs: line 48
at Excel.Core.ZipWorker.NewTempPath() in c:\development\ExcelDataReader\Excel\Core\ZipWorker.cs: line 250
at Excel.Core.ZipWorker.Extract(Stream fileStream) in c:\development\ExcelDataReader\Excel\Core\ZipWorker.cs: line 86
at Excel.ExcelOpenXmlReader.Initialize(Stream fileStream) in c:\development\ExcelDataReader\Excel\ExcelOpenXmlReader.cs: line 335
at Excel.ExcelReaderFactory.CreateOpenXmlReader(Stream fileStream) in c:\development\ExcelDataReader\Excel\ExcelReaderFactory.cs: line 76
at Elastic.Infrastructure.Data.File.Parsers.ExcelOpenXmlStreamReader
2.<Read>d__0.MoveNext() in ExcelOpenXmlStreamReader.cs: line 34
at System.Collections.Generic.List1..ctor(IEnumerable1 collection)
at System.Linq.Enumerable.ToList(IEnumerable`1 source)
at Elastic.Infrastructure.Data.File.Tests.ExcelOpenXmlStreamReaderTests.<>c__DisplayClass2.<CanIterateThrough2XlsFilesInParallel>b__0() in ExcelOpenXmlStreamReaderTests.cs: line 42

at System.Threading.Tasks.Task.Execute()

Please do the needful asap.

Thanks & Regards,
Vibhuti

comments