62,042
社区成员
发帖
与我相关
我的任务
分享
public static bool AddExcelRecord(string filePath, DataTable dt, string fileName, System.Web.HttpResponse response)
{
try
{
WorkbookDesigner designer = new WorkbookDesigner();
designer.Open(filePath);
designer.SetDataSource(dt);
designer.Process();
designer.Save(fileName, SaveType.OpenInExcel, FileFormatType.Excel2007Xlsx, response);
response.Flush();
response.Close();
response.End();
return true;
}
catch (Exception ex)
{
return false;
}
}