public void Generate()
{
foreach (var ws in _workbook.Worksheets.Where(sh => sh.Visibility == XLWorksheetVisibility.Visible && !sh.PivotTables.Any()).ToArray())
{
_interpreter.Evaluate(ws.AsRange());
}
}
public void Generate()
{
CheckIsDisposed();
foreach (var ws in Workbook.Worksheets.Where(sh => sh.Visibility == XLWorksheetVisibility.Visible && !sh.PivotTables.Any()).ToArray())
{
ws.ReplaceCFFormulaeToR1C1();
_interpreter.Evaluate(ws.AsRange());
ws.ReplaceCFFormulaeToA1();
}
}