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