/// <summary>
/// 将datatable 保存为 Excel文件
/// </summary>
/// <param name="filename">文件名</param>
/// <returns>导出结果</returns>
private bool ExportXlsx(string filename)
{
try
{
DataTable dt = new DataTable();
dt.Columns.Add("名称", typeof(string));
dt.Columns.Add("英文名", typeof(string));
dt.Columns.Add("中文名", typeof(string));
DataRow dr;
foreach (DataRow row in m_Datatable.Rows)
{
dr = dt.NewRow();
dr["名称"] = row["SourceFieldName"];
dr["英文名"] = row["FieldName"];
dr["中文名"] = row["FieldAliasName"];
dt.Rows.Add(dr);
}
Workbook workbook = new Workbook();
Worksheet sheet = workbook.Worksheets[0];
WorksheetExtensions.Import(sheet, dt, true, 0, 0);
workbook.SaveDocument(filename);
return true;
}
catch (Exception e)
{
LogServices.WriteExceptionLog(e, "导出csv失败!");
return false;
}
}