Skip to main content
C
CarmenBrower
Newcomer
August 10, 2022

Is it possible to load data via excel with an XF formula?

  • August 10, 2022
  • 5 replies
  • 3 views

I am knew to the OneStream Software. Is there a way to load data outside of a form, and not through workflow? Meaning, is there an xf formula that can be used in excel that will write to a specific data intersection?

5 replies

P
PeterFu
Newcomer
August 11, 2022

Hi Carmen,

 

Yes, OneStream has a XFSetCell formula. See print screen below.

 

PeterFu_0-1660198013567.png

 

Peter

    ChristianW
    Advisor
    ChristianWAdvisor
    Advisor
    August 11, 2022

    Peter is correct, you can load via excel functions to OneStream, but it will load to o#forms and not to o#import.

    If you need to load to o#import, then you need to use WF and the excel load capabilities.

    Terms & ConditionsAccessibility statement