HI, I'm using excelpy set complex value to excel, I got the wrong :
ierr, totalload = psspy.systot('LOAD')
I used (set_cell) before but no work, I want to write the complex value of this API into excel,how do I do this? In addition, how to do if it is an array value(another api )?
Yes, you can do it with formula COMPLEX!
First, define a function converting the complex value to an Excel complex formula:
def complex_formula(cmplx):
return "=complex("+str(cmplx.real)+","+str(cmplx.imag)+")"
Then use the function when writing to Excel:
wb.set_cell((1,'a'),complex_formula(totalload))
import excelpy
ierr, totalload = psspy.systot('LOAD')
P = totalload.real Q = totalload.imag
wb = excelpy.workbook()
wb.setcell('A1', P) wb.setcell('B1', Q)
I'm sure you can elaborate on that basic code.
You cannot export complex numbers using this set_cell function, only real numbers. That's why I am exporting P and Q into separate cells. If you try to export a complex number you get this error message.
TypeError: Objects of type 'complex' can not be converted to a COM VARIANT
Asked: 2018-04-26 03:06:43 -0500
Seen: 675 times
Last updated: Apr 27 '18
whit loves you. Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
