Invalid sheet type in file

Questions and answers on how to use XLSReadWriteII 5.
Post Reply
bturcs
Posts: 23
Joined: Tue Nov 14, 2017 9:28 am

Invalid sheet type in file

Post by bturcs »

After I load an older excel file (xls) with VBA modules included, the xls reader is generating an exception. The problem is that substreams with type 6 are not handled in a case statement.

Image

This is disturbing. Proposal: just skip over that modules (or add an option to disable the exception). In XLSSUIT4, not exception was generated.
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

Re: Invalid sheet type in file

Post by larsa »

Hello

This must be an extremely old file (excel 4?). Please send me a file and I'll take a look at it.
Lars Arvidsson, Axolot Data
Post Reply