Cannot Read .xlsb file in .NET 7 about exceldatareader HOT 17 CLOSED

@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

from exceldatareader.

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

from exceldatareader.

@PanosKousidis,
Thank you for providing additional comments.

from exceldatareader.

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

from exceldatareader.

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.

from exceldatareader.

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?

from exceldatareader.

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.

from exceldatareader.

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.

from exceldatareader.

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?

from exceldatareader.

I'm sorry. I pressed the wrong button.

from exceldatareader.

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

from exceldatareader.

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

No, not yet. Hopefully next week.

from exceldatareader.

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

from exceldatareader.

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?

from exceldatareader.

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

from exceldatareader.

When it will available in Nuget as a prerelease?

from exceldatareader.

I'm also eagerly awaiting its prerelease on Nuget.

from exceldatareader.