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