public void ClearSheetTest() { var filename = TestUtility.OutputPath + "clear-sheet-test.xlsx"; TimeSeries ts1 = TestUtility.CreateTimeSeries(10); ExcelWriter w = new ExcelWriter(filename); w.Write(ts1, "Sheet1"); ExcelReader r = new ExcelReader(filename); TimeSeries ts2 = r.GetTimeSeries("Sheet1"); Assert.IsTrue(Enumerable.SequenceEqual(ts1.Times, ts2.Times)); Assert.IsTrue(Enumerable.SequenceEqual(ts1.Values, ts2.Values)); w.ClearSheet("Sheet1"); TimeSeries ts3 = r.GetTimeSeries("Sheet1"); Assert.AreEqual(new TimeSeries(), ts3); File.Delete(filename); }
public void ClearSheetTest() { var filename = TestUtility.OutputPath + "clear-sheet-test.xlsx"; PairedData pd1 = TestUtility.CreatePairedData(3, 10); ExcelWriter w = new ExcelWriter(filename); w.Write(pd1, "Sheet1"); ExcelReader r = new ExcelReader(filename); PairedData pd2 = r.GetPairedData("Sheet1"); Assert.IsTrue(Enumerable.SequenceEqual(pd1.Ordinates, pd2.Ordinates)); Assert.IsTrue(Enumerable.SequenceEqual(pd1.Values[0], pd2.Values[0])); Assert.IsTrue(Enumerable.SequenceEqual(pd1.Values[1], pd2.Values[1])); Assert.IsTrue(Enumerable.SequenceEqual(pd1.Values[2], pd2.Values[2])); w.ClearSheet("Sheet1"); PairedData pd3 = r.GetPairedData("Sheet1"); Assert.AreEqual(new PairedData(), pd3); File.Delete(filename); }