Import from excel to PSSE

asked 2013-04-17 00:10:48 -0600

USMAN KHALID
11 ●1 ●1 ●2

I want to generate a list that include bus#, gen ID, Pgen, Pmax, Qgen, Qmax of a specific area. The list produced should be editable form and while editing it should give total MW change. Is it possible that we import the list from PSSE to excel and after changing import back to PSSE? If yes,then how to do it?

edit retag flag offensive close merge delete

add a comment

1

answered 2013-04-19 07:09:37 -0600

jsexauer

586 ●4 ●11 ●18

You could do this using python, but it would be overkill. Assuming you are using PSS/E ver 30 or newer, use the GUI.

Create a subsystem for the area you want study
Click on the "Machine" tab.
Select all the rows. Copy-paste them into excel.

Hope this is clear.

edit flag offensive delete link

Comments

Agreed, the GUI in PSSE is more than capable here. A good choice.

JervisW ( 2013-04-20 05:05:24 -0600 )edit

add a comment

0

answered 2013-04-19 09:35:59 -0600

rimux
286 ●1 ●9

I am doing like this:

from win32com.client import Dispatch
xlApp = Dispatch("Excel.Application")

def XLSReadValue(xbook,xsheet,cell,x,y): #x,y - offset from cell
  value = xlApp.Workbooks(xbook).Sheets(xsheet).Range(cell).Offset(x+1,y+1).Value
return value

def XLSWriteValue(xbook,xsheet,cell,x,y,value): #x,y - offset from cell
  xlApp.Workbooks(xbook).Sheets(xsheet).Range(cell).Offset(x+1,y+1).Value=value

Than, if I want to get from excel value from cell A1:

n=XLSReadValue('book.xls','sheet1','A1',0,0)

edit flag offensive delete link

add a comment

Import from excel to PSSE

2 answers

Comments

Your Answer

Question Tools

Stats

Related questions