title: excel export Memory exception
body: <p>I need to export huge amount of data from ado.net datatable(which i get by db query) to excel.</p>
  
  <p>I tried the following way : 1. Create excel object with workbook/worksheet @ server side...and use memory stream to write whole document to client side.</p>
  
  <p>But this gave me "out of Memory exception". bcoz my memory stream was was so huge.</p>
  
  <p>So I replaced this with a new way - as follows :</p>
  
  <p>Writing each row from datatable as a coma seperated string to client side. So, as and when we get each row ...we can write to client side ..no memory is used.</p>
  
  <p>But by this way we can write to csv file...not to excel...</p>
  
  <p>Does anybody know how to handle this situation.
  Can I use silverlight to get data row by row from server, pass it to client side...build excel at client side.?</p>