public void TestFlushWithTemplate()
{
var dt = GetTestData();
string templateFilePath = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "file", "template.xlsx");
var fileName = "template" + Guid.NewGuid().ToString() + ".xlsx";
string dataFilePath = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "file", fileName);
NPOIOperator oper = new NPOIOperator(templateFilePath, dataFilePath, true);
var sheet = oper.GetSheet("Sheet1");
oper.WriteContent(sheet, dt, 3, 1);
oper.Flush();
try
{
NPOIOperator oper2 = new NPOIOperator(dataFilePath, true);
var sheet2 = oper2.GetSheet("Sheet1");
var dt2 = oper2.ReadSheet(sheet, true, true, 2, 1);
Assert.AreEqual(3, dt2.Rows.Count);
Assert.AreEqual("李四", dt2.Rows[1]["姓名"]);
Assert.AreEqual(new DateTime(2000, 8, 8), dt2.Rows[1]["出生日期"]);
}
finally
{
File.Delete(dataFilePath);
}
}
public void TestWriteContent()
{
var dt = GetTestData();
string dataFilePath = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "file", "onesheetfile.xlsx");
NPOIOperator oper = new NPOIOperator(dataFilePath, true);
var sheet = oper.GetSheet("Sheet3");
var writeLineNumber = oper.WriteContent(sheet, dt, 2);
Assert.AreEqual(5, writeLineNumber);
var readDT = oper.ReadSheet(sheet, false, 2);
Assert.AreEqual(3, readDT.Rows.Count);
Assert.AreEqual("李四", readDT.Rows[1]["列2"].ToString());
}
