C#将DataTable导出到Excle并保存至硬盘

             #region 写入excle,dt为要写入excle的dataTable

            Microsoft.Office.Interop.Excel.Application app =
            new Microsoft.Office.Interop.Excel.Application();
   
            app.Visible = false;
            Microsoft.Office.Interop.Excel.Workbook  wBook = app.Workbooks.Add(true);
           Microsoft.Office.Interop.Excel.Worksheet wSheet = wBook.Worksheets[1] as Microsoft.Office.Interop.Excel.Worksheet;
            if (dt.Rows.Count > 0)
              {
                   int row = 0;
                    row = dt.Rows.Count;
                  int col = dt.Columns.Count;
                   for (int i = 0; i < row; i++)
                    {
                        for (int j = 0; j < col; j++)
                        {