Does not return the last column

[robertovaldesperez]

Describe the bug
The file has 34 columns and only return 33 columns

To Reproduce
Steps to reproduce the behavior:

1. Read this file, tab "Collaterals"
   Project Atlas II - reducido.xlsx

Expected behavior
A clear and concise description of what you expected to happen.

Screenshots

Versions (please complete the following information):

• CSVHelper: [eg. 22.1.1]
• CSVHelper.Excel.Core: [eg. 22.1.1]

Additional context
The file being parsed.

[robertovaldesperez]

Hi @youngcm2 any idea why it doesn't return the last column?

[robertovaldesperez]

Hi @youngcm2 I need your help urgently, I am going to pass the application to production and I have this problem and I do not know how to solve it, there are files in which the number of columns does not return correctly?

File:
4_Project_MoMA_-BO_Datatape(Updated).xlsx

Thanks a lot

[youngcm2]

@robertovaldesperez Can you see if the latest release fixes your issue?

Released

• Releases: 27.2.1
• Nuget: 27.2.1

[Colodroid]

I have the same issue.
The problem is that if you have the first column empty, it skip the last one.

You need to remove the first column or add a "dummy" column at the end.

[chris-rp]

I've created a PR that fixes this issue.