/// <summary>
/// 将DataGridView转换成Excel
/// </summary>
/// <param name="dt"></param>
/// <param name="filepath"></param>
public static void DataGridViewToExcel(DataGridView dgv, ExportExcelFormat eefExcelFormat, string sExpectedFileName)
{
if (eefExcelFormat == ExportExcelFormat.Excel2003)
{
x2003.DataGridViewToExcelForXLS(dgv, sExpectedFileName);
}
else
{
x2007.DataGridViewToExcelForXLSX(dgv, sExpectedFileName);
}
}
/// <summary>
/// 将DataTable转换成Excel
/// </summary>
/// <param name="dt"></param>
/// <param name="filepath"></param>
public static void TableToExcel(DataTable dt, ExportExcelFormat eefExcelFormat, string sExpectedFileName)
{
if (eefExcelFormat == ExportExcelFormat.Excel2003)
{
x2003.TableToExcelForXLS(dt, sExpectedFileName);
}
else
{
x2007.TableToExcelForXLSX(dt, sExpectedFileName);
}
}
