/// <summary> /// 保存文件 /// </summary> /// <param name="dtHe"></param> private static void saveFile(DataTable dtHe) { string dir = Environment.GetFolderPath(Environment.SpecialFolder.DesktopDirectory); string saveFile = dir + "\\合并考勤表.xls"; NpoiHelper.Export(dtHe, "合并考勤表", saveFile); MessageBox.Show("生成成功!文件已经保存在" + saveFile, "消息提示"); Console.Out.WriteLine("生成成功"); }
public JsonResult Export() { try { //导出所有数据 var All_ListData = UserEntites.UserInfo.ToList(); //将list 转化为datatable类型 var Dt = DatabaseOpreas._.ListToDataTable(All_ListData); NpoiHelper.Export(Dt, "用户信息", Server.MapPath("~/Content/Export.xls"));//这里的路径是需要写入你需要保存的文件格式的,不需要创建自动检测创建 return(Json(new { code = 1, msg = "/Content/Export.xls" })); } catch (Exception ex) { return(Json(new { code = 0, msg = ex.Message })); } }