public static void ExportDataToExcel(DataTable dt, string filePath)
{
try
{
if (filePath != string.Empty)
{
Excel.ApplicationClass xlApp = new Excel.ApplicationClass();
Excel.WorkbookClass wb = (Excel.WorkbookClass)xlApp.Workbooks.Add(System.Reflection.Missing.Value);
//写标题
for (int k = 1; k <= dt.Columns.Count; k++)
{
xlApp.Cells[1, k] = dt.Columns[k - 1].ColumnName;
}
//设置标题头大小,背景颜色
xlApp.get_Range(xlApp.Cells[1, 1], xlApp.Cells[1, dt.Columns.Count]).Cells.Font.Size = 15;
xlApp.get_Range(xlApp.Cells[1, 1], xlApp.Cells[1, dt.Columns.Count]).Cells.Interior.Color = System.Drawing.Color.Red.ToArgb();
xlApp.get_Range(xlApp.Cells[1, 1], xlApp.Cells[1, dt.Columns.Count]).EntireRow.AutoFit();
xlApp.get_Range(xlApp.Cells[1, 1], xlApp.Cells[1, dt.Columns.Count]).EntireColumn.AutoFit();
//写内容
for (int i = 1; i <= dt.Rows.Count; i++)
{
for (int j = 1; j <= dt.Columns.Count; j++)
{
if (j == dt.Columns.Count)
{
xlApp.Cells[i + 1, j] = dt.Rows[i - 1][j - 1];
}
}
}
//保存内容
wb.Saved = true;
xlApp.ActiveWorkbook.SaveCopyAs(filePath + "_" + DateTime.Now.ToString("yyyyMMdd-HHmmss") + ".xls");
//退出程序,关闭资源
xlApp.Quit();
System.Runtime.InteropServices.Marshal.ReleaseComObject((object)xlApp);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
{
try
{
if (filePath != string.Empty)
{
Excel.ApplicationClass xlApp = new Excel.ApplicationClass();
Excel.WorkbookClass wb = (Excel.WorkbookClass)xlApp.Workbooks.Add(System.Reflection.Missing.Value);
//写标题
for (int k = 1; k <= dt.Columns.Count; k++)
{
xlApp.Cells[1, k] = dt.Columns[k - 1].ColumnName;
}
//设置标题头大小,背景颜色
xlApp.get_Range(xlApp.Cells[1, 1], xlApp.Cells[1, dt.Columns.Count]).Cells.Font.Size = 15;
xlApp.get_Range(xlApp.Cells[1, 1], xlApp.Cells[1, dt.Columns.Count]).Cells.Interior.Color = System.Drawing.Color.Red.ToArgb();
xlApp.get_Range(xlApp.Cells[1, 1], xlApp.Cells[1, dt.Columns.Count]).EntireRow.AutoFit();
xlApp.get_Range(xlApp.Cells[1, 1], xlApp.Cells[1, dt.Columns.Count]).EntireColumn.AutoFit();
//写内容
for (int i = 1; i <= dt.Rows.Count; i++)
{
for (int j = 1; j <= dt.Columns.Count; j++)
{
if (j == dt.Columns.Count)
{
xlApp.Cells[i + 1, j] = dt.Rows[i - 1][j - 1];
}
}
}
//保存内容
wb.Saved = true;
xlApp.ActiveWorkbook.SaveCopyAs(filePath + "_" + DateTime.Now.ToString("yyyyMMdd-HHmmss") + ".xls");
//退出程序,关闭资源
xlApp.Quit();
System.Runtime.InteropServices.Marshal.ReleaseComObject((object)xlApp);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}