poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From rdhanara <rdhan...@ford.com>
Subject Re: Loading Large XLSM file using POI without Memory issue .
Date Fri, 12 Apr 2019 05:04:03 GMT
Hi Team, 
  Thanks for your reply.

1.SAX Approach: 
We have tried this but our XLSM file has graph included in it 

Also it has many tables structure included in it . When we use SAX parser we
were able to read the cell value but bringing up the original styles we
failed here.

url: https://github.com/pjfanning/poi-shared-strings-sample 

Tried this approach . Here also facing the same problem with the graph and

Also we are facing alignment issues. On the original file we have set of
alignment with specific cell gap. but using parser we were unable to bring
it back into the new file. looks like parser just getting the cell details
whichever having values in it .

Is there any possible way instead reading original file and writing it
freshly into the new file?
because my requirement is just to remove the sheet from the original file .

3.upgraded below jars
 - poi-4.0.0.jar
 - poi-ooxml-4.0.0.jar
 - poi-ooxml-schemas-4.0.0.jar
 - xmlbeans-3.0.2.jar

Note: Since my organization right now allowing only till 4.0.x have not
moved to the latest on 4.1.x (Hope there wont be much difference between
these to versions)

Please provide your suggestion regarding this .

Thanks & Regards,

Sent from: http://apache-poi.1045710.n5.nabble.com/POI-User-f2280730.html

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

View raw message