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