internal Worksheet( ExcelApplication excel, Workbook workbook, Excel.Worksheet _worksheet, ObjectDisposedCallback disposeCallback, bool displayGridLines) { this.ExcelApplication = excel; this.Workbook = workbook; this._worksheet = _worksheet; this._cells = _worksheet.Cells; this.disposeCallback = disposeCallback; this.Name = _worksheet.Name; DisplayGridlines = displayGridLines; }
internal Workbook( ExcelApplication excelApplication, Excel.Workbook _workbook, string filePath, ObjectDisposedCallback disposeCallback) { ExcelApplication = excelApplication; this._workbook = _workbook; this.FilePath = filePath; worksheets = new List<Worksheet>(); _sheets = _workbook.Worksheets; worksheetDisposeCallback = sender => worksheets.Remove((Worksheet)sender); this.disposeCallback = disposeCallback; for (var i = 1; i <= _sheets.Count; i++) { worksheets.Add(new Worksheet(ExcelApplication, this, _sheets[i], worksheetDisposeCallback, false)); } worksheets[0].Activate(); }
internal Workbook( ExcelApplication excelApplication, Excel.Workbook _workbook, string filePath, ObjectDisposedCallback disposeCallback) { ExcelApplication = excelApplication; this._workbook = _workbook; this.FilePath = filePath; worksheets = new List <Worksheet>(); _sheets = _workbook.Worksheets; worksheetDisposeCallback = sender => worksheets.Remove((Worksheet)sender); this.disposeCallback = disposeCallback; for (var i = 1; i <= _sheets.Count; i++) { worksheets.Add(new Worksheet(ExcelApplication, this, _sheets[i], worksheetDisposeCallback, false)); } worksheets[0].Activate(); }