public ExcelRowCollection(ExcelSheet sheet)
{
this.sheet = sheet;
this.List = new SortedDictionary<uint, ExcelRow>();
foreach(Row row in sheet.worksheet.GetFirstChild<SheetData>().Elements<Row>())
this.List.Add(row.RowIndex, new ExcelRow(row, sheet));
}
public ExcelSheet AddNew(string name = "")
{
ExcelSheet sheet = new ExcelSheet(document, name);
this.List.Add(sheet.Id, sheet);
return sheet;
}
public ExcelRow(Row row, ExcelSheet sheet)
{
this.row = row;
this.index = row.RowIndex.Value;
this.sheet = sheet;
this.Cells = new ExcelCellCollection(this);
}
