/// <summary>
///
/// </summary>
/// <param name="ds">要导出的DataTable(包含列头)</param>
/// <param name="strPath">Excel保存地址</param>
public static void ExportExcelMethod(System.Data.DataTable ds, string strPath)
{
if (ds != null && !ds.Equals(""))
{
return;
}
Excel.ApplicationClass _x = new ApplicationClass();
Excel.WorkbookClass wb = (Excel.WorkbookClass)_x.Workbooks.Add(System.Reflection.Missing.Value);
System.Data.DataTable dt = ds;
for (int i = 0; i < dt.Columns.Count; i++)
{
_x.Cells[1, i + 1] = dt.Columns[i].ColumnName;
}
for (int i = 0; i < dt.Rows.Count; i++)
{
for (int j = 0; j < dt.Columns.Count; j++)
{
_x.Cells[2 + i, j + 1] = dt.Rows[i][j].ToString();
}
}
wb.Saved = true;
_x.ActiveWorkbook.SaveCopyAs(strPath);
}