title: C# Excel - save each worksheet to a new workbook
body: <p>I have an excel with 25 or so worksheets I just want to save each worksheet as it's own new Workbook.  When I run the code it copys the entire workbook just not the individual sheet.  Any help would be awesome.</p>
  
  <pre><code>string FileDropLocation = @"C:\ExcelFiles";
          string file_FullFileName = @"C:\ts\Conversion\v2.xlsx";
          Microsoft.Office.Interop.Excel.Application app = new Microsoft.Office.Interop.Excel.Application();
          Microsoft.Office.Interop.Excel.Workbook workBook = app.Workbooks.Open(file_FullFileName, 0, true, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);
  for (int i = 0; i &lt; workBook.Worksheets.Count; i++)
          {
              Microsoft.Office.Interop.Excel.Worksheet workSheet = (Microsoft.Office.Interop.Excel.Worksheet)workBook.Sheets[i+1];
              workSheet.SaveAs(FileDropLocation + "\\" + workSheet.Name);
          }
          workBook.Close();
  </code></pre>