public void WaterYearFormat() { string filename = TestData.DataPath + "\\wateryear.xls"; Assert.IsTrue(System.IO.File.Exists(filename), "missing file " + filename); SpreadsheetGearSeries xls = new SpreadsheetGearSeries(filename, "Sheet1", "WaterYear", "Oct", true); xls.Read(); Assert.AreEqual(12, xls[0].Value, 0.001); Assert.AreEqual(DateTime.Parse("1889-10-1"), xls[0].DateTime); Assert.AreEqual(1100, xls[DateTime.Parse("1934-6-1")].Value); xls.WriteCsv(@"c:\temp\a.csv"); }