public SheetOperator(WorkbookPart workbookPart, OpenXmlReader reader, Sheet currentSheet, SharedStringCache sharedStringCache) { this._workbookPart = workbookPart; this._reader = reader; this._currentSheet = currentSheet; this._sharedStringCache = sharedStringCache; }
public void ForEachSheet(Action <SheetOperator> action) { using (var sharedStringCache = new SharedStringCache(workbookPart)) { foreach (WorksheetPart worksheetPart in workbookPart.WorksheetParts) { var currentSheet = GetCurrentSheet(worksheetPart); using (OpenXmlReader reader = OpenXmlReader.Create(worksheetPart)) using (SheetOperator sheetOperator = new SheetOperator(workbookPart, reader, currentSheet, sharedStringCache)) { action(sheetOperator); } } } }
public void ForEachSheet(Action<SheetOperator> action) { using (var sharedStringCache = new SharedStringCache(workbookPart)) { foreach (WorksheetPart worksheetPart in workbookPart.WorksheetParts) { var currentSheet = GetCurrentSheet(worksheetPart); using (OpenXmlReader reader = OpenXmlReader.Create(worksheetPart)) using (SheetOperator sheetOperator = new SheetOperator(workbookPart, reader, currentSheet, sharedStringCache)) { action(sheetOperator); } } } }