File Exchange
Try Origin for Free
The Origin Forum
Home
|
Profile
|
Register
|
Active Topics
|
Members
|
Search
|
FAQ
|
Send File to Tech support
All Forums
Origin Forum for Programming
Forum for Python
access workbook or sheet by longname
Note:
You must be registered in order to post a reply.
To register,
click here
. Registration is FREE!
Screensize:
640 x 480
800 x 600
1024 x 768
1280 x 1024
UserName:
Password:
Anti-Spam Code:
Format Mode:
Basic
Help
Prompt
Format:
Font
Andale Mono
Arial
Arial Black
Book Antiqua
Century Gothic
Comic Sans MS
Courier New
Georgia
Impact
Lucida Console
Script MT Bold
Stencil
Tahoma
Times New Roman
Trebuchet MS
Verdana
Size
1
2
3
4
5
6
Color
Black
Red
Yellow
Pink
Green
Orange
Purple
Blue
Beige
Brown
Teal
Navy
Maroon
LimeGreen
Message:
* HTML is OFF
*
Forum Code
is ON
Smilies
Check here to include your profile signature.
Check here to subscribe to this topic.
T O P I C R E V I E W
raptor0815
Posted - 03/10/2024 : 1:28:15 PM
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
1 L A T E S T R E P L I E S (Newest First)
ChaoC
Posted - 03/11/2024 : 09:24:19 AM
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
The Origin Forum
© 2020 Originlab Corporation
Snitz Forums 2000