AFAIK there is no built-in method to copy a sheet from one workbook into
another. So you had to do it manually. Just open two workbooks and manually
copy the data row by row from one sheet to another. Some hints can be found
at this stackoverflow post
http://stackoverflow.com/questions/13090313/how-to-copy-a-sheet-between-excel-workbooks-in-java-with-apache-poi.
Also in jxls code there is Util class which has methods like copySheets().
So if you end up using jxls library in your application you should be able
to utilize these methods as well.
But I am doubt you will be able to copy Charts as they have quite limited
support in POI. If you are dealing exclusively with .xlsx (xml) format of
excel files may be you could try some other dedicated libraries for this
format. They may have more options but I have not worked with them.
--
Regards,
Leo
On Mon, Apr 28, 2014 at 12:55 PM, Kadiyala, Srinivasa (US - Newton) <
srkadiy...@deloitte.com> wrote:
> Thanks Leo.
>
> Appreciate if you can confirm that you had used before POI for this kind
> of functionality need, and also point me to the API of POI that has this
> feature.
>
> Thanks again.
> --
> Naga
> (Srinivasa N Kadiyala)
> +1 617 678 9164
>
> From: Leo <leon...@gmail.com>
> Date: Monday, April 28, 2014 at 4:22 AM
> To: Srinivasa Kadiyala <srkadiy...@deloitte.com>
> Cc: "jxls-user@lists.sourceforge.net" <jxls-user@lists.sourceforge.net>
> Subject: Re: [jXLS-user] Merging multiple XLS files into one XLS file
>
> Hi,
>
> You probably have to use POI API to do this kind of merge.
>
> --
> Regards,
> Leo
>
>
> On Mon, Apr 28, 2014 at 7:41 AM, Kadiyala, Srinivasa (US - Newton) <
> srkadiy...@deloitte.com> wrote:
>
>> I have recently joined the group.
>>
>> I want to have multiple XLS report files with charts be merged into
>> one XLS file with multiple worksheets.
>>
>> For example I have file1.xlsx with 3 worksheets with charts, and
>> file2.xlsx with two worksheets having charts. The merged file should be
>> file3.xlsx with 5 sheets having 3 from file1 and 2 from file 2.
>>
>> This is to be done by application using java.
>>
>> Appreciate if jXLS is the right choice for this case.
>>
>> Thanks in advance.
>>
>>
>> --
>> Naga
>> (Srinivasa N Kadiyala)
>> +1 617 678 9164
>>
>>
>>
>>
>> This message (including any attachments) contains confidential
>> information intended for a specific individual and purpose, and is
>> protected by law. If you are not the intended recipient, you should delete
>> this message and any disclosure, copying, or distribution of this message,
>> or the taking of any action based on it, by you is strictly prohibited.
>>
>> v.E.1
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> ------------------------------------------------------------------------------
>> "Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
>> Instantly run your Selenium tests across 300+ browser/OS combos. Get
>> unparalleled scalability from the best Selenium testing platform
>> available.
>> Simple to use. Nothing to install. Get started now for free."
>> http://p.sf.net/sfu/SauceLabs
>> _______________________________________________
>> jXLS-user mailing list
>> jXLS-user@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/jxls-user
>>
>>
>
------------------------------------------------------------------------------
"Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
Instantly run your Selenium tests across 300+ browser/OS combos. Get
unparalleled scalability from the best Selenium testing platform available.
Simple to use. Nothing to install. Get started now for free."
http://p.sf.net/sfu/SauceLabs
_______________________________________________
jXLS-user mailing list
jXLS-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jxls-user
