title: How to read paged rows from an excel or ods file?
body: <p>We are using java and <a href="http://incubator.apache.org/odftoolkit/" rel="nofollow">ODF Toolkit</a> for reading rows from ods and excel files. </p>
  
  <p>The problem is that , even if you want to read only 1 row ,the whole document is loaded and the memory usage for a 50.000 rows of ods file is around 350 MBs . </p>
  
  <p>So im searching for a way to read rows by paging . Any chance </p>
  
  <p>Edit1 : Please dont sugges <a href="http://poi.apache.org/" rel="nofollow">POI</a> , works just like ODF Toolkit.</p>
  
  <p>Edit2 : I accepted an answer but it only works with Excel files , and there's no answer for ODS files.</p>