title: Writing large number of rows using jxls to excel in java
body: <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>