public void AsDataTableTest()
{
var parm = new ExcelParameter(@"Resources\StudentList.xlsx");
var data = parm.AsDataTable();
Assert.AreEqual(data != null, true);
}
public void ExcelParamTest()
{
var filePath = new FileInfo(@"Resources\Instance.xlsx");
var tplPath = new FileInfo(@"Resources\Template.xlsx");
var param = new ExcelParameter(filePath, tplPath);
Assert.AreEqual(param.FilePath.Length, param.TemplatePath.Length);
}
public void ToExcelTest()
{
var parm = new ExcelParameter(@"Resources\StudentList.xlsx", @"Resources\Template.xlsx");
var students = new List <Student> {
new Student("1", "Student1"), new Student("2", "Student2"), new Student("3", "Student3")
};
parm.ToExcel(students);
}
