title: POI OutOfMemory Exception with xlsx (XSSF)
body: <p>We am trying to use POI 3.8 for an excel component in our application which has to deal with creation of large excel files. I was happy to use SXSSF streaming approach which was fast and very less memory foot print. However, I am not able to do Data Validation and have to use XSSF. </p>
  
  <p>In XSSF, when I try to open the xlsx file (~5 MB), the memory shoots up and mostly results in OutOfMemory. My questions are,</p>
  
  <ol>
  <li><p>Is it possible to do DataValidation (like select from drop down list) using SXSSF. This would be a blessing for me. </p></li>
  <li><p>Is there a way to use XSSF for datavalidation but with less memory foot print. </p></li>
  <li><p>Is there an alternate java solution for xlsx data validation which is fast and memory efficient. </p></li>
  </ol>
  
  <p>Thank you in advance.. </p>