I've two XSSFWorkbooks: *a* and *b*. For some reason I want to copy one or more Sheets from *a* into *b*. My solution is, that I create (one or more) XSSFSheet(s) in *b* and copy rows and cells (iterator) from corresponding *a*-Sheet into *b*-Sheet.
Ist it possible to copy the *a*-Sheet as an whole Object? Something like this: - open both Workbooks - clone a-Sheets that should be copied into *a*-Workbook - call setSheetOrder (String sheetName, int pos) to insert cloned Sheets into *a*-Workbook. I've tried it, but it doesn't work. -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Insert-a-XSSFSheet-form-XSSFWorkbook-a-into-XSSFWorkbook-b-tp4844338p4844338.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]
