poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Anthony Andrews <pythonadd...@yahoo.com>
Subject Re: merge worksheets from mutiple xls files
Date Wed, 27 Aug 2008 12:58:09 GMT
I have searched the archive and found this;


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 <suyash.jape@tcs.com> wrote:
From: Suyash Jape <suyash.jape@tcs.com>
Subject: Re: merge worksheets from mutiple xls files
To: "POI Users List" <user@poi.apache.org>
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.


gliao <gliao2000@gmail.com> 
27-08-2008 01:05
Please respond to
"POI Users List" <user@poi.apache.org>


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: 

Sent from the POI - User mailing list archive at Nabble.com.

To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org

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

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message