public static void Test()
{
var imp = new ExcelImporter();
var rn = EngineNS.RName.GetRName("GameTable/XlslObject.xls");
imp.Init(rn.Address);
var objs = imp.Table2Objects <ExcelHelper.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(XlslObject));
var lst = new List <XlslObject>();
var obj = new XlslObject();
for (int i = 0; i < 10; i++)
{
obj = new XlslObject();
obj.D = $"D_{i}";
obj.F.Add(new XlslSubObject());
obj.F.Add(new XlslSubObject());
var sobj = new 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);
}