Skip to main content
ssmith-nova
Member
Oct 23, 2024 10:17 PM UTC

Export Formatted Data Explorer to Excel via code

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

Employee - Guide
KarlTEmployee - Guide
Employee - Guide
Oct 24, 2024 8:27 AM UTC

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

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

 

ssmith-novaAuthor
Member
Oct 24, 2024 3:39 PM UTC

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

Thanks,

Scott

    Terms & ConditionsAccessibility statement