Skip to main content
S
ssmith-nova
Member
October 23, 2024

Export Formatted Data Explorer to Excel via code

  • October 23, 2024
  • 2 replies
  • 0 views

I have a dashboard that I would like to automate the export of the formatted data explorer to Excel and keep the formatting.  The same functionality as is available in the export to Excel button on the data explorer component itself.  Am I missing an obvious function or does anyone have a way to replicate that functionality.

ssmithnova_1-1729721632221.png

Thanks,

Scott

 

 

2 replies

K
OneStream Employee
KarlTOneStream Employee
OneStream Employee
October 24, 2024

I've never tried it but does this function work?

BRApi.CubeViews.Process.ExportCubeViewGridsToExcelFile(si, custSubstVarsForAllCubeViews, cubeViewNamesAndVars)

 

S
ssmith-novaAuthor
Member
October 24, 2024

I'll give it a try.  Thanks for the response.  I'll let you know if it works.

Thanks,

Scott

    Terms & ConditionsAccessibility statement