Пример #1
0
        public static void SetCalcEngineCacheExpressions(this IXLWorksheet worksheet, bool value)
        {
            var wsType     = worksheet.GetType();
            var calcEngine = wsType.GetProperty("CalcEngine", BindingFlags.Instance | BindingFlags.NonPublic).GetValue(worksheet, new object[] { });

            calcEngine.GetType().GetProperty("CacheExpressions").SetValue(calcEngine, value, new object[] { });
        }
Пример #2
0
        public static void ResumeEvents(this IXLWorksheet sheet)
        {
            var type   = sheet.GetType();
            var method = type.GetMethod("ResumeEvents", BindingFlags.Instance | BindingFlags.Public);

            method.Invoke(sheet, new object[0]);
        }