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
  • 1 reply
  • 0 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?

1 reply

P
PeterFu
Newcomer
August 11, 2022

Hi Carmen,

 

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

 

PeterFu_0-1660198013567.png

 

Peter

    C
    OneStream Employee
    ChristianWOneStream Employee
    OneStream Employee
    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