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;
}
}
