public IActionResult CreateExelDoc(int id) { OpenXmlExcel open = new OpenXmlExcel(); MemoryStream bais = new MemoryStream(open.CreateExcel().ToArray()); string file_type = "application/xlsx"; string file_name = "prikaz.xlsx"; return(File(bais, file_type, file_name)); }
/// <summary> /// Excel导出方式 /// </summary> /// <param name="paging">查询参数</param> /// <param name="excelReportDto"></param> /// <returns></returns> public async Task <OperateStatus> ReportExcelUserQuery(SystemUserPagingInput paging, ExcelReportDto excelReportDto) { var operateStatus = new OperateStatus(); try { //组装数据 IList <SystemUserOutput> dtos = (await _userInfoRepository.PagingUserQuery(paging)).Data.ToList(); var tables = new Dictionary <string, DataTable>(StringComparer.OrdinalIgnoreCase); //组装需要导出数据 var dt = new DataTable("User"); dt.Columns.Add("Num"); dt.Columns.Add("Code"); dt.Columns.Add("Name"); dt.Columns.Add("OrganizationName"); dt.Columns.Add("Mobile"); dt.Columns.Add("IsFreeze"); dt.Columns.Add("CreatTime"); dt.Columns.Add("FirstVisitTime"); dt.Columns.Add("LastVisitTime"); dt.Columns.Add("Remark"); var num = 1; if (dtos.Any()) { foreach (var dto in dtos) { var row = dt.NewRow(); dt.Rows.Add(row); row[0] = num; row[1] = dto.Code; row[2] = dto.Name; row[3] = dto.OrganizationName; row[4] = dto.Mobile; row[5] = dto.IsFreeze ? "是" : "否"; row[7] = dto.FirstVisitTime; row[8] = dto.LastVisitTime; row[9] = dto.Remark; num++; } } tables.Add(dt.TableName, dt); OpenXmlExcel.ExportExcel(excelReportDto.TemplatePath, excelReportDto.DownPath, tables); operateStatus.ResultSign = ResultSign.Successful; } catch (Exception) { operateStatus.ResultSign = ResultSign.Error; } return(operateStatus); }
public async Task <OperateStatus> ReportExcelExceptionLogQuery(QueryParam paging, ExcelReportDto excelReportDto) { var operateStatus = new OperateStatus(); try { //获取总共条数 paging.Rows = await Count(); //组装数据 IList <SystemExceptionLog> dtos = (await _exceptionLogRepository.PagingQueryProcAsync(paging)).Data.ToList(); var tables = new Dictionary <string, DataTable>(StringComparer.OrdinalIgnoreCase); //组装需要导出数据 var dt = new DataTable("ExceptionLog"); dt.Columns.Add("Num"); dt.Columns.Add("OperateTime"); dt.Columns.Add("Code"); dt.Columns.Add("Message"); dt.Columns.Add("RequestUrl"); dt.Columns.Add("ClientHost"); var num = 1; if (dtos.Any()) { foreach (var dto in dtos) { var row = dt.NewRow(); dt.Rows.Add(row); row[0] = num; row[1] = dto.CreateTime; row[2] = dto.CreateUserCode; row[3] = dto.Message; row[4] = dto.RequestUrl; row[5] = dto.ClientHost; num++; } } tables.Add(dt.TableName, dt); OpenXmlExcel.ExportExcel(excelReportDto.TemplatePath, excelReportDto.DownPath, tables); operateStatus.ResultSign = ResultSign.Successful; } catch (Exception) { operateStatus.ResultSign = ResultSign.Error; } return(operateStatus); }