public static object CubeFromCSV( [ExcelArgument(Description = "Output cube name")] string ObjectName, [ExcelArgument(Description = "Input filename")] string FileName) { return(ExcelHelper.Execute(_logger, () => { var cube = CubeEx.FromCSVFile(FileName); return RiskFunctions.PushCubeToCache(cube, ObjectName); })); }
public static object SurfaceToCube( [ExcelArgument(Description = "Surface name")] string SurfaceName, [ExcelArgument(Description = "Output cube name")] string CubeName) { return(ExcelHelper.Execute(_logger, () => { var surface = ContainerStores.GetObjectCache <IVolSurface>().GetObjectOrThrow(SurfaceName, $"Vol surface {SurfaceName} not found"); var rrbf = (RiskyFlySurface)surface.Value; var cube = rrbf.ToCube(); return RiskFunctions.PushCubeToCache(cube, CubeName); })); }
public static object CubeFromCSV( [ExcelArgument(Description = "Output cube name")] string ObjectName, [ExcelArgument(Description = "Input filename")] string FileName, [ExcelArgument(Description = "Has header row, default true")] object HasHeaderRow, [ExcelArgument(Description = "Has value column, default true")] object HasValueColumn) { return(ExcelHelper.Execute(_logger, () => { var hasHeader = HasHeaderRow.OptionalExcel(true); var hasValue = HasValueColumn.OptionalExcel(true); var cube = (!hasHeader && !hasValue) ? CubeEx.FromCSVFileRaw(FileName) : CubeEx.FromCSVFile(FileName, hasHeader, hasValue); return RiskFunctions.PushCubeToCache(cube, ObjectName); })); }