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);
}