public MemoryStream ExportByForm(string formId) { using (ExcelGenerator excel = new ExcelGenerator()) { var form = _formService.Get(formId); var formDatas = Get(m => m.FormId == formId); excel.AddRow(row => { foreach (var item in form.FormFields) { row.AppendCell(item.DisplayName); } }); foreach (var data in formDatas) { excel.AddRow(row => { foreach (var item in Get(data.ID).Form.FormFields) { row.AppendCell(item.DisplayValue()); } }); } return(excel.ToMemoryStream()); } }
public MemoryStream Export(int id) { using (ExcelGenerator excel = new ExcelGenerator()) { FormData formData = Get(id); excel.AddRow(row => { foreach (var item in formData.Form.FormFields) { row.AppendCell(item.DisplayName); } }); excel.AddRow(row => { foreach (var item in formData.Form.FormFields) { row.AppendCell(item.DisplayValue()); } }); return(excel.ToMemoryStream()); } }
public byte[] GetAllUsersExcel() { var applicationUsers = _usersDbSet .Include(user => user.WorkingHours) .Include(user => user.JobPosition) .Where(user => user.OrganizationId == 2) .ToList(); using (var printer = new ExcelGenerator("Users")) { printer.CenterColumns(2, 6); printer.AddHeaderRow(HeaderRow()); foreach (var user in applicationUsers) { printer.AddRow(UserToUserRow(user)); } return(printer.Generate()); } }