Ask Your Question
0

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

asked 2023-03-08 15:31:10 -0500

Juan gravatar image

updated 2023-03-08 15:33:28 -0500

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())

edit retag flag offensive close merge delete

1 answer

Sort by ยป oldest newest most voted
0

answered 2023-03-08 20:13:09 -0500

jconto gravatar image

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())
edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

[hide preview]

Question Tools

1 follower

Stats

Asked: 2023-03-08 15:31:10 -0500

Seen: 165 times

Last updated: Mar 08 '23