public static void Test() { var imp = new ExcelImporter(); var rn = EngineNS.RName.GetRName("GameTable/XlslObject.xls"); imp.Init(rn.Address); var objs = imp.Table2Objects <DataProvider.XlslObject>(); if (objs != null) { } }
public static void Test() { ExcelImporter.Test(); var exp = new ExcelExporter(); var rn = EngineNS.RName.GetRName("GameTable/XlslObject.xls"); exp.Init(rn.Address, typeof(DataProvider.XlslObject)); var lst = new List <DataProvider.XlslObject>(); var obj = new DataProvider.XlslObject(); for (int i = 0; i < 10; i++) { obj = new DataProvider.XlslObject(); obj.D = $"D_{i}"; obj.F.Add(new DataProvider.XlslSubObject()); obj.F.Add(new DataProvider.XlslSubObject()); var sobj = new DataProvider.XlslSubObject(); sobj.A = i; obj.F.Add(sobj); obj.G.Add($"abc{i}"); obj.G.Add("efg"); obj.G.Add("123"); lst.Add(obj); } //lst.Add(obj); //obj = new XlslObject(); //obj.A = 10; //lst.Add(obj); //obj = new XlslObject(); //obj.D = "AXEXTEXT"; //obj.F.Add(new XlslSubObject()); //obj.F.Add(new XlslSubObject()); //obj.F.Add(new XlslSubObject()); //obj.G.Add("abc"); //obj.G.Add("efg"); //obj.G.Add("123"); //lst.Add(obj); exp.Objects2Table(lst); exp.Save(rn.Address); }