Found EOFRecord before WindowTwoRecord was encountered

[CDB <cb...@burkeitconsulting.com>]

I am attempting text extraction and get the following error:

Java.lang.RuntimeException:  Found EOFRecord before WindowTwoRecord was
encountered
At 
org.apache.poi.hssf.model.RecordOrderer.isEndOfRowBlock(RecordOrderer.java:4
26)

Is this an improperly formatted excel document?

Thanks

Re: Found EOFRecord before WindowTwoRecord was encountered

[CDB <cb...@burkeitconsulting.com>]

Thanks Mark

This is a client file listing and I only have readonly privileges.
I recall someone saying there are legacy SAP files in the listing.

I will look at the validation tool as well as writing a utility to read
and write the excel file.






On 5/28/12 3:17 AM, "Mark Beardsley" <ma...@tiscali.co.uk> wrote:

>It might be. There are a few things you could do.
>
>Firstly, open the file using Excel and then simply re-save it. Does this
>clear up the problem? If so then yes, it is likely that the file does not
>conform with the specification.
>
>Secondly, there is a file validation tool that you can use -
>http://technet.microsoft.com/en-us/library/53782285-736e-4d00-b458-6170054
>287af.aspx
>- to check the file to ensure it conforms to the file spec. This is a
>Microsoft tool of course
>
>Where does the file come from? Rather, do you know how the file is
>created?
>Did the author use Excel or some third party tool to build the file? There
>are a few and I know of at least one - I think produced by SAP but long
>since orphaned - that does have issues. If you can find out how the file
>is
>created, that cold help the developers address this problem.
>
>Finally, can you submit the troublesome file so that the developers can
>take
>a look at it?
>
>--
>View this message in context:
>http://apache-poi.1045710.n5.nabble.com/Found-EOFRecord-before-WindowTwoRe
>cord-was-encountered-tp5709947p5709953.html
>Sent from the POI - User mailing list archive at Nabble.com.
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
>For additional commands, e-mail: user-help@poi.apache.org
>
>



---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org

Re: Found EOFRecord before WindowTwoRecord was encountered

[Mark Beardsley <ma...@tiscali.co.uk>]

It might be. There are a few things you could do.

Firstly, open the file using Excel and then simply re-save it. Does this
clear up the problem? If so then yes, it is likely that the file does not
conform with the specification.

Secondly, there is a file validation tool that you can use -
http://technet.microsoft.com/en-us/library/53782285-736e-4d00-b458-6170054287af.aspx
- to check the file to ensure it conforms to the file spec. This is a
Microsoft tool of course 

Where does the file come from? Rather, do you know how the file is created?
Did the author use Excel or some third party tool to build the file? There
are a few and I know of at least one - I think produced by SAP but long
since orphaned - that does have issues. If you can find out how the file is
created, that cold help the developers address this problem.

Finally, can you submit the troublesome file so that the developers can take
a look at it?

--
View this message in context: http://apache-poi.1045710.n5.nabble.com/Found-EOFRecord-before-WindowTwoRecord-was-encountered-tp5709947p5709953.html
Sent from the POI - User mailing list archive at Nabble.com.

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org