private void ExportMatrixData() { WfMatrix matrix = WfMatrixAdapter.Instance.Load(this.ExportKey); matrix.Loaded = true; switch (this.ExFormat) { case ExportFormat.Xlsx: Response.Clear(); Response.ClearHeaders(); using (MemoryStream fileSteam = matrix.ExportToExcel2007(this.RoleAsPerson)) { fileSteam.CopyTo(Response.OutputStream); } //Response.BinaryWrite(bytes); //Response.ContentType = MediaTypeNames.Text.Xml; Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"; Response.AppendHeader("CONTENT-DISPOSITION", "attachment;filename=" + matrix.ProcessKey + ".xlsx"); Response.Flush(); Response.End(); break; case ExportFormat.Xml: WorkbookNode workbook = matrix.ExportToExcelXml(this.RoleAsPerson); workbook.Response(matrix.ProcessKey); break; } }
private void ExportMatrixDefinition() { WfMatrixDefinition definition = WfMatrixDefinitionAdapter.Instance.Load(this.ExportKey); WorkbookNode workbook = definition.ExportToExcelXml(); workbook.Response(definition.Key); }
protected void generateMatrixButton_Click(object sender, EventArgs e) { WfMatrix matrix = CreateMatrix(); WorkbookNode workbook = matrix.ExportToExcelXml(false); workbook.Response("Matrix"); }
private void ExportExcelXPXml() { SOARolePropertyDefinitionCollection definition = SOARolePropertyDefinitionAdapter.Instance.LoadByRoleID(ExportRoleProperty.DefinitionID); string PropertySheetName = "Matrix"; WorkbookNode workbook = ExportToExcelXml(definition, PropertySheetName); SOARole role = new SOARole(definition) { ID = RoleID }; SOARolePropertyRowCollection rows = SOARolePropertiesAdapter.Instance.LoadByRole(role, definition); if (rows.Count > 0) { FillMatrixRowsToWorksheet(workbook, rows); } workbook.Response(GetFileNameByRole(RoleID)); }
protected void generateButton_Click(object sender, EventArgs e) { WorkbookNode workbook = CreateMatrixDefinition().ExportToExcelXml(); workbook.Response("Matrix"); }