public void TestSetCell2()
{
IExcelPlugin excel = new ExcelPlugin();
foreach (var filePath in ExcelFiles)
{
var workbook = excel.OpenExcel(filePath);
var sheet = excel.GetSheet(workbook, 0);
if (sheet == null)
{
continue;
}
var result = excel.WriteCell(sheet, 5, 5, "just for test value");
excel.Save(workbook, filePath);
if (result)
{
Assert.IsTrue(true);
}
else
{
Assert.IsTrue(false);
}
}
}
public void TestWriteCell()
{
IExcelPlugin excel = new ExcelPlugin();
var workbook = excel.CreateExcel();
var sheet = excel.CreateSheet(workbook, "shee1");
var result = excel.WriteCell(sheet, 0, 1, "name");
result = excel.WriteCell(sheet, 1, 1, 1);
result = excel.WriteCell(sheet, 2, 1, 23.90);
result = excel.WriteCell(sheet, 3, 1, 3999999999.00000003);
if (result)
{
Assert.IsTrue(true);
}
else
{
Assert.IsTrue(false);
}
excel.Save(workbook, "");
}
