Forum Discussion

prash4030's avatar
prash4030
New Contributor III
2 years ago

Refresh XFGETCELL excel sheet

Hello,

Is it possible to refresh XFGETCELL (excel report) automatically through OneStream and save report as offline? i was trying to achieve this by uploading excel report as .xfdoc.xlsx but i want the output as paste special values. thank you

 

Excel Add In
  • Dominic_A's avatar
    Dominic_A
    Contributor
    2 years ago

    I have not tried with XFGETCELL formulas.
    I know of users with Cube Views in extensible documents to achieve this.
    Some Report Books have a loop for e.g. [Member].ChildrenInclusive to have static snapshot reports over multiple tabs.
    There could be a dashboard with a parametrized selection prior to the extract, where the selected member name can then be used to name the report.

  • prash4030's avatar
    prash4030
    New Contributor III
    2 years ago

    hi, 

    thanks for your reply. Yes, we've used cube views in extensible document but i'm specifically trying XFGETCELL to work.