Inaccurate column count causes data to be missed.

Dec 16, 2013 at 5:47 PM
I am trying to read in a large amount of data using your wonderful tool, which is ideal.
The problem is that the xlsx file in question has presumably been generated by a tool, as unless you manually open and then save and close the file, the ExcelDataReader will only read in the first column.

There are in fact 13 columns, but the first 2 rows are merged.

Having looked at the source code and stepped through, I can see that while reading the rows in, the array to hold the values is 1 in size, so all the following values are not saved, even though they are read in.

Any help would be much appreciated. :)
Developer
Dec 19, 2013 at 12:02 PM
I'm not sure if merged cells have been considered. I don't have capacity at the moment to figure it out, but it does sound like something that could be fixed.
I would recommend creating an issue. I won't be able to work on it for a few months at least though, so if you do figure it out it would be great if you can post the code in the issue, so we can eventually merge it into the code base.
A unit test that exposes the issue would be awesome.