Hi Javagee.

Look at

http://jakarta.apache.org/poi/hssf/how-to.html
.

There's a sample and a further link to the HSSF sample class. Just open
a file similar to what you see there and write it using a different
name.

Such warnings still can come if Excel files are "not so clean". We had
such problems when copying and changing Excel files instead of building
them from the scratch (just Excel, not using POI).

Regards,        Karl-Heinz.


-----Urspr�ngliche Nachricht-----
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Gesendet: Freitag, 27. August 2004 22:45
An: [EMAIL PROTECTED]
Betreff: HSSF copy workbook

I am very new to POI/HSSF. I need to copy a workbook that has a good bit
of formatting, formulas and a couple of macros. When I use standard
Input/Ouptut streams, and then try to use HSSF to modify the new file, I
see a lot of warnings like the following:


[WARNING] Unknown Ptg 2a (42) at cell (1,35)

Is POIFS a better way to copy a workbook? Can someone give me a quick
code snippet?

Thanks in advance.


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]




---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to