You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Oliver Stutz <ol...@bienli.com> on 2011/07/29 21:07:09 UTC
Editing Excel Sheets
Dear Helpers,
I have the following issue,
I have received a xls file from a friend and it is supposed to be a
template for peoples tent-setup places which my program should fill
automatically.
Now the problem iam having originally was with jxl ->
jxl.read.biff.BiffException: Unable to recognize OLE stream
While i couldn't figure out why it wasn't working i swapped over to
Apache POI. I had to figure out which libraries to import ect... took me
some time.
I figured it all out but before it worked i got this error
"java.io.IOException: Invalid header signature; read 0xE011BDBFEFBDBFEF,
expected 0xE11AB1A1E011CFD0" , i read that this was a "original xls
document" problem, i sent a friend my document, he opened it in ms excel
and sent me a copy of it back, still no changes. With open office i can
perfectly open the xls file iam trying to edit.
I have no clue why it isn't working
Has somebody an insight maybe even a solution what iam doing wrong?
Thanks alot,
Oliver
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: Editing Excel Sheets
Posted by Dave Fisher <da...@comcast.net>.
No problem. Thanks for letting us know.
Regards,
Dave
On Jul 29, 2011, at 2:14 PM, Oliver Stutz wrote:
> My Apologies, for this Mail, i wrote i bad copy function so that the target Excel File was corrupted.
>
> Problem resolved.
>
> Am 29.07.2011 21:07, schrieb Oliver Stutz:
>> Dear Helpers,
>>
>> I have the following issue,
>>
>> I have received a xls file from a friend and it is supposed to be a template for peoples tent-setup places which my program should fill automatically.
>>
>> Now the problem iam having originally was with jxl -> jxl.read.biff.BiffException: Unable to recognize OLE stream
>> While i couldn't figure out why it wasn't working i swapped over to Apache POI. I had to figure out which libraries to import ect... took me some time.
>>
>> I figured it all out but before it worked i got this error "java.io.IOException: Invalid header signature; read 0xE011BDBFEFBDBFEF, expected 0xE11AB1A1E011CFD0" , i read that this was a "original xls document" problem, i sent a friend my document, he opened it in ms excel and sent me a copy of it back, still no changes. With open office i can perfectly open the xls file iam trying to edit.
>>
>> I have no clue why it isn't working
>>
>> Has somebody an insight maybe even a solution what iam doing wrong?
>>
>> Thanks alot,
>>
>> Oliver
>>
>> ---------------------------------------------------------------------
>> 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
>
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: Editing Excel Sheets
Posted by Oliver Stutz <ol...@bienli.com>.
My Apologies, for this Mail, i wrote i bad copy function so that the
target Excel File was corrupted.
Problem resolved.
Am 29.07.2011 21:07, schrieb Oliver Stutz:
> Dear Helpers,
>
> I have the following issue,
>
> I have received a xls file from a friend and it is supposed to be a
> template for peoples tent-setup places which my program should fill
> automatically.
>
> Now the problem iam having originally was with jxl ->
> jxl.read.biff.BiffException: Unable to recognize OLE stream
> While i couldn't figure out why it wasn't working i swapped over to
> Apache POI. I had to figure out which libraries to import ect... took
> me some time.
>
> I figured it all out but before it worked i got this error
> "java.io.IOException: Invalid header signature; read
> 0xE011BDBFEFBDBFEF, expected 0xE11AB1A1E011CFD0" , i read that this
> was a "original xls document" problem, i sent a friend my document, he
> opened it in ms excel and sent me a copy of it back, still no changes.
> With open office i can perfectly open the xls file iam trying to edit.
>
> I have no clue why it isn't working
>
> Has somebody an insight maybe even a solution what iam doing wrong?
>
> Thanks alot,
>
> Oliver
>
> ---------------------------------------------------------------------
> 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