public Row Add(Row row)
{
foreach (var item in row.Columns)
{
Add(item.Key, item.Value);
}
return this;
}
public Row GetRow(int i)
{
Row row = new Row();
for (int j = 1; j < Sheet.Dimension.Columns; j++)
{
row.Add(Sheet.Cells[1, j].Value.ToString(), Sheet.Cells[i, j].Value == null ? string.Empty : Sheet.Cells[i, j].Value.ToString());
}
return row;
}
public int AddRow(Row row)
{
foreach (var item in row.Columns)
{
Write(item.Key, item.Value, RowCursor);
}
RowCursor++;
return RowCursor - 1;
}