Forum Discussion

MRE's avatar
MRE
New Contributor
3 months ago

Upload data to OneStream with Excel add-inn

Hi all,

I am trying to upload data to the text field Text3 in a UD2 dimension. I have been looking around in the available functions in the OneStream excel add-in, but I am not sure which one is the best for this.

I tried the function  XFSetCell, however this function saves data to the amount field based on the Parameters supplied. I only need to upload a string of text to the Text 3 field of a UD2 member:

Thank you all for your help!

 

 

 

Excel Add In

1 Reply

Sort By
  • jbrem's avatar
    jbrem
    New Contributor III
    3 months ago

    I think you would need to use the excel metadata builder template and load it.  I could definitely be wrong here, but I don't think any of the OS excel addin functionality will allow you to make metadata changes.  Those functions would be more for sending data to an intersection (ie for planning)