You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by Manivannan G <ma...@hcl.com> on 2018/10/16 05:19:28 UTC
Reg :- Excel merge two different sheet
Hi Team,
I am facing some problem while merging two different excel sheet data to one excel sheet using XSSFWorkbook api using poi-3.17.jar, using this api I am able to merge the different excel sheet data to one sheet but it is taking so much time execute.
For example sheet1 contains 15000 records and sheet2 contains only 100 records , to merge these two sheet taking more than one hour time, it is very slow.
And I have tried to use SXSSFWorkbook api, but I am not able to update/merge two different sheet data, I have gone though some side they are saying it is only writing purpose, not for read or update.
Could you please suggest me how to handle this, let me know any sample code
Scenarios like below.
1. Excel1- Sheet1 contains 10000 row of data
2. Excel2- Sheet1 contains 2000 row of data
3. Need to merge in new Excel3 -Sheet1 .. records like first 10000 then 10001 to 12000 row data.
Thanks & Regards,
Manivannan. G
Mobile #:- 91-8015775021
::DISCLAIMER::
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only. E-mail transmission is not guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or may contain viruses in transmission. The e mail and its contents (with or without referred errors) shall therefore not attach any liability on the originator or HCL or its affiliates. Views or opinions, if any, presented in this email are solely those of the author and may not necessarily reflect the views or opinions of HCL or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without the prior written consent of authorized representative of HCL is strictly prohibited. If you have received this email in error please delete it and notify the sender immediately. Before opening any email and/or attachments, please check them for viruses and other defects.
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Re: Reg :- Excel merge two different sheet
Posted by Jörn Franke <jo...@gmail.com>.
Do you have some code ?
are these xlsx sheets?
How many columns are filled?
Are you doing formula evaluation?
> Am 16.10.2018 um 07:19 schrieb Manivannan G <ma...@hcl.com>:
>
> Hi Team,
>
> I am facing some problem while merging two different excel sheet data to one excel sheet using XSSFWorkbook api using poi-3.17.jar, using this api I am able to merge the different excel sheet data to one sheet but it is taking so much time execute.
>
> For example sheet1 contains 15000 records and sheet2 contains only 100 records , to merge these two sheet taking more than one hour time, it is very slow.
>
> And I have tried to use SXSSFWorkbook api, but I am not able to update/merge two different sheet data, I have gone though some side they are saying it is only writing purpose, not for read or update.
>
> Could you please suggest me how to handle this, let me know any sample code
>
> Scenarios like below.
>
> 1. Excel1- Sheet1 contains 10000 row of data
> 2. Excel2- Sheet1 contains 2000 row of data
> 3. Need to merge in new Excel3 -Sheet1 .. records like first 10000 then 10001 to 12000 row data.
>
> Thanks & Regards,
> Manivannan. G
> Mobile #:- 91-8015775021
>
> ::DISCLAIMER::
> --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
> The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only. E-mail transmission is not guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or may contain viruses in transmission. The e mail and its contents (with or without referred errors) shall therefore not attach any liability on the originator or HCL or its affiliates. Views or opinions, if any, presented in this email are solely those of the author and may not necessarily reflect the views or opinions of HCL or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without the prior written consent of authorized representative of HCL is strictly prohibited. If you have received this email in error please delete it and notify the sender immediately. Before opening any email and/or attachments, please check them for viruses and other defects.
> --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org