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))
thanks your advice!
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
This method I have tried, but there is no way to let P + jQ, output to the excel in one cell ?
Comments