Re: Help using XLPARSER4

[Scott Klement <rpg400-l@xxxxxxxxxxxxxxxx>]

Hi Jeff,

Jeff Young wrote:
> When I modified it for my application, I received the following error:
> "java.io.FileNotFoundException: no such entry: "Workbook"" 


This error means that it *did* find your IFS file, but it can't find a 
workbook object inside of it.

You see, Microsoft Office documents are actually archives in themselves 
-- much like a ZIP file or SAVF.  They are archives of one or more 
internal files.  So within your XLS file will be other, internal, files 
that contain the spreadsheet, charts, images, etc... all the stuff that 
can be placed in a spreadsheet.

So when it says 'no such entry: Workbook" that means that it's looking 
for the Excel workbook inside the XLS archive.  And it's not finding it, 
which isn't good.

Either the file it's reading isn't a valid Excel file (for example, a 
Word document, or a PowerPoint document uses the exact same archive 
format, but wouldn't have a 'Workbook' object because it's not an Excel 
spreadsheet) -- or the file has been damaged somehow.  Perhaps it was 
cut off during file transfer?  Or perhaps your file transfer software 
attempted an ASCII -> EBCDIC conversion, which would've corrupted the 
file?  Or perhaps it's an Excel format, but created from a version of 
Excel that HSSF doesn't understand?

Hard to say.  I've never encountered this error in my own work... 
everything I say above comes from searching the web for the error 
message you posted...