Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

After upgrading to v2.10.0, first column of data is always null #682

Closed
AlonCG opened this issue Feb 13, 2020 · 0 comments
Closed

After upgrading to v2.10.0, first column of data is always null #682

AlonCG opened this issue Feb 13, 2020 · 0 comments

Comments

@AlonCG
Copy link

@AlonCG AlonCG commented Feb 13, 2020

Description

I inherited code that parses an Excel file and inserts the data in to a DataTable. I understand that this has been working for more than 5 years with very little changes in code. (I am sure there are many suggestions to make it better, but that is not the issue.) Upon updating to DocumentFormat.OpenXml version 2.10.0, the first column of data is always null. I was unable to find breaking changes in OpenXML that was need to be changed, and was hoping you could point me in the right direction to find a resolution.

Information

  • .NET Target: (.NET Core)
  • DocumentFormat.OpenXml Version: 2.10.0

Repro

OpenDoc Issues.zip

I have included 2 LinqPad 5 documents that use exactly the same internal code (copied from our existing class library); one targeting OpenXml 2.9.1 and the other targeting 2.10.0 ... along with a data file. If you are able to run it, make sure you update the path to the test data file. Just run the page to observe the different results.

Note: Apologies for using LinqPad, I just find this an easy code playground and I have not written a console/windows application in a number of years.

Observed

First column (RespondentID) of data is null.

Expected

First column of data should contain the values in the excel spreadsheet.

@AlonCG AlonCG closed this Feb 13, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
1 participant
You can’t perform that action at this time.