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