public static void CreateMatrixHeaderRow(this IWfClientMatrixContainer matrix, WorkSheet sheet) { matrix.NullCheck("matrix"); sheet.NullCheck("sheet"); Row headRow = new Row(3); headRow.Style.Fill.SetBackgroundColor(Color.Gold, ExcelFillStyle.Solid); headRow.Style.Border.Top.Style = ExcelBorderStyle.Thin; headRow.Style.Border.Top.Color.SetColor(Color.Black); headRow.Style.Border.Bottom.Style = ExcelBorderStyle.Thin; headRow.Style.Border.Bottom.Color.SetColor(Color.Black); headRow.Style.Border.Left.Style = ExcelBorderStyle.Thin; headRow.Style.Border.Left.Color.SetColor(Color.Black); headRow.Style.Font.Bold = true; sheet.Rows.Add(headRow); int columnIndex = 1; foreach (WfClientRolePropertyDefinition dimension in matrix.PropertyDefinitions) { sheet.Cells[headRow.Index, columnIndex].Value = dimension.Description.IsNotEmpty() ? dimension.Description : dimension.Name; sheet.Names.Add(CellAddress.Parse(columnIndex, headRow.Index).ToString(), dimension.Name); columnIndex++; } }
public static void FillMatrixSheetData(this IWfClientMatrixContainer matrix, WorkSheet sheet) { matrix.NullCheck("matrix"); sheet.NullCheck("sheet"); int rowIndex = 4; WfClientRolePropertyRowCollection rows = matrix.Rows; foreach (WfClientRolePropertyRow row in rows) { foreach (DefinedName name in sheet.Names) { var propertyValue = row.Values.FindByColumnName(name.Name); object dataValue = null; if (propertyValue != null) { if (propertyValue.Column.DataType != Data.DataObjects.ColumnDataType.String) { dataValue = DataConverter.ChangeType(typeof(string), propertyValue.Value, propertyValue.Column.RealDataType); } else { dataValue = propertyValue.Value; } } else { if (matrix.MatrixType != WfClientMatrixType.ApprovalMatrix) { switch (name.Name.ToLower()) { case "operatortype": dataValue = row.OperatorType.ToString(); break; case "operator": dataValue = row.Operator; break; } } } if (dataValue != null) { sheet.Cells[rowIndex, name.Address.StartColumn].Value = dataValue; } } rowIndex++; } }
/// <summary> /// 矩阵转换为Excel的WorkBook /// </summary> /// <param name="matrix"></param> /// <returns></returns> public static WorkBook ToWorkBook(this IWfClientMatrixContainer matrix) { WorkBook workBook = WorkBook.CreateNew(); workBook.Sheets.Clear(); WorkSheet sheet = matrix.ToWorkSheet(workBook); workBook.Sheets.Add(sheet); return(workBook); }
/// <summary> /// 矩阵转换为Excel的WorkBook的流 /// </summary> /// <param name="matrix"></param> /// <returns></returns> public static Stream ToExcelStream(this IWfClientMatrixContainer matrix) { matrix.NullCheck("matrix"); WorkBook workBook = matrix.ToWorkBook(); MemoryStream stream = new MemoryStream(); workBook.Save(stream); stream.Seek(0, SeekOrigin.Begin); return(stream); }
/// <summary> /// 转换为Excel的WorkSheet /// </summary> /// <param name="matrix"></param> /// <param name="workBook"></param> /// <returns></returns> public static WorkSheet ToWorkSheet(this IWfClientMatrixContainer matrix, WorkBook workBook) { matrix.NullCheck("matrix"); WorkSheet sheet = new WorkSheet(workBook, "Matrix"); Row titleRow = new Row(1) { Height = 30d }; titleRow.Style.Fill.SetBackgroundColor(Color.LightGray, ExcelFillStyle.Solid); titleRow.Style.Font.Size = 20; sheet.Rows.Add(titleRow); sheet.Cells[titleRow.Index, 1].Value = "审批矩阵"; CreateMatrixHeaderRow(matrix, sheet); FillMatrixSheetData(matrix, sheet); return(sheet); }