title: Write large amount of data to Excel using C#, Asp.net
body: <p>I need to write (using C#, Asp.net 2010) large amount of data (300,000 rows) from DB to Excel (2010). And it should also create around 20 sheets dynamically. So the final Excel workbook will have 15,000 rows per sheet and 20 sheets. I tried using Open XML (DOM) but it took heaps of time and I gave it up after waiting around 40mins but got no sign of output. Also I tried to follow <a href="http://blogs.msdn.com/b/brian_jones/archive/2010/06/22/writing-large-excel-files-with-the-open-xml-sdk.aspx" rel="nofollow">Brian Jone's post</a> about how to use OpenXmlReader and OpenXmlWriter to copy a worksheet and add rows to it. But I do not know how to add sheets using that methodology. </p>
  
  <p>Any help would greatly be appreciated.</p>