title: How to load on demand excel rows in a data table c#
body: <p>I have a requirement where-in I have to fill dataTable from a sheet of Microsoft excel.</p>
  <p>The sheet may have lots of data so the requirement is that when a foreach loop is iterated over the data table which is supposed to hold the data from Microsoft excel sheet should fill the table on demand.</p>
  <p>Meaning if there are 1000000 records in the sheet the data table should fetch data in batches of 100 depending on the current position of the foreach current item in the loop.</p>
  <p>Any pointer or suggestion will be appreciated.</p>