Cannot Read .xlsb file in .NET 7

[rvdingDev]

Hello.
I am currently using the trial version of ExcelDataReader in order to read .xlsb files.
In the .NET Framework, reading .xlsb files is well supported, and no errors are seen in the .NET 7.0. However, data is not being properly read within the 'Watch' in the .NET 7.0.
I need help with this part.

I tried to create a reader object using CreateReader() and, made it as DataSet. I also tried to read one line at a time through Read() and read the value through GetValue(). But I can't get it to read properly.
If anything you can do to solve this problem in your current environment, I would greatly appreciate.

Thank you.

[appel1]

Do you get any exception or in what way does it not work?

[rvdingDev]

I'm not sure if I explained it properly because I'm not familiar with English.

I'm having an issue reading data from a Korean Excel file in a UTF-8 encoding environment.
Even though no exceptions are thrown, the Read() method and DataSet aren't functioning as expected.
The number of rows are correctly imported, but the values that should be in each cell are being read as DBNull. Also, while the number of columns are correctly imported, the column names aren't properly read. Instead, they're being generated as 'Column1', 'Column2', etc.

This issue occurs in .NET 7.0.
It worked correctly when I performed a unit test in the .NET Framework.

[appel1]

Could you provide me with a sample .xlsb file that reproduces this issue? The .xlsb files I've tried works with .NET 7.0.

Does .xlsx files in Korean work for you?

[rvdingDev]

I wanted to make a test file, but if I made the file myself, it worked really well. But the object is created as an OpenXmlReader object and is read.

I can't give you the file because the data is prohibited from leaking.
Files are contain many sheet references, file references, and column references in the company excel file.
But I'll show you the results of UnitTest.

I am importing the sheet called '#TargetDefine' in the .xlsb file, but the sheet is all written in English and there are no empty cells, and the column 'PatentName' is written in a formula, so I think it comes out properly. String is not working.

I tried cloned and debugged the repository.
The .xlsb file is created as an OpenXmlReader object without being read to the BinaryReader() method through the CreateReader() method, so the AsDataTable method itself.Value is null when proceeding GetValue(i)...

I'm not sure what to do.

Additionally, the .xlsx file works perfectly.

[rvdingDev]

I'm Sorry.
I'm trying to create a test file for replication, but it's not going well.
It seems like there are certain conditions that make it difficult.

[PanosKousidis]

@rvdingDev, @appel1
I ran into the same issue and traced it down to the breaking change introduced in .NET 6: https://learn.microsoft.com/en-us/dotnet/core/compatibility/core-libraries/6.0/partial-byte-reads-in-streams
The DeflateStream behaves differently now as it is more similar to the way the standard streams work.
I created the PR above that solves this issue - I wasn't able to produce a simple file with the problem, as the one I was using was pretty complex. But I think it happens when the sheet has a lot of data (my example had 81 rows 255 columns and it was only loading a few), due to the fact that the DeflateStream in BiffReader.cs returns less data than expected even if the stream is not finished

[appel1]

Thanks.

I thought I had fixed this as part of #621 but obviously it was not a complete fix.

Can ReadAtLeast be used here too?

[PanosKousidis]

Nice, it looks like you already addressed this issue but missed this bit. ReadAtLeast seems to be doing the job as well so that simplified the PR a lot

[rvdingDev]

@PanosKousidis,
Thank you for providing additional comments.

[rvdingDev]

I'm sorry. I pressed the wrong button.

[joydeep19]

Is this bug fixed,still I am facing this issue.

[appel1]

Is this bug fixed,still I am facing this issue.

No, not yet. Hopefully next week.

[joydeep19]

Can you let me know when this issue will resolve??

[stevie6410]

Hi, i've also just updated to .NET 7 from 5 and .xlsb is is broken for me too. v3.6.0 package.

Is there any workaround I can apply in the meantime?

[stevie6410]

Hi, I see the issue has been resolved and built. When does this package hit nuget as a pre-release?

[joydeep19]

When it will available in Nuget as a prerelease?

[rvdingDev]

I'm also eagerly awaiting its prerelease on Nuget.