Revision history [back]
 | 1 | initial version |
Hello Jconto, Thank you so much for your help. It was great to find the whole list of arguments of excelpy in your python file. I was using the file and encountered this following error. Although it is not exactly linked, I would appreciate your guidance. I am using a piece of code and the value of AllLoad is returning as [Null]. I am not able to trace the error here. Also, I was trying to export the information to an excel using set_range function. Am I going in the right direction?
areas = [5201, 5301, 5401, 5501, 5601, 5701, 5801, 5902]
The PSSE Case has the areas as above
psspy.bsys(sid=0, numarea=len(areas), areas=areas) ierr, AllLoad = psspy.aareareal(sid=0,string='PLOAD') AllLoad xl.set_range(2, 4, AllLoad, fontStyle = 'Arial',fontColor = 'Red')
| | 2 | No.2 Revision |
Hello Jconto, Thank you so much for your help. It was great to find the whole list of arguments of excelpy in your python file. I was using the file and encountered this following error. Although it is not exactly linked, I would appreciate your guidance. I am using a piece of code and the value of AllLoad is returning as [Null]. I am not able to trace the error here. Also, I was trying to export the information to an excel using set_range function. Am I going in the right direction?
areas = [5201, 5301, 5401, 5501, 5601, 5701, 5801, 5902]
The PSSE Case has the areas as above
psspy.bsys(sid=0, numarea=len(areas), areas=areas) ierr, AllLoad = psspy.aareareal(sid=0,string='PLOAD') AllLoad xl.set_range(2, 4, AllLoad, fontStyle = 'Arial',fontColor = 'Red')
Also, the following code is giving an output in excel that is not really comprehendable to me: buses = [524003, 521011, 524001, 521001, 524005, 514001, 524006, 524007, 524009] psspy.bsys(sid=0, numbus=len(buses), buses=buses) ierr, volts = psspy.abusreal (sid=0,string='KV') volts
ierr, AllLoad = psspy.aareareal(sid=0,string='PLOAD')
AllLoad
xl.setrange(2, 4, volts, fontStyle = 'Arial',fontColor = 'Red') xl.setrange(3, 4, buses, fontStyle = 'Arial',fontColor = 'Red')
volts = 407.2868347 134.6368866 134.2896271 412.4360046 407.9005737 404.2839661 411.1826477 407.6182861 410.2168579 buses = 524003 521011 524001 521001 524005 514001 524006 524007 524009
Here, the buses Matrix is in the same order in which it has been entered. But, the voltage matrix seems to be undergoing some type of sorting based on Voltage Level. So the 400 kV buses do not correspond to it's voltage at output. Could you please explain the reason?
