The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
Username:
 Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum for Programming
 Forum for Python
 access workbook or sheet by longname		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

raptor0815

2 Posts
Posted - 03/10/2024 :  1:28:15 PM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Origin Ver. and Service Release (Select Help-->About Origin): 10.1.0.178
Operating System: win 10 or 11

how to do this with python?

thank you

ChaoC

USA
174 Posts
Posted - 03/11/2024 :  09:24:19 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hello raptor0815,

You can use find_sheet() and find_book()
https://docs.originlab.com/originpro/namespaceoriginpro_1_1project.html#a69364cc2d546246b7a50752a2b1c713a

https://docs.originlab.com/originpro/namespaceoriginpro_1_1project.html#a043e2627e8b3bf38a29dfebabb934d78

E.g.

wbk=op.find_book('w','["Long Name"]') //refer to Book by LN

wks=op.find_sheet('w','[Book1]"Long Name") //refer to Sheet by LN
wks=op.find_sheet('w','["Long Name"]"Long Name"')


Documentation on Origin range strings:
https://www.originlab.com/doc/en/LabTalk/guide/Range-Notation#Types_of_Range_Data

Best,
Chao
Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000