Row ProcessRow(ExRow exrow, Int32 rowNo) { var row = new Row(); if (exrow.Height != 0) { row.Height = ConvertToPoints(exrow.Height); row.CustomHeight = true; } for (var col = 0; col < exrow.Cells.Count; col++) { var c = exrow.Cells[col]; if (c.Kind == CellKind.Null) { continue; } var cell = new Cell(); SetCellValue(cell, c, exrow); cell.CellReference = c.Reference(rowNo, col); var mergeRef = c.MergeReference(rowNo, col); if (mergeRef != null) { _mergeCells.Add(mergeRef); } row.Append(cell); } return(row); }
void AddRow(XmlNode src, RowKind kind, Int32 rowNo) { ExRow row = _sheet.GetRow(rowNo, kind); var classAttr = src.Attributes["class"]; if (classAttr != null) { row.SetRoleAndStyle(classAttr.Value); } var heightAttr = src.Attributes["data-row-height"]; if (heightAttr != null) { if (UInt32.TryParse(heightAttr.Value, out UInt32 height)) { row.Height = height; } } foreach (var cn in src.ChildNodes.OfType <XmlNode>().Where(node => node.Name == "td")) { var colSpanAttr = cn.Attributes["colspan"]; var rowSpanAttr = cn.Attributes["rowspan"]; var span = new CellSpan(); if (colSpanAttr != null) { span.Col = Int32.Parse(colSpanAttr.Value); } if (rowSpanAttr != null) { span.Row = Int32.Parse(rowSpanAttr.Value); } var dataTypeAttr = cn.Attributes["data-type"]; String dataType = null; if (dataTypeAttr != null) { dataType = dataTypeAttr.Value; } var cellClassAttr = cn.Attributes["class"]; String cellClass = null; if (cellClassAttr != null) { cellClass = cellClassAttr.Value; } String cellText = GetNodeText(cn); _sheet.AddCell(rowNo, row, span, cellText, dataType, cellClass); } }
public ExCell AddCell(Int32 rowNo, ExRow exRow, CellSpan span, String value, String dataType, String cellClass) { // first empty cell var row = GetRow(rowNo, exRow.Kind); var(cell, index) = row.AddCell(); cell.Span = span; cell.SetValue(value, dataType); cell.StyleIndex = Styles.GetOrCreate(cell.GetStyle(row, cellClass)); if (span.Col == 0 && span.Row == 0) { return(cell); } if (span.Col > 0 && span.Row == 0) { for (var c = 0; c < span.Col - 1; c++) { AddSpanCell(exRow.Kind, rowNo, index + c + 1).StyleIndex = cell.StyleIndex; } } else if (span.Col == 0 && span.Row > 0) { for (var r = 0; r < span.Row - 1; r++) { AddSpanCell(exRow.Kind, rowNo + r + 1, index).StyleIndex = cell.StyleIndex; } } else { // first row for (var c = 0; c < span.Col - 1; c++) { AddSpanCell(exRow.Kind, rowNo, index + c + 1).StyleIndex = cell.StyleIndex; } // next rows for (var r = 1; r < span.Row; r++) { for (var c = 0; c < span.Col; c++) { AddSpanCell(exRow.Kind, rowNo + r, index + c).StyleIndex = cell.StyleIndex; } } } return(cell); }
public Style GetStyle(ExRow row, String strClasses) { var cls = Utils.ParseClasses(strClasses); var align = row.Align; if (cls.Align != HorizontalAlign.NotSet) { align = cls.Align; } return(new Style() { DataType = DataType, RowRole = row.Role, RowKind = row.Kind, Align = align, VAlign = cls.VAlign, Bold = cls.Bold, Indent = cls.Indent, Underline = cls.Underline }); }
void SetCellValue(Cell cell, ExCell exCell, ExRow exRow) { if (exCell.StyleIndex != 0) { cell.StyleIndex = exCell.StyleIndex; } if (exCell.Kind != CellKind.Normal) { return; } switch (exCell.DataType) { case DataType.String: cell.DataType = new EnumValue <CellValues>(CellValues.InlineString); cell.InlineString = new InlineString(new Text(exCell.Value)); break; case DataType.Currency: cell.DataType = new EnumValue <CellValues>(CellValues.Number); cell.CellValue = new CellValue(exCell.Value); break; case DataType.Number: cell.DataType = new EnumValue <CellValues>(CellValues.Number); cell.CellValue = new CellValue(exCell.Value); break; case DataType.Date: case DataType.DateTime: // DataType not needed cell.CellValue = new CellValue(exCell.Value); break; default: cell.CellValue = new CellValue(exCell.Value); break; } }