Row and Column count mismatch

[Narayanasamy-Sudharsan]

We are parsing a spreadsheet that contains 47625 rows including a header row. The header row starts from column A to J. Below is the logic that we are using to load the spreadsheet.

using (var reader = ExcelReaderFactory.CreateReader(stream, new ExcelReaderConfiguration
{
Password ="Pwd"
}))
{
_logger.LogInformation("Read {Count} records from the CSV file", reader.RowCount);
reader.Read();

while (reader.Read())
{
    var userRecord = new Record
    {
        Id = reader.GetString(0),
        GUID = reader.GetString(1),
        Email = reader.GetString(2),
        Salutation = reader.GetString(3),
        FirstName = reader.GetString(4),
        LastName = reader.GetString(5),
        Type = reader.GetString(6),
        Reference = reader.GetString(7),
        Comp = reader.GetString(8)
        LastLogin = reader.GetString(9)
    };
    userRecords.Add(userRecord);
}

}

RowCount is getting logged as 47620 whereas we have 47624 excluding header row.
Also, the code reader.GetString(9) throws index out of exception though there are 9 columns.

Any idea on what I am doing wrong here ?

[appel1]

What kind of file is it you are reading?
Do you have a sample I can reproduce with?

[appel1]

Thanks, I'll take a look.

[appel1]

What version of ExcelDataReader did you test with?

Using ExcelDataReader 3.7.0 and your sample file it looks correct to me.

Using https://gist.github.com/appel1/4a2621e6b9f735cde2bcd376af791144 I got the following output:

> dotnet run excelcount.cs -- "TestFile.xlsx"
Sheet: Sheet1
Columns: 9
Rows: 47621

Sheet: Sheet2
Columns: 10
Rows: 47625

Sheet1:

Sheet2:

[Narayanasamy-Sudharsan]

It works as expected. I never noticed that there is one more sheet. BTW, please delete the test file from your end.

[Narayanasamy-Sudharsan]

@appel1 - Can you please confirm that you have deleted the test file from your end ?

[appel1]

@Narayanasamy-Sudharsan Yes, I've deleted the test file.