Excel VBA API¶
Within Microsoft Excel VBA, you can connect to the CALUMO for Microsoft Excel and use the following functions to perform actions.
- CGetMdxGrid
- Enable/DisableTheFuzz
- ExecSqlProc
- GetSqlData
- OpenCalumoBrowser
- OpenDrillThroughFromCGET
- OpenDrillThroughFromCGETMDX
- OpenMemberExplorer
- PublishActiveSheet
- Settings
- WriteBack (VBA)
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)