public void readXSLFile(string filePath) { List<string> mDates = new List<string>(); if (File.Exists(filePath)) { FileStream stream = new FileStream(filePath, FileMode.Open, FileAccess.Read); var excelReader = ExcelReaderFactory.CreateBinaryReader(stream); //excelReader.IsFirstRowAsColumnNames = true; DataSet result = excelReader.AsDataSet(); //excelReader. int position = 0; Date currentDate; double dateDouble; double percentOpen; SlopeMonthData currentMonthData = null; excelReader.Read(); while (excelReader.Read()) { for (int i = 0; i < NUM_YEARS; i++) { if (excelReader[DATE_POSITION + (i * INCREMENT_PER_YEAR)] != null) { dateDouble = (double)excelReader[DATE_POSITION + (i * INCREMENT_PER_YEAR)]; currentDate = convertDateDoubleToDate(dateDouble); } else { continue; } if (excelReader[PERCENT_OPEN_POSITION + (i * INCREMENT_PER_YEAR)] != null) { percentOpen = (double)excelReader[PERCENT_OPEN_POSITION + (i * INCREMENT_PER_YEAR)] * 100; } else { continue; } currentMonthData = getSlopeMonthData(currentDate); if (currentMonthData != null) { currentMonthData.addData(currentDate.day, percentOpen); } else { currentMonthData = new SlopeMonthData(currentDate.year, currentDate.month); currentMonthData.addData(currentDate.day, percentOpen); mMonthData.Add(currentMonthData); } currentMonthData = null; } /* double dateDouble = (double)excelReader[position]; if (excelReader[position] != null) mDates.Add((Convert.ToDateTime(dateDouble)).ToString()); else { mDates.Add(""); } */ } excelReader.Close(); } }
public static void xmlSerilize(SlopeMonthData monthData) { XmlSerializer ser = new XmlSerializer(typeof(SlopeMonthData)); TextWriter contactList = new StreamWriter(@"../" + monthData.monthYearString() + ".xml"); ser.Serialize(contactList, monthData); }