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 <[email protected]>: > > 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: [email protected] For additional commands, e-mail: [email protected]
