Forum Discussion

mireles's avatar
mireles
New Contributor III
11 months 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
    11 months 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 III
11 months 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
Valued Contributor
11 months 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 III
    11 months ago

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