Forum Discussion

CarmenBrower's avatar
CarmenBrower
New Contributor II
3 years ago

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

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 d...
Excel Add In
PeterFu's avatar
PeterFu
Contributor II

Hi Carmen,

 

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

 

 

Peter

ChristianW's avatar
ChristianW
Valued Contributor
3 years ago

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.