import originpro as op

book = op.new_book()

book.name = 'mybook'
bn = book.name

book.lname = 'My Book Long Name'
bln = book.lname

book.set_str('comments', 'These are some book comments')
bc = book.get_str('comments')

wks = book[0]

wks.name = 'mysheet'
wn = wks.name

wks.lname = 'My Sheet Long Name'
wln = wks.lname

# Whoops these won't work!
wks.set_str('comments', 'These are some sheet comments')
wc = wks.get_str('comments')

# But these will
wks.obj.Comments = 'These are some sheet comments'
wc = wks.obj.Comments

gr = op.new_graph()

gr.name = 'mygraph'
gn = gr.name

gr.lname = 'My Graph Long Name'
gln = gr.lname

gr.set_str('comments', 'These are some graph comments')
cc = gr.get_str('comments')

import originpro as op
wks = op.new_sheet()
wks.set_str('tree.data.name', 'Larry')
wks.set_int('tree.data.age', 37)
wks.set_float('tree.data.mean', 23.56)

#access as xml tree
trWks = wks.usertree
trData = trWks.find('data')
for child in trData:
    print(f'{child.tag} = {child.text}')

#or you can access it as a dict
dd = wks.userprops['data']
print(dd)

quote:

---

Originally posted by YimingChen

Access to worksheet user tree was added in Origin 2021b, namely .userprops as a dict or .usertree as an xml ElementTree, see the code below:

import originpro as op
wks = op.new_sheet()
wks.set_str('tree.data.name', 'Larry')
wks.set_int('tree.data.age', 37)
wks.set_float('tree.data.mean', 23.56)

#access as xml tree
trWks = wks.usertree
trData = trWks.find('data')
for child in trData:
    print(f'{child.tag} = {child.text}')

#or you can access it as a dict
dd = wks.userprops['data']
print(dd)

James

---