Excel VBA API

Within Microsoft Excel VBA, you can connect to the CALUMO for Microsoft Excel and use the following functions to perform actions.

Additional

  • PublishPrivateActiveSheet()
  • string DeployCatalog(string datasource, string catalog, string cube)
  • string ReDeployCatalog()
  • string RefreshAndReDeployCatalog()
  • ClearCalumoFormula(Range range = null, bool showProgress = false, bool outputNew = false, bool recalculate = true, ClearCalumoFormulaActionScope actionScope = ClearCalumoFormulaActionScope.CurrentWorksheet)