title: How can I send an xls file one line per time through http response?
body: <p><strong>Problem</strong></p>
  <p>Recently I got a problem with export large amount of data, and send it to the client side.</p>
  <p>The detailed problem description shows in the linked page below:</p>
  <p><a href="https://stackoverflow.com/questions/28070098/how-can-i-adapt-my-code-to-make-it-compatible-to-microsoft-excel/28076851#28076851">How can I adapt my code to make it compatible to Microsoft Excel?</a></p>
  <p><strong>What's Different</strong></p>
  <p>Although, the first answer in the linked page help me to solve the problem of messy code when open the <em><strong>.csv</strong></em> file by excel. But as I commented, it would be a little inconvenient for the user. So I tried to export an <em><strong>.xls</strong></em> file directly.</p>
  <p><strong>My Question Is</strong></p>
  <blockquote>
  <p>Because the dataset is quite large, I cannot generate the whole <em><strong>.xls</strong></em> file all at once, maybe it's a good idea to send one line or several lines to the client side per time as I did with the <em><strong>.csv</strong></em> file.</p>
  <p>So how can I send the <em><strong>.xls</strong></em> data piece by piece to the client side? or any better recommendations?</p>
  </blockquote>
  <p>I would be really appreciated for your answer!</p>