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 TestReadRange() { IExcelPlugin excel = new ExcelPlugin(); foreach (var filePath in ExcelFiles) { var workbook = excel.OpenExcel(filePath); var sheet = excel.GetSheet(workbook, 0); var result = excel.ReadRange(sheet, "A1:F6"); foreach (var item in result) { Console.WriteLine(item.ToString()); } if (result.Count == 36) { Assert.IsTrue(true); } else { Assert.IsTrue(false); } } }
public void TestGetColumsCount() { IExcelPlugin excel = new ExcelPlugin(); foreach (var filePath in ExcelFiles) { var workbook = excel.OpenExcel(filePath); var sheet = excel.GetSheet(workbook, 0); var result = excel.GetColumsCount(sheet); Console.WriteLine(result); } }
public void TestReadRow() { IExcelPlugin excel = new ExcelPlugin(); foreach (var filePath in ExcelFiles) { var workbook = excel.OpenExcel(filePath); var sheet = excel.GetSheet(workbook, 0); var result = excel.ReadRow(sheet, 5); if (result.Count >= 0) { Assert.IsTrue(true); } else { Assert.IsTrue(false); } } }