title: How to write 3 Million rows to an Excel File Using Apache POI
body: <p>I have more than 2 Million rows for a search criteria in my db which i have to Export into a xlsx file. I am using apache POI SXSSF to achieve that.</p>
  
  <p>I am getting the data chunk by chunk from DB with 130+ columns and writing it into WorkSheet by creating multiple sheets, each sheet has 400K rows. But i am facing the issue when it reaches 1.1M data, my code is not responding after that also it is not throwing any error as well.</p>
  
  <p>I have 2 confusions based on this issue.</p>
  
  <ol>
  <li>Can we handle more than 1 M data on a  single WorkBook.</li>
  <li>Can Excel handle more than 1M records on multiple sheets.</li>
  </ol>