Unknown records are not a problem. Please attach the files to a bug
(see last paragraph of
http://jakarta.apache.org/poi/getinvolved/index.html for instructions)
so that we can take a look.
There are a number of people using HSSF with Excel XP, so I don't think
thats the issue.
-Andy
Martin Lang wrote:
>I tried it, but without result.
>
>I do not get any exception. Closing the streams did not change anything
>(actually in the real program I closed them, just forgot it in this
>small excert). The issue with the currdir isn't really an issue because
>this is just an code snipped that extracts the problem an not the
>real program. When this works, it will be replaced by some arguments.
>
>So the question still remains. What is wrong here. In the meantime I
>tried to use BIFFViewer. When I run it on the Excel XP template file
>I get some undefined records. Does this mean that POI is incompatible
>with the new format?
>
>
>
>Thanx.
>
>
> Martin
>
>"Andrew C. Oliver" wrote:
>
>
>>Martin Lang wrote:
>>
>>
>>>Hi,
>>>
>>>When I run the following very simple progam and try to open the writen
>>>.xls file with Excel XP I get
>>>an error message saying that the file is corrupted and some formatting
>>>information may got lost.
>>>The error occurs only when the file I read in (template.xls) has been
>>>created with Excel XP. When
>>>I use a file that has been written by Excel 97 everything is o.k.
>>>
>>>Am I doing something wrong or is this a bug?
>>>
>>>
>>>
>>Issues
>>
>>1. Close your output stream. (and input stream too)
>>2. DO something with the IOException (you may be getting an
>>error!)...like e.printStackTrace().
>>3. Secondly, there is no guarantee that its reading "template.xls" from
>>the current directory or writing result.xls in the current directory
>>(currdir is not defined and is therefore not platform inspecific) ...
>>use a real path, suggest making use of args.
>>
>>-Andy
>>
>>
>>
>>>public static void main(String[] args) {
>>> HSSFWorkbook wb;
>>>
>>> try {
>>> FileInputStream template = new FileInputStream("template.xls");
>>> FileOutputStream result = new FileOutputStream(new
>>>File("result.xls"));
>>> POIFSFileSystem templatefs = new POIFSFileSystem(template);
>>> wb = new HSSFWorkbook(templatefs);
>>> wb.write(result);
>>> }
>>> catch (IOException e) {
>>> }
>>>
>>>
>>> }
>>>
>>>
>>>
>>>
>>>Dr. Martin Lang
>>>Cortex Brainware GmbH
>>>EMail: [EMAIL PROTECTED]
>>>
>>>
>>--
>>To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
>>For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
>>
>>
>
>--
>To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
>For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
>
>
>
>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
