Cannot read text from .xls

Question

Cannot read text from .xls

Closed this issue 2 years ago · 6 comments

.xls files stops working when upgrading from 1.5.4 to 1.7.7

using (var reader = new FilterReader("c:\\f.xls"))
{
    return reader.ReadToEnd();
}

This code throws an exception in the new version.
System.Runtime.InteropServices.InvalidComObjectException : COM object that has been separated from its underlying RCW cannot be used.

Is there anything I can do to get it working again?

f.xls

Answer 1 · 2022-11-21T15:35:56.000Z

I think the change of behaviour was introduced in 4c1a92710f54ed2ef9c68e92afc37891385c5fa6 as I fixed the same error in the commit before. b7cbfb6#diff-98f8d2a52cc406bf5b2217e1262af63e842568fead3552cdce102714332b195b

Answer 2 · 2022-11-21T15:49:01.000Z

Let me check the code with your file to see what kind of error I get... give me a minute

Answer 3 · 2022-11-21T15:51:19.000Z

Did you get this as an error? COM object that has been separated from its underlying RCW cannot be used.

Answer 4 · 2022-11-21T15:53:40.000Z

There seems to be something wrong with the file, when I open it in Excel and save it again it works without any problems

Answer 5 · 2022-11-21T16:06:19.000Z

Fixed... just get the latest nuget package

Answer 6 · 2022-11-21T18:57:12.000Z

Thanks for fixing this 👍