C# (CSharp) SpreadsheetGearSeries.WriteCsv Examples

Example #1

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