public static List <WordInfo> Read(Excel.Worksheet yandexPage)
{
var results = new List <WordInfo>(DatesCount);
for (var i = 0; i < WordsCount; i++)
{
var skipped = 3 * i;
var record = new WordInfo();
record.RusWord = yandexPage.GetCellValue(4, i + 2 + skipped);
record.EngWord = yandexPage.GetCellValue(4, i + 3 + skipped);
for (var j = 0; j < DatesCount; j++)
{
var dataRecord = new WordDateInfo();
dataRecord.Date = yandexPage.GetCellValue(j + 5, 1);
dataRecord.RusPopularity = yandexPage.GetCellValueDecimal(j + 5, i + 2 + skipped);
dataRecord.EngPopularity = yandexPage.GetCellValueDecimal(j + 5, i + 3 + skipped);
record.Dates.Add(dataRecord);
}
results.Add(record);
}
return(results);
}
