(High score) The amount of Excel data exported by JAVA is very large (more than 65438+ million), and then an error occurs. I guess there is not enough memory. How should I change it? The source code is like this: I remember that you can write code directly in the excel template, and you only need to connect to the jdbc database in the background.

For example:

& ltJX:forEach items = " $ { RM . exec(" SELECT INV _ no FROM INV _ MAIN ")} " var = " SSS " & gt；

${sss.inv_no}

& lt/JX:forEach & gt；