cp27643's profile - activity

There is no fill method in excelpy, but there is font color changes and some other formatting methods available that might be of some use. You'd essentially be post processing after exporting the data to an excel workbook. I'd recommned importing excelpy and running help(excelpy) in the terminal to get the docstrings of the module and paste those into notepad and have a look around to see all of the methods available to you.

import excelpy

save_location = r'C:\Users\cphillips2\Downloads\testing1.xlsx'

wb = excelpy.workbook()

wb.set_cell('a2', 'Hello World')

wb.font_color(address='a2', color='green')

wb.save(save_location)

wb.close()

If you are generally needing more complex formatting, I'd look to excelpy to get the data from pss/e to excel, but then another module like xlrd or xlwings to post process the excel file and format how you'd like it.

Looking for a way to find the records in network data regardless of data type with yellow cells like shown in the link below...

imgur.com/a/Gjkr43E

Not yet, but in the script that I wrote I was avoiding returning multiple elements in a list and simply creating a subsystem for a single bus at a time so I knew the only values being returned were for that specific bus..

Can I trust psspy.abusint(sid=-1, string=["NUMBER"]) and psspy.abusreal(sid=-1, string=["VOLTAGE"]) to both return arrays in the same sorted order so that the voltages are in the same order as the bus numbers?