public ExcelSheet(ExcelFile file, Worksheet sheet) { Contract.Requires<ArgumentNullException>(file != null); Contract.Requires<ArgumentNullException>(sheet != null); Contract.Requires<ArgumentNullException>(sheet.Cells != null); File = file; Sheet = sheet; }
public void Test() { var fileName = "test.xls"; using (var excelFile = new ExcelFile(fileName)) { var sheet = excelFile.GetSheet("abc", createIfAbsent: true); sheet[3, "C"] = "ABC"; sheet[3, "D"] = "'01"; excelFile.Save(); } try { using (var excelFile = new ExcelFile(fileName)) { var sheet = excelFile.GetSheet("abc"); Assert.AreEqual("ABC", sheet[3, "C"]); Assert.AreEqual("01", sheet[3, "D"]); } } finally { File.Delete(fileName); } }