Steve,

Yes, I tried the getSheetAt(int idx) method initially. I've tried various
renditions. Try my example on your system and tell me what you come out
with. I'm using POI version 1.8 but I have tried the latest version 2.0 and
got the same results.

-Cliff


                                                                                       
                                                
                      "Steve"                                                          
                                                
                      <[EMAIL PROTECTED]        To:       "POI Users List" <[EMAIL 
PROTECTED]>                                
                      M>                       cc:                                     
                                                
                                               Subject:  Re: Cannot write to extra 
sheets                                              
                      06/18/2003 03:00                                                 
                                                
                      PM                                                               
                                                
                      Please respond to                                                
                                                
                      "POI Users List"                                                 
                                                
                                                                                       
                                                
                                                                                       
                                                




perhaps you should not rely on the name being "Sheet2"
did you try it like this:
String sheetname = wb.getSheetName(sheetnumber);
HSSFSheet sheet = wb.getSheet(sheetname);


---------------------------------------------------------------------
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