导出Excel

static Result<string> ExportExcel(string excelTemplatePath, DataTable dataSource,Dictionary<string, object> constData,string excelName = null )
{
var result = new Result<string>();
try
{
excelTemplatePath = System.Web.HttpContext.Current.Server.MapPath(excelTemplatePath);
string parmTemplateName = System.IO.Path.GetFileName(excelTemplatePath);//文件名称
if (!string.IsNullOrEmpty(excelName))
{
parmTemplateName = excelName;
}
string excelTemplateDirPath = AppDomain.CurrentDomain.BaseDirectory + BaseTempDir + "\\";
if (!Directory.Exists(excelTemplateDirPath))
{
Directory.CreateDirectory(excelTemplateDirPath);
}
File.Copy(excelTemplatePath, Path.Combine(excelTemplateDirPath, parmTemplateName), true);
string path = CreateExcelByTemplate(excelTemplateDirPath, parmTemplateName, dataSource, constData);
DownLoad(path);
result.Code = ResultCodeEnum.Success;
result.Data = "数据导出完成";
return result;
}
catch (Exception ex)
{
result.Msg = ex.Message;
return result;
}
}

转载于:https://www.cnblogs.com/574359605s/p/10771264.html