0

Help update data in PSSE by Python 2.7 get data from excel file.

Hi all I want to update data of Bus in PSSE by Python 2.7, get data from excel. My code:

import os, sys
PYTHONPATH = r'C:\Program Files (x86)\PTI\PSSE33\PSSBIN'
sys.path.append(PYTHONPATH)
os.environ['PATH'] += ';' + PYTHONPATH
import psspy
psspy.throwPsseExceptions = True
import redirect
redirect.psse2py()
psspy.psseinit(1000)
psspy.case(r'C:\Users\ngoclq\Desktop\TEST PYTHON\QNPC.sav')
import xlrd
bus_excel_location = "C:/Users/ngoclq/Desktop/TEST PYTHON/Bus.xlsx" 
bus= xlrd.open_workbook(bus_excel_location)
bussheet= bus.sheet_by_index(0) 
bussheet.cell_value(0,0)
bussheet.nrows
bussheet.ncols

intgar=[0, 0, 0, 0]
realar=[0, 0, 0, 0, 0, 0, 0]
for k in range(1,bussheet.nrows):
    intgar[0]=bussheet.cell_value(k,9)
    intgar[1]=bussheet.cell_value(k,3)           
    intgar[2]=bussheet.cell_value(k,5)
    intgar[3]=bussheet.cell_value(k,7)    
    realar[0]=bussheet.cell_value(k,2)
    realar[1]=bussheet.cell_value(k,10)
    realar[2]=bussheet.cell_value(k,11)
    realar[3]=bussheet.cell_value(k,12)
    realar[4]=bussheet.cell_value(k,13)
    realar[5]=bussheet.cell_value(k,14)
    realar[6]=bussheet.cell_value(k,15)
    i=bussheet.cell_value(k,0)
    name=bussheet.cell_value(k,1)
    ierr=psspy.bus_data_3(i,intgar,realar,name)

Please help me show any error on that code and how to run python file .py to update data of bus as data on my excel file Tks for helps.

ngoclq.evncpc's avatar
1
ngoclq.evncpc
asked 2020-05-06 20:28:47 -0500
perolofl's avatar
3.8k
perolofl
updated 2020-05-07 03:37:37 -0500
edit flag offensive 0 remove flag close merge delete

Comments

add a comment see more comments

1 Answer

0

can you post a few rows from the Bus.xlsx file?

You may explicitly define integer or floating vars like:

intgar[3]= int(bussheet.cell_value(k,7))    
realar[0]= float(bussheet.cell_value(k,2))
jconto's avatar
2.9k
jconto
answered 2020-05-07 14:30:19 -0500
edit flag offensive 0 remove flag delete link

Comments

Tks for help! Bus excel like csv file exported from PSSE. I also tried convert like you said, but not So I found new method: result of my code is a list of coder format BAT_DATA_... to run direct on PSSE cmd

ngoclq.evncpc's avatar ngoclq.evncpc (2020-05-12 22:17:13 -0500) edit
add a comment see more comments

Your Answer

Login/Signup to Answer