public void SsqExcelFunctionTest(string ssqFunction, string wkn_isin_ticker) { IEnumerable <SsqExcelFunction> ssqExcelFunctions = SsqLoader.GetExcelFunctions() .Where(f => ((ExcelFunctionAttribute)f.ExcelFunctionAttribute).Name.Equals(ssqFunction)); var ssqExcelFuntion = ssqExcelFunctions.Single(); object actual = ssqExcelFuntion.Delegate.DynamicInvoke(wkn_isin_ticker); Assert.IsType <decimal>(actual); }
public void ReRegisterFunctions(IRibbonControl control) { ExcelAsyncUtil.QueueAsMacro(() => { SsqLoader.Load(); FfeAddIn ffeAddIn = new FfeAddIn(); ffeAddIn.RegisterFunctions(); ffeAddIn.RegisterDelegates(); }); }
public void RegisterDelegates() { try { SsqLoader.GetExcelFunctions() .RegisterFunctions(); } catch (Exception ex) { Log.Error("Exception while registering SSQ Excel functions. Message: {@ExceptionMessage}", ex.Message); } }
private IEnumerable <string> GetFfeFunctionNames() { /*functionNames = GetExecutingAssembly().GetTypes() * .SelectMany(t => t.GetMethods()) * .Where(m => m.GetCustomAttributes(typeof(ExcelFunctionAttribute), false).Length > 0) * .Select(mi => mi.Name);*/ // FFE functions functionNames = ExcelRegistration.GetExcelFunctions() .Where(x => x.FunctionAttribute.Category.Equals("FFE")) .Select(f => f.FunctionAttribute.Name); // + SSQ UDFs functionNames = functionNames.Union(SsqLoader.GetUdfs().Select(udf => udf.Value.QueryInformation.Name)); return(functionNames); }
public void SsqLoaderTest() { Assert.NotEmpty(SsqLoader.GetExcelFunctions()); }