public static Boolean SaveAsToFile(List <DNNGo_PowerForms_Field> fieldList, List <DNNGo_PowerForms_Content> DataList, String FullName, Int32 EnumExportExtension, bool ExtraTracking) { bool flag = false; try { ExportDotNet excel = new ExportDotNet(); excel.Title = "HistoryRecords"; excel.ExportFileName = FullName; FileInfo Exportfile = new FileInfo(FullName); if (!Exportfile.Directory.Exists) { Exportfile.Directory.Create(); } DataTable dt = new DataTable(excel.Title); dt = ConvertDataTable(dt, fieldList, DataList, ExtraTracking); if (EnumExportExtension == (Int32)EnumExport.Excel) { flag = excel.ExportToExcel(dt); } else if (EnumExportExtension == (Int32)EnumExport.CSV) { flag = excel.ExportToCSV(dt); } else if (EnumExportExtension == (Int32)EnumExport.Doc) { flag = excel.ExportToDoc(dt); } else if (EnumExportExtension == (Int32)EnumExport.Html) { flag = excel.ExportToHtml(dt); } else if (EnumExportExtension == (Int32)EnumExport.TextFile) { flag = excel.ExportToTextFile(dt); } else if (EnumExportExtension == (Int32)EnumExport.Xml) { flag = excel.ExportToXml(dt); } else { flag = excel.ExportToExcel(dt); } } catch (Exception ex) { throw ex; } return(flag); }
/// <summary> /// 导出表格信息 /// </summary> protected void btnExportExcel_Click(object sender, EventArgs e) { try { var UserList = GetUserList(); if (UserList != null && UserList.Count > 0) { DataTable UserTable = ConvertUserList(UserList); //拼凑文件名 String FileName = String.Format("Users_{0}_{1}.{2}", ModuleId, DateTime.Now.ToString("yyyyMMddHHmmssffff"), "xls"); //文件路径 String FilePath = Context.Server.MapPath(String.Format("{0}ClientZone/Export/{1}", PortalSettings.HomeDirectory, FileName)); //文件实体 var fileInfo = new FileInfo(FilePath); //文件路径是否需要创建 if (!fileInfo.Directory.Exists) { fileInfo.Directory.Create(); } //创建导出类实体 ExportDotNet excel = new ExportDotNet(); //导出标题(Excel之类的才有) excel.Title = "Users"; excel.ExportFileName = FilePath; Boolean flag = excel.ExportToExcel(UserTable); if (flag) { //下载文件 FileSystemUtils.DownloadFile(excel.ExportFileName, FileName); } } else { //没有用户 } } catch (Exception ex) { ProcessModuleLoadException(ex); } }