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