Skip to main content
P
prash4030
Newcomer
July 6, 2023

Refresh XFGETCELL excel sheet

  • July 6, 2023
  • 2 replies
  • 0 views

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

 

    2 replies

    D
    OneStream Employee
    Dominic_AOneStream Employee
    OneStream Employee
    July 6, 2023

    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.

    P
    prash4030Author
    Newcomer
    July 13, 2023

    hi, 

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

    Terms & ConditionsAccessibility statement