First time here? We are a friendly community of Power Systems Engineers. Check out the FAQ!

I try to read the .out file in excel but it gives me the following typeerror: an integer is required

asked Mar 8 '3

Juan
21 ●18 ●19 ●23

updated Mar 8 '3

import pandas as pd

import dyntools

archivoout="OutBDDV33.out"

datosexcel = dyntools.CHNF(archivoout)

datos_excel.xlsout(channels='', show=False)

Worbook1 = 'Out_BDDV33.out.xlsx'

df=pd.read_excel(Worbook1 )

print(df.head())

add a comment

1 answer

Sort by » oldest newest most voted

answered Mar 9 '3

jconto
2766 ●10 ●30 ●41

Added parameter "outvrsn=0" to "CHNF" call. Now the code works ok in v.33, v.34 and v.35:

import pandas as pd
import psse35           # update for v.33, 34, 35
import dyntools

archivoout="IEEE39_flat.out"
datos_excel = dyntools.CHNF(archivoout,outvrsn=0)
datos_excel.xlsout(channels='', show=False)         #export ALL channels!
Worbook1 = 'IEEE39_flat.xlsx'
df=pd.read_excel(Worbook1)
print(df.head())