public static RowCollection MakeRowCollectionFromObjects <T>([NotNull] List <T> objects, [NotNull] string name) { RowCollection rc = new RowCollection(name); foreach (var o in objects) { var rbc = XlsRowBuilder.GetAllProperties(o); rc.Add(rbc); } return(rc); }
public void RunXlsDumperBasicTest() { using (WorkingDir wd = new WorkingDir(Utili.GetCurrentMethodAndClass())) { RowCollection rc = new RowCollection("mysheet"); var rb = XlsRowBuilder.Start("t1", "mytxt").Add("blub", 1).Add("blub2", 1); rc.Add(rb); var rb2 = XlsRowBuilder.Start("t1", "mytxt").Add("blub", 1).Add("blub5", 1); rc.Add(rb2); MyTst mc = new MyTst(); RowCollection rc2 = new RowCollection("sheet2"); var rbc = XlsRowBuilder.GetAllProperties(mc); rc2.Add(rbc); XlsxDumper.WriteToXlsx(wd.Combine("t.xlsx"), rc, rc2); } }