Christian,
Yes the name was spelled "Sheet2" (minus the quotes) and I spelled it
correctly in my code. I'm certain that is not the problem because as I
tested I merely changed the index on the end of the name from 2 to 1 just
to write to the 1st sheet. These are the sheet names that Excel creates
automatically when starting a new workbook (Sheet1, Sheet2 and Sheet3). Try
my example verbatim on your system and tell me what you get. I'd be
interested to know. I've tried this all different ways. I used
getSheetAt(int idx), cloneSheet(int idx), and others. I've run through the
POI source in debug (I don't know if that response made it through my email
system here), everything I've done indicates that the POI API is just not
allowing a write to a brand new sheet. The sheet must be dirty first.
-Cliff
[EMAIL PROTECTED]
To: [EMAIL PROTECTED]
06/18/2003 02:54 cc:
PM Subject: Re: Cannot write to extra
sheets
Please respond to
"POI Users List"
Hi Craig,
just to be sure: when you created the template xls file, did it have the
2nd
sheet? If it did, was it exactly named "Sheet 2" (case-sensitive)?
If it didn't exist, you must create it, of course. The method name must be
something like wb.createSheet ("...")
HTH,
Christian
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
