Forum Discussion

mireles's avatar
mireles
New Contributor II
8 days ago
Solved

How to save the outputs of ExportCubeViewGridsToExcelFile() to a .xlsx file?

I've tried to implement this function as per the Business Rules Editor snippet: Dim objByte() As Byte() = BRApi.CubeViews.Process.ExportCubeViewGridsToExcelFile(si, custSubstVarsForAllCubeViews, c...
Extenders
  • MarcusH's avatar
    MarcusH
    6 days ago

    Which download button are you using?

    Button 1 downloads in 'OneStream format' i.e. xml. Button 2 downloads in file format eg xlsx

mireles's avatar
mireles
New Contributor II
6 days ago

Hi Marcus, thank you so much for your reply! Unfortunately the file is still being saved as an XML. To clarify, when I download it to my computer it is saved as an XML. When I try to open it from the OneStream file explorer it does open in Excel but with no content.

MarcusH's avatar
MarcusH
Contributor III
6 days ago

Which download button are you using?

Button 1 downloads in 'OneStream format' i.e. xml. Button 2 downloads in file format eg xlsx

  • mireles's avatar
    mireles
    New Contributor II
    6 days ago

    Wow, I can't believe the solution was so simple! Thank you so much and sorry for the oversight.