i got the same thing with poi-3.5-beta4-20081128.jar
best regards.
hicham
---------------------------------------------------------------
rahali wrote:
>
> i devlope a j2ee application with struts2 and jsp2 technology, i'm under
> xp service pack2, and my browsers are firfox, IE.
>
> *my IDE is eclipse 3.2.1.
>
> my java code is :
>
> String fs = System.getProperty("file.separator");
>
> POIFSFileSystem fs1 = new POIFSFileSystem(new FileInputStream(
> ServletActionContext.getServletContext().getRealPath("") + fs +
> "template" + fs + fileName));
> HSSFWorkbook wb1 = new HSSFWorkbook(fs1, true);
>
> pResponse.setHeader("Content-Disposition",
> "attachment;filename="+fileName);
> pResponse.setContentType("application/vnd.ms-excel");
> // Write the output
> OutputStream out = pResponse.getOutputStream();
> wb1.write(out);
> out.close();
>
> i want just to load a file from my browser.
>
> the input file hase colors, styles, borders .... (formattting)
>
> but the output file lost its formatting.
>
> accuelly, am using poi-3.0-alpha2-20060616.jar
>
> i found that, others have the same probleme:
> http://www.nabble.com/XSSFWoorkbook.write()-problem-td21071450.html
>
>
> to circumvent my problem : I associate xls extension to OpenOffice.
> then, when i load the file, its opened with OpenOffice.
>
>
>
> --------------------------------------------------
>
> David Fisher wrote:
>>
>> I wonder if the problem is not with POI.
>>
>>> i laod my excel file with httpresponse and, my file lose the format,
>>> i got a
>>> message where the Ms Excel informe me that this file is endomaged.
>>> but the
>>> file is opened with MsExcel 2000 and openOffice.
>>
>> Tell us about your workflow.
>>
>> (1) Are you making your HTTP request from within Excel and OpenOffice,
>> or are you making the request in a Browser like Internet Explorer and
>> then saving the file?
>>
>> (2) What servlet container do you use? What version?
>>
>> (3) Are you using a servlet or a JSP?
>>
>> JSPs are meant for Text only and you get in trouble if you don't have
>> every "%>" immediately followed by a "<%". If you have this:
>>
>> .... %>
>> <% ....
>>
>> before your code then JSP will send a whitespace character in the
>> response and this could certainly cause trouble.
>>
>> You can see if you use Josh's command but with the url you use to hit
>> your server.
>>
>> curl -s http://localhost:8080/yourwebapps/yourtemplaterequest |
>> hexdump -n 8 -e
>>
>> (4) Does your url end with ".xls"?
>>
>> Older version of windows and IE seem to require this help. We used to
>> add an extra parameter to the request to fix the issue.
>>
>> HTH,
>> Dave
>>
>> On Jan 30, 2009, at 4:29 PM, Josh Micich wrote:
>>
>>> Hello Hicham,
>>>
>>> The two files you uploaded open OK in POI (i.e.
>>> WorkbookFactory.create()
>>> completes normally).
>>>
>>>> I do not know how to verify the spreadsheet formats
>>> You can also check the initial bytes of these files easily from a unix
>>> prompt with something like this:
>>>
>>> $ curl -s http://www.nabble.com/file/p21746193/input.xls | hexdump -
>>> n 8 -e
>>> '16/1 "%02X " "\n"'
>>> D0 CF 11 E0 A1 B1 1A E1
>>>
>>> $ curl -s http://www.nabble.com/file/p21746193/outout+2+.xls |
>>> hexdump -n 8
>>> -e '16/1 "%02X " "\n"'
>>> D0 CF 11 E0 A1 B1 1A E1
>>>
>>> These 8 bytes are consistent what is expected in the 'Microsoft
>>> Compound
>>> Document' format. This is expected since POI didn't report an error.
>>>
>>> I am having trouble understanding what the exact problem is. I tried
>>> opening the two files in Excel (2007) and that was OK too.
>>>
>>> regards,
>>> Josh
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: [email protected]
>> For additional commands, e-mail: [email protected]
>>
>>
>>
>
>
--
View this message in context:
http://www.nabble.com/Can%27t-read-excel-2003-xls-file-tp21328806p21758404.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
