Writing large number of rows using jxls to excel in java
<p>I am using the below code to to write data to excel</p>

<p>XLSTransformer transformer = new XLSTransformer();</p>

<pre><code>        InputStream is = this.getServlet().getServletContext()
                .getResourceAsStream(templateFilePath);
        HSSFWorkbook workBook = (HSSFWorkbook) transformer.transformXLS(is, beans);
</code></pre>

<p>But but the system hangs after HSSFWorkbook workBook = (HSSFWorkbook) transformer.transformXLS(is, beans); if number of rows is more than 1500. Is there any other way or suggetsion for writing data  using template and beans objects for large data sets</p>