public void TestExportSTExcel_CustomFile()
{
var strender = new STExcel2003Renderer<PersonMoney>("Templates").NameTemplate("PersonMoneyExcel2003");
string res = DataSourcePersons.Render(strender).ResultAsString();
//Console.WriteLine(res);
Assert.AreEqual(verificationData, res);
}
public void TestExportSTExcel()
{
STExcel2003Renderer<PersonMoney> render = new STExcel2003Renderer<PersonMoney>("Templates");
var s = DataSourcePersons.Render(render);
string res = s.ResultAsString();
render.Columns.Clear();
string res2 = DataSourcePersons.Render(new STExcel2003Renderer<PersonMoney>("Templates").ApplyCodeFormat(true))
.AddColumns(x =>
{
x.For("Number").named("Money");
x.For(val => val.DepositDate).named("dt").Format("{0:yyyyMMdd}");
x.For(val => val.Name).Visible(false);
}
).ResultAsString();
//Console.WriteLine(res2);
//File.WriteAllText("a.xls", res2);
//Process.Start("a.xls");
Assert.IsTrue(res.Contains(defaultHeader));
Assert.Greater(res.Length , res2.Length);
Assert.AreEqual(res2, verificationData);
}
