DataTable leads to Excel

/// <summary>/// 将DataTalbe导出到Excel中/// </summary>/// <param name="dt"></param>/// <param name="ProjectName">生成的Excel的Sheet的名字</param>/// <param name="filePath">保存的路径</param>publicstaticvoidExport(System.Data.DataTable dt, stringfilePath){    if(dt == null)    {        thrownewException("数据表中无数据");    }    inteRowIndex = 1;    inteColIndex = 1;    intcols = dt.Columns.Count;    introws = dt.Rows.Count;    Microsoft.Office.Interop.Excel.Application xlApp = newMicrosoft.Office.Interop.Excel.ApplicationClass();    Microsoft.Office.Interop.Excel.Workbook xlBook = xlApp.Workbooks.Add(true);    try    {        //列名的处理        for(inti = 0; i < cols; i++)        {            xlApp.Cells[eRowIndex, eColIndex] = dt.Columns[i].ColumnName;            eColIndex++;        }        //列名加粗显示        xlApp.get_Range(xlApp.Cells[eRowIndex, 1], xlApp.Cells[eRowIndex, cols]).Font.Bold = true;        xlApp.get_Range(xlApp.Cells[eRowIndex, 1], xlApp.Cells[rows + 1, cols]).Font.Name = "Arial";        xlApp.get_Range(xlApp.Cells[eRowIndex, 1], xlApp.Cells[rows + 1, cols]).Font.Size = "10";        eRowIndex++;        for(inti = 0; i < rows; i++)        {            eColIndex = 1;            for(intj = 0; j < cols; j++)            {                xlApp.Cells[eRowIndex, eColIndex] = dt.Rows[i][j].ToString();                eColIndex++;            }            eRowIndex++;        }        //控制单元格中的内容。        xlApp.Cells.EntireColumn.AutoFit();        xlApp.DisplayAlerts = false;        xlBook.SaveCopyAs(filePath);        xlApp.Workbooks.Close();    }    catch    {        throw;    }    finally    {        xlApp.Quit();        //杀掉Excel进程。        GC.Collect();    }}

Note: Using Microsoft.Office.Interop.Excel; VS2010 under Add Reference COM option, look for Microsoft Office 12.0 Object Library in Microsoft Excel 14.0 Object Library

Microsoft.Office.Core Microsoft.Office.Interop.Excel appears in the reference directory

If Excel.applicationclass () cannot be nested in code, use the applicable interface instead

Change the reference Microsoft.Office.Interop.Excel right-click property into the interop type to False

DataTable leads to Excel