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.
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)
Asked: 2013-04-17 00:10:48 -0500
Seen: 1,414 times
Last updated: Apr 19 '13
whit loves you. Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.