You do not say which strand of POI you are using; HSSF or XSSF. So I am going to assume you are using HSSF as that is the one I am most familiar with and, even if not, I hope this points you in the right direction.
I have never tried this so let me explain my reasoning firstly please. The HSSFWorkbook object holds references to 'it's' sheets in a List. So, even if you add a sheet to an existing workbook, all you need to do is instruct the workbook to move it to an appropriate position in this List. Assuming that is true, take a look at the setSheetOrder(java.lang.String sheetname, int pos) method defined on the HSSFWorkbook class. It seems to me that you will need to do the following; Open the workbook. Create a new sheet and give it name. Populate the sheet. Call the setSheetOrder() method on the workbook, pass the name of the newly created sheet and the position it should appear in - remember that positions are zero based! The third and fourth steps could of course be transposed as long as you hang on to a reference for the sheet. PS, I have just checked on the javadoc for the XSSFWorkbook class and the same method does appear. This technique should work for both the binary and OpenXML Excel files. Liu, Mark wrote: > > Can't seem to find a way in insert a Sheet into a workbook. Is there a > work around for this? > > > > Thanks, > > Mark > > > > > -- View this message in context: http://www.nabble.com/Insert-Sheet-into-Workbook-tp23642646p23648977.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]
