quote:

---

Originally posted by ryuutakenaka

Origin Ver. and Service Release : 8.0
Operating System: Win 8

Hi,

Is there an easy way to plot data in Origin with Python? I managed to connect to Origin through COM module, by following this guide:

http://ocwiki.originlab.com/index.php?title=OriginCOM:Application-PutWorksheet

It's working fine but now I also need to make a simple line plot of the data from the worksheet, set some axes titles, scale, etc. I can't find any information on how to do this in Python. Can anyone help?

Thank you,
Ryuu

---

gpname = origin.CreatePage(3, "PyGaph", "otp4py")

gl = origin.FindGraphLayer(gpname)
gl.DataPlots.Add(dr, 200)

origin.Execute("y1 = -2; y2 = 2;", gpname)

origin.Execute("label -xb X Title;", gpname)

import random # for creating random data
import win32com.client # COM module for communication with Origin

# Connect to Origin
origin = win32com.client.Dispatch("Origin.ApplicationSI") 
origin.visible = 1 # Make Origin window visible

# Create a new workbook named "Python" using the "origin" template
pageName = origin.CreatePage(2, "Python", "origin")

# Put the X and Y data into the worksheet
xData = range(0, 101, 2)
yData = [random.random() for x in xData]
origin.PutWorksheet(pageName, xData, 0, 0) # row 0, col 0
origin.PutWorksheet(pageName, yData, 0, 1) # row 0, col 1

# Create a Data Range
wks = origin.FindWorksheet(pageName)
dr = wks.NewDataRange
dr.Add("X", wks, 0, 0, -1, 0)
dr.Add("Y", wks, 0, 1, -1, 1)

# Create a Graph Layer
gpname = origin.CreatePage(3, "PyGraph", "otp4py")

# Add Data Plot to Graph Layer
gl = origin.FindGraphLayer(gpname)
gl.DataPlots.Add(dr, 200)

# Manipulate format settings (if Graph Template "otp4py" is unavailable)
origin.Execute("y1 = -2; y2 = 2;", gpname) # set y scale from -2 to 2
origin.Execute("x1 = 0; x2 = 100;", gpname) # set x scale from 0 to 100
origin.Execute("label -xb X Title;", gpname) # set x axis title to "X Title"
origin.Execute("label -yb Y Title;", gpname) # set y axis title to "Y Title"

# Clear all variables
import sys
sys.modules[__name__].__dict__.clear()

import win32com.client 

origin = win32com.client.Dispatch("Origin.ApplicationSI") 
origin.visible = 1

fldr = origin.RootFolder.Folders
fldr.Add("sample folder")

quote:

---

Originally posted by ryuutakenaka

Another question... Now I'm trying to make a folder inside my Origin project with the code, adapted from VB example available here:
http://ocwiki.originlab.com/index.php?title=OriginCOM:Folders-FolderFromPath#VB

The simple code:

import win32com.client 

origin = win32com.client.Dispatch("Origin.ApplicationSI") 
origin.visible = 1

fldr = origin.RootFolder.Folders
fldr.Add("sample folder")

is giving me a "pywintypes.com_error: (-2147352573, 'Member not found.', None, None)"

What am I doing wrong?

---

fldr = origin.RootFolder.Folders.Add
fldr.Name = "sample folder"

origin.RootFolder.Folders.Add.Name = "sample folder"

quote:

---

Originally posted by ryuutakenaka

Origin Ver. and Service Release : 8.0
Operating System: Win 8

Hi,

Is there an easy way to plot data in Origin with Python? I managed to connect to Origin through COM module, by following this guide:

http://ocwiki.originlab.com/index.php?title=OriginCOM:Application-PutWorksheet

It's working fine but now I also need to make a simple line plot of the data from the worksheet, set some axes titles, scale, etc. I can't find any information on how to do this in Python. Can anyone help?

Thank you,
Ryuu

---