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?
You could do this using python, but it would be overkill. Assuming you are using PSS/E ver 30 or newer, use the GUI.
Hope this is clear.
Agreed, the GUI in PSSE is more than capable here. A good choice.
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)
Comments