#This example requires to install OriginExt package
import OriginExt as oe

#keep one copy of Origin running only
app = oe.ApplicationSI()
app.Visible = app.MAINWND_SHOW

#Assume the sample project file is in Origin's User Files folder
uff = app.Path(app.APPPATH_USER)
strOpju = uff + 'PyGraphEx.opju'

app.Load( strOpju, False )

bkNames=['Book1', 'Book2']
#Change y data in Book1 and Book2 with following data and update graph
bkData = [ [20.89296, 0.22387, 54.95409, 0.10471, 1.90546, 60.25596],
           [0.00251, 0.00354, 0.00225, 0.00383, 0.00296, 0.0023],
           [0.20893, 5.7544, 1.04713, 2.51189, 0.1122, 24.54709, 0.70795],
           [0.00475, 0.00325, 0.004, 0.00359, 0.00512, 0.00278, 0.00406],
           [3.23594, 54.95409, 0.14454, 4.46684, 0.6166],
           [0.00418, 0.00282, 0.0066, 0.004, 0.00536],
           [23.98833, 1.58489, 34.67369, 13.18257, 75.85776],
           [0.0068, 0.00957, 0.00658, 0.00724, 0.00584],
           [95.49926, 5.01187, 10.47129, 1.25893, 9.77237, 16.2181, 23.44229],
           [0.00631, 0.01006, 0.00875, 0.01224, 0.00896, 0.00819, 0.00769],
           [10.71519, 11.74898, 89.12509, 1.12202, 32.35937, 1.44544] ]

for i, strbk in enumerate( bkNames ):
    sheet = app.FindWorksheet( strbk )
    bk = sheet.Parent
    #Change data in first three sheets in each book
    for j in range(3):
        bk[j].SetData( bkData[ 2*j+6*i : 2*j+2+6*i ] )

#Delete Book3 and the legend for its curves in the graph
app.DestroyPage('Book3')

gl = app.FindGraphLayer( 'Graph1' )
#Execute LT on the context of the graph layer
gl.LT_execute( 'label -r Legend3;' )

#Force to recalculate apparant linear fit before exporting graphs
app.LT_execute( 'run -p au;')

#Export Graph1 to a custom folder. File name is Test.png and width is 2000.
imgPath='C:\\Test'
app.LT_set_str( '%A', imgPath )
gp = gl.Parent
gp.LT_execute( 'expGraph type:=png filename:=Test path:=%A overwrite:=replace tr1.Unit:=2 tr1.Width:=2000' )

print( 'Graph is exported to: %s\Test.png .' %(imgPath) )

#Exit Origin
app.Exit()
del app