public static object[,] GetResults([ExcelArgument(Description = "The name of the results object as returned by a call to another QuantSA function")] string objectName, [ExcelArgument(Description = "The name of the result required. Use QSA.GetAvailableResults to get a list of all availabale results in this object.")] string resultName) { try { IProvidesResultStore resultStore = ObjectMap.Instance.GetObjectFromID <IProvidesResultStore>(objectName); if (resultStore == null) { throw new ArgumentException("The provided object is not a results object."); } if (resultStore.GetResultStore().IsDate(resultName)) { Date[,] dates = resultStore.GetResultStore().GetDates(resultName); return(ExcelUtilities.ConvertToObjects(dates)); } else if (resultStore.GetResultStore().IsString(resultName)) { return(ExcelUtilities.ConvertToObjects(resultStore.GetResultStore().GetStrings(resultName))); } else { return(ExcelUtilities.ConvertToObjects(resultStore.GetResultStore().Get(resultName))); } } catch (Exception e) { return(ExcelUtilities.Error2D(e)); } }
public static object[,] GetAvailableResults([ExcelArgument(Description = "The name of the results object as returned by call to another QuantSA function")] string objectName) { try { IProvidesResultStore resultStore = ObjectMap.Instance.GetObjectFromID <IProvidesResultStore>(objectName); string[] temp = resultStore.GetResultStore().GetNames(); object[,] column = new object[temp.Length, 1]; for (int i = 0; i < temp.Length; i++) { column[i, 0] = temp[i]; } return(column); } catch (Exception e) { return(new object[, ] { { e.Message } }); } }