Forum Discussion

ssmith-nova's avatar
ssmith-nova
New Contributor III
2 months ago

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.

Thanks,

Scott

 

 

Data Integration
Forms
  • ssmith-nova's avatar
    ssmith-nova
    New Contributor III
    2 months ago

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

    Thanks,

    Scott

  • KarlT's avatar
    KarlT
    Contributor III
    2 months ago

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

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