I have searched the archive and found this; http://jxls.cvs.sourceforge.net/jxls/jxls/src/java/org/jxls/util/Util.java?view=markup
Do not know if it is exactly what you require and I have not tested it my self but it may be worth a look. Otherwise, as another poster has suggested, you will have to code your own method that copies across the cells one by one from one sheet to another. --- On Tue, 8/26/08, Suyash Jape <[EMAIL PROTECTED]> wrote: From: Suyash Jape <[EMAIL PROTECTED]> Subject: Re: merge worksheets from mutiple xls files To: "POI Users List" <[email protected]> Date: Tuesday, August 26, 2008, 8:41 PM As far as i have searched, you may have to copy the cells row wise for each sheet into the target workbook. There doesnt seem to be a copy sheet function for the workbook. Regards Suyash gliao <[EMAIL PROTECTED]> 27-08-2008 01:05 Please respond to "POI Users List" <[email protected]> To [email protected] cc Subject merge worksheets from mutiple xls files I want to merge worksheets from multiple xls files into a single workbook with all those sheets. I can't find POI API to implement that. Any suggestion? Thanks. -- View this message in context: http://www.nabble.com/merge-worksheets-from-mutiple-xls-files-tp19168828p19168828.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] ForwardSourceID:NT0000691E =====-----=====-----===== Notice: The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this communication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the message and any attachments. Thank you
