Java poi Excel reads Big Data

When using poi technology to read a large amount of Excel Data, there will always be a memory overflow. I have found many ways on the Internet, which cannot be better solved in many ways. Finally, I found a better solution. After modifying the JVM, I doubled it to read more than 60 thousand pieces of data in 20 columns.

Modify the location of Tomcat Catalina. BAT as follows (modify Catalina. Sh in Linux ):

Set _ execjava = % _ runjava %
Set mainclass = org. Apache. Catalina. startup. Bootstrap
Set action = start
Set security_policy_file =
Set debug_opts =
Set JPDA =

Add set java_opts =-xms512m-xmx1024m to the end. After setting tomcat, you need to set myeclipse. The method for setting myeclipse is as follows:

Window --> prinference --> myeclipse --> servers --> Tomcat 6.0 --> JDK

Enter-xms512m-xmx1024m in optional Java VM arguments on the right.