private static void FetchData(IWebDriver drive, SearchPage apa) { drive.Navigate().GoToUrl(SearchPage.Url); var data = apa.FetchData(); //CleanUpData(data); //var sortedData = data.OrderBy(x => int.Parse(x.Sqft)); if (File.Exists(file)) File.Delete(file); int ctr = 2; var rowData = "Address,price,sqft,$sqft"; WriteData(rowData); foreach (var d in data) { rowData = string.Format("{0},{1},{2},=(B{3}/C{3})", d.Address, d.Price, d.Sqft, ctr); WriteData(rowData); ctr++; } rowData = string.Format(",=AVERAGE(B2:B{0}),=AVERAGE(c2:c{0}),=AVERAGE(d2:d{0}),", ctr - 1); WriteData(rowData); }
static void Main(string[] args) { file = string.Format("realtor.property.data.{0}.{1}.{2}.csv", DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day); var drive = WebDriverFactory.GetBrowser(SearchPage.Url); var apa = new SearchPage(drive); FetchData(drive, apa); drive.Quit(); }