title: Writing DataTable/DataSet to Excel Workbook
body: <p>I'm looping through a database and querying by month then inserting this data into a <code>DataTable</code> for each month of the users specified year. I'd like to insert this <code>DataTable</code> into a new sheet of an Excel Workbook. Thus I'd end up with 12 sheets in my single Excel workbook.</p>
  
  <p>So I have a couple questions stemming from this.</p>
  
  <blockquote>
    <p>Would it be better to have a DataSet containing my 12 DataTables (one for each month)? And then is there a quick and easy way of creating an Excel spreadsheet from my DataSet and being that there are 12 DataTables in that set it would create a separate sheet for each DataTable?</p>
  </blockquote>
  
  <p>And then the other question being</p>
  
  <blockquote>
    <p>Is it more simple or easier to just create 12 different DataTables and create a workbook and a separate sheet for each DataTable in the workbook and fill that sheet from the DataTable one by one?</p>
  </blockquote>