private void AddRow(XlsRow dRow, CrossDataRow row)
{
foreach (var data in Table.GetRowColumnDatas(row))
{
if (data is int)
{
dRow.AddInt((int)data);
}
else if (data is double)
{
dRow.AddFloat((double)data);
}
else if (data is bool)
{
dRow.AddBool((bool)data);
}
else if (data is DateTime)
{
dRow.AddDateTime((DateTime)data);
}
else
{
dRow.AddText(data != null ? data.ToString() : "");
}
}
dRow.Style.AutoHeight = true;
}
public XlsRow AddRow(string text, int colSpan = 0, int rowSpan = 0)
{
var row = new XlsRow();
Items.Add(row);
row.AddText(text, colSpan, rowSpan);
return(row);
}