public void UpdateColumn(string firstColumnCell, Dictionary <int, Pesel> pesele) { var FirstCellLoc = ExcelCell.TranslateFromString(firstColumnCell); var actualX = FirstCellLoc.X; var actualY = FirstCellLoc.Y; foreach (var pesel in pesele) { UpdateCell(new CellFactors { X = actualX, Y = actualY }, pesel.Value.BornDate.ToString("dd/MM/yyyy")); actualX++; } }
public Dictionary <int, T> ReadColumn <T>(string firstColumnCell, string lastColumnCell) { var columnContents = new Dictionary <int, T>(); var firstColumnCellLocation = ExcelCell.TranslateFromString(firstColumnCell); var actualCellLocation = firstColumnCellLocation; var index = 1; while (true) { //columnContents.Add(index, T); index++; } throw new NotImplementedException(); }
public Dictionary <int, Pesel> GetPesele(string firstCell, Pesel pesel) { var cellLoc = ExcelCell.TranslateFromString(firstCell); var pesele = new Dictionary <int, Pesel>(); var index = 1; var x = cellLoc.X; while (ReadCell(x, cellLoc.Y) != string.Empty && IsPeselCorrect(ReadCell(x, cellLoc.Y))) { pesele.Add(index, new Pesel( ReadCell(x, cellLoc.Y), ExcelCell.TranslateFromXY(cellLoc.Y, x))); index++; x++; } return(pesele); }
public string ReadCell(string cellLocString) { var cellLoc = ExcelCell.TranslateFromString(cellLocString); return(ReadCell(cellLoc.X, cellLoc.Y)); }