Revision history [back]

Hello, I am writing because I have around 50 .out files. Inside each simulation, I have several channels. I would like to export all of them into an excel file. file or a txt. I tried to export with a function named " dyntools" and also with "excelpy" but it does not work. I had the following errors and I don´t know how could I solve. have not got Matlab in my computer so I cannot used the function plt or numpy. Someone knows, How could create an excel file? Could I create a TXT instead and EXCEL file with all the channels info to avoid the overflow error?error? Could I do a txt file with all the channels without created a graph in python?

    import excelpy
    import dyntools

# LF process

# Channels identification

psspy.delete_all_plot_channels()
psspy.bsys(1,0,[0.0,0.0],0,[],3,[PCC_bus,WTG_bus_1,WTG_bus_2],0,[],0,[])
psspy.chsb(0,1,[-1,-1,-1,1,2,0])
psspy.chsb(0,1,[-1,-1,-1,1,3,0])
psspy.chsb(0,1,[-1,-1,-1,1,12,0])
psspy.chsb(0,1,[-1,-1,-1,1,13,0])
psspy.chsb(0,1,[-1,-1,-1,1,16,0])

LVRT

psspy.strt_2([0,0],out_file11)
psspy.run(0,3.0,L1,L2,L3)
psspy.dist_bus_fault(PCC_bus,3,HV_PCC,[0.0,0.0])
psspy.run(0,3.12,L1,L2,L3)
psspy.dist_clear_fault(1)
psspy.run(0,ttime50,L1,L2,L3)

*PROBLEM: EXPORT ALL CHANNELS TO EXCEL FILE *

I tried to do extract the excel file in two different ways.

Firstly, I used the xlsout but the excel is not created. The channel did not paste in the excel file

chnfobj = dyntools.CHNF(out_file11)
short_title, chanid, chandata = chnfobj.get_data()

print short_title
print chanid
print chandata

t = chandata = ['time']
p = chandata = [1]

XLSfile = 'Case5_1.xls'
sheetname= 'Hoja1'
chnfobj.xlsout(channels=[1],outfile=out_file11,xlsfile=XLSfile,sheet=sheetname,show=False)

ERROR

 Messages for api BRANCH_CHNG_3
 No network data in memory   (005188)

 Messages for api BRANCH_CHNG_3
 No network data in memory   (005188)

 Messages for api MACHINE_CHNG_2
 No network data in memory   (005188)

 Messages for api MACHINE_CHNG_2
 No network data in memory   (005188)

* Create an excel file by excelpy, I get and overflow error*

outfile = dyntools.CHNF(out_file11)
xl = excelpy.workbook(xlsfile='Case5_1.xlsx', mode='w')
xl.set_range(1, 'a', [short_title])
xl.save()
xl.close()

ERROR MESSAGE

 File "C:\path\Case5_1.py", line 52, in <module>

Sh ort_title, chanid_dict, chandata_dict = out

 file.get_data()
        File ".\dyntools.py", line 1458, in get_data
        File ".\dyntools.py", line 868, in get_chdata
        File ".\dyntools.py", line 255, in _get_chdata
        File ".\dyntools.py", line 540, in _validate_channels
        OverflowError ange() result has too many items

Hello, I am writing because I have around 50 .out files. Inside each simulation, I have several channels. I would like to export all of them into an excel file or a txt. I tried to export with a function named " dyntools" and also with "excelpy" but it does not work. I have not got Matlab in my computer so I cannot used the function plt or numpy. Someone knows, How could create an excel file? Could I create a TXT instead and EXCEL file with all the channels info to avoid the overflow error? Could I do a txt file with all the channels without created a graph in python?

    import excelpy
    import dyntools

# LF process

# Channels identification

psspy.delete_all_plot_channels()
psspy.bsys(1,0,[0.0,0.0],0,[],3,[PCC_bus,WTG_bus_1,WTG_bus_2],0,[],0,[])
psspy.chsb(0,1,[-1,-1,-1,1,2,0])
psspy.chsb(0,1,[-1,-1,-1,1,3,0])
psspy.chsb(0,1,[-1,-1,-1,1,12,0])
psspy.chsb(0,1,[-1,-1,-1,1,13,0])
psspy.chsb(0,1,[-1,-1,-1,1,16,0])

LVRT

psspy.strt_2([0,0],out_file11)
psspy.run(0,3.0,L1,L2,L3)
psspy.dist_bus_fault(PCC_bus,3,HV_PCC,[0.0,0.0])
psspy.run(0,3.12,L1,L2,L3)
psspy.dist_clear_fault(1)
psspy.run(0,ttime50,L1,L2,L3)

*PROBLEM: EXPORT ALL CHANNELS TO EXCEL FILE *

I tried to do extract the excel excel/txt file all channels of the .*.out in two different ways.

Firstly, I used the xlsout but the excel is not created. created and also it is not filled in. The channel did not paste in the excel file

chnfobj = dyntools.CHNF(out_file11)
short_title, chanid, chandata = chnfobj.get_data()

print short_title
print chanid
print chandata

t = chandata = ['time']
p = chandata = [1]

XLSfile = 'Case5_1.xls'
sheetname= 'Hoja1'
chnfobj.xlsout(channels=[1],outfile=out_file11,xlsfile=XLSfile,sheet=sheetname,show=False)

ERROR

 Messages for api BRANCH_CHNG_3
 No network data in memory   (005188)

 Messages for api BRANCH_CHNG_3
 No network data in memory   (005188)

 Messages for api MACHINE_CHNG_2
 No network data in memory   (005188)

 Messages for api MACHINE_CHNG_2
 No network data in memory   (005188)

* Create an excel file by excelpy, I get and overflow error*

 outfile = dyntools.CHNF(out_file11)
dyntools.CHNF(out_file11) 
 short_title, chanid, chandata = chnfobj.get_data()
    xl = excelpy.workbook(xlsfile='Case5_1.xlsx', mode='w')
 xl.set_range(1, 'a', [short_title])
 xl.save()
 xl.close()

ERROR MESSAGE

 File "C:\path\Case5_1.py", line 52, in <module>

Sh ort_title, chanid_dict, chandata_dict = out

 file.get_data()
        File ".\dyntools.py", line 1458, in get_data
        File ".\dyntools.py", line 868, in get_chdata
        File ".\dyntools.py", line 255, in _get_chdata
        File ".\dyntools.py", line 540, in _validate_channels
        OverflowError ange() result has too many items

Hello, I am writing because I have around 50 .out files. Inside each simulation, I have several channels. I would like to export all of them into an excel file or a txt. I tried to export with a function named " dyntools" and also with "excelpy" but it does not work. I have not got Matlab in my computer so I cannot used the function plt or numpy. Someone knows, How could create an excel file? Could I create a TXT instead and EXCEL file with all the channels info to avoid the overflow error? Could I do a txt file with all the channels without created a graph in python?

    import excelpy
    import dyntools

# LF process

# Channels identification

psspy.delete_all_plot_channels()
psspy.bsys(1,0,[0.0,0.0],0,[],3,[PCC_bus,WTG_bus_1,WTG_bus_2],0,[],0,[])
psspy.chsb(0,1,[-1,-1,-1,1,2,0])
psspy.chsb(0,1,[-1,-1,-1,1,3,0])
psspy.chsb(0,1,[-1,-1,-1,1,12,0])
psspy.chsb(0,1,[-1,-1,-1,1,13,0])
psspy.chsb(0,1,[-1,-1,-1,1,16,0])

LVRT

psspy.strt_2([0,0],out_file11)
psspy.run(0,3.0,L1,L2,L3)
psspy.dist_bus_fault(PCC_bus,3,HV_PCC,[0.0,0.0])
psspy.run(0,3.12,L1,L2,L3)
psspy.dist_clear_fault(1)
psspy.run(0,ttime50,L1,L2,L3)

*PROBLEM: EXPORT ALL CHANNELS TO EXCEL FILE *

I tried to extract the excel/txt file all channels of the .*.out in two different ways.

Firstly, I used the xlsout but the excel is not created and also it is not filled in. The channel did not paste in the excel file

chnfobj = dyntools.CHNF(out_file11)
short_title, chanid, chandata = chnfobj.get_data()

print short_title
print chanid
print chandata

t = chandata = ['time']
p = chandata = [1]

XLSfile = 'Case5_1.xls'
sheetname= 'Hoja1'
chnfobj.xlsout(channels=[1],outfile=out_file11,xlsfile=XLSfile,sheet=sheetname,show=False)

ERROR

 Messages for api BRANCH_CHNG_3
 No network data in memory   (005188)

 Messages for api BRANCH_CHNG_3
 No network data in memory   (005188)

 Messages for api MACHINE_CHNG_2
 No network data in memory   (005188)

 Messages for api MACHINE_CHNG_2
 No network data in memory   (005188)

* Create an excel file by excelpy, I get and overflow error*

    outfile = dyntools.CHNF(out_file11) 
 short_title, chanid, chandata = chnfobj.get_data()
    xl = excelpy.workbook(xlsfile='Case5_1.xlsx', mode='w')
    xl.set_range(1, 'a', [short_title])
    xl.save()
    xl.close()

ERROR MESSAGE

 File "C:\path\Case5_1.py", line 52, in <module>

Sh ort_title, chanid_dict, chandata_dict = out

 file.get_data()
        File ".\dyntools.py", line 1458, in get_data
        File ".\dyntools.py", line 868, in get_chdata
        File ".\dyntools.py", line 255, in _get_chdata
        File ".\dyntools.py", line 540, in _validate_channels
        OverflowError ange() result has too many items

Hello, I am writing because I have around 50 .out files. Inside each simulation, I have several channels. I would like to export all of them into an excel file or a txt. I tried to export with a function named " dyntools" and also with "excelpy" but it does not work. I have not got Matlab in my computer so I cannot used the function plt or numpy. Someone knows, How could create an excel file? Could I create a TXT instead and EXCEL file with all the channels info to avoid the overflow error? Could I do a txt file with all the channels without created a graph in python?

    import excelpy
    import dyntools

# LF process

# Channels identification

psspy.delete_all_plot_channels()
psspy.bsys(1,0,[0.0,0.0],0,[],3,[PCC_bus,WTG_bus_1,WTG_bus_2],0,[],0,[])
psspy.chsb(0,1,[-1,-1,-1,1,2,0])
psspy.chsb(0,1,[-1,-1,-1,1,3,0])
psspy.chsb(0,1,[-1,-1,-1,1,12,0])
psspy.chsb(0,1,[-1,-1,-1,1,13,0])
psspy.chsb(0,1,[-1,-1,-1,1,16,0])

LVRT

psspy.strt_2([0,0],out_file11)
psspy.run(0,3.0,L1,L2,L3)
psspy.dist_bus_fault(PCC_bus,3,HV_PCC,[0.0,0.0])
psspy.run(0,3.12,L1,L2,L3)
psspy.dist_clear_fault(1)
psspy.run(0,ttime50,L1,L2,L3)

*PROBLEM: EXPORT ALL CHANNELS TO EXCEL FILE *

I tried to extract the excel/txt file all channels of the .*.out in two different ways.

Firstly, I used the xlsout but the excel is not created and also it is not filled in. The channel did not paste in the excel file

chnfobj = dyntools.CHNF(out_file11)
short_title, chanid, chandata = chnfobj.get_data()

print short_title
print chanid
print chandata

t = chandata = ['time']
p = chandata = [1]

XLSfile = 'Case5_1.xls'
sheetname= 'Hoja1'
chnfobj.xlsout(channels=[1],outfile=out_file11,xlsfile=XLSfile,sheet=sheetname,show=False)

ERROR

 Messages for api BRANCH_CHNG_3
 No network data in memory   (005188)

 Messages for api BRANCH_CHNG_3
 No network data in memory   (005188)

 Messages for api MACHINE_CHNG_2
 No network data in memory   (005188)

 Messages for api MACHINE_CHNG_2
 No network data in memory   (005188)

* Create an excel file by excelpy, I get and overflow error*

    outfile chnfobj = dyntools.CHNF(out_file11) 
 short_title, chanid, chandata = chnfobj.get_data()
 print short_title
print chanid
print chandata
p = chandata [2]
xl = excelpy.workbook(xlsfile='Case5_1.xlsx', mode='w')
 xl.set_range(1, 'a', [short_title])
    [p])
xl.save()
 xl.close()

ERROR MESSAGE

 File "C:\path\Case5_1.py", line 52, in <module>

Sh ort_title, chanid_dict, chandata_dict = out

 file.get_data()
        File ".\dyntools.py", line 1458, in get_data
        File ".\dyntools.py", line 868, in get_chdata
        File ".\dyntools.py", line 255, in _get_chdata
        File ".\dyntools.py", line 540, in _validate_channels
        OverflowError ange() result has too many items

Hello, I am writing because I have around 50 .out files. Inside each simulation, I have several channels. I would like to export all of them into an excel file or a txt. I tried to export with a function named " dyntools" and also with "excelpy" but it does not work. I have not got Matlab in my computer so I cannot used the function plt or numpy. Someone knows, How could create an excel file? Could I create a TXT instead and EXCEL file with all the channels info to avoid the overflow error? Could I do a txt file with all the channels without created a graph in python?

    import excelpy
    import dyntools

# LF process

# Channels identification

psspy.delete_all_plot_channels()
psspy.bsys(1,0,[0.0,0.0],0,[],3,[PCC_bus,WTG_bus_1,WTG_bus_2],0,[],0,[])
psspy.chsb(0,1,[-1,-1,-1,1,2,0])
psspy.chsb(0,1,[-1,-1,-1,1,3,0])
psspy.chsb(0,1,[-1,-1,-1,1,12,0])
psspy.chsb(0,1,[-1,-1,-1,1,13,0])
psspy.chsb(0,1,[-1,-1,-1,1,16,0])

LVRT

psspy.strt_2([0,0],out_file11)
psspy.run(0,3.0,L1,L2,L3)
psspy.dist_bus_fault(PCC_bus,3,HV_PCC,[0.0,0.0])
psspy.run(0,3.12,L1,L2,L3)
psspy.dist_clear_fault(1)
psspy.run(0,ttime50,L1,L2,L3)

*PROBLEM: EXPORT ALL CHANNELS TO EXCEL FILE *

I tried to extract the excel/txt file all channels of the .*.out .*.out, Firstly, I tried to export only one channel. However, I cannot achieve to record the channel [2] in two different ways.

Firstly, I used the xlsout but the the excel file. The excel is empty and I have not created and also it is not filled in. The channel did not paste in the excel fileobtained any error.

Root=os.getcwd()
chnfobj = dyntools.CHNF(out_file11)
dyntools.CHNF(out_file11) 
short_title, chanid, chandata = chnfobj.get_data()

print short_title
print chanid
print chandata

t = chandata = ['time']
p = chandata = [1]

XLSfile = 'Case5_1.xls'
sheetname= 'Hoja1'
chnfobj.xlsout(channels=[1],outfile=out_file11,xlsfile=XLSfile,sheet=sheetname,show=False)

ERROR

 Messages for api BRANCH_CHNG_3
 No network data in memory   (005188)

 Messages for api BRANCH_CHNG_3
 No network data in memory   (005188)

 Messages for api MACHINE_CHNG_2
 No network data in memory   (005188)

 Messages for api MACHINE_CHNG_2
 No network data in memory   (005188)

* Create an excel file by excelpy, I get and overflow error*

chnfobj = dyntools.CHNF(out_file11) 
short_title, chanid, chandata = chnfobj.get_data()
print short_title
print chanid
print chandata
p = chandata [2]

Hoja_Parque = Root + 'Case5_1.xlsx'
Hoja_Parque = Hoja_Parque.decode('latin1')
xl = excelpy.workbook(xlsfile='Case5_1.xlsx', excelpy.workbook(xlsfile=Hoja_Parque, mode='w')
xl.set_range(1, 'a', [p])
xl.save()
xl.close()

 File "C:\path\Case5_1.py", line 52, in <module>

Sh ort_title, chanid_dict, chandata_dict = out

 file.get_data()
        File ".\dyntools.py", line 1458, in get_data
        File ".\dyntools.py", line 868, in get_chdata
        File ".\dyntools.py", line 255, in _get_chdata
        File ".\dyntools.py", line 540, in _validate_channels
        OverflowError ange() result has too many items

Hello, I am writing because I have around 50 .out files. Inside each simulation, I have several channels. I would like to export all of them into an excel file or a txt. I tried to export with a function named " dyntools" and also with "excelpy" but it does not work. I have not got Matlab in my computer so I cannot used the function plt or numpy. Someone knows, How could create an excel file? Could I create a TXT instead and EXCEL file with all the channels info to avoid the overflow error? Could I do a txt file with all the channels without created a graph in python?

    import excelpy
    import dyntools

# LF process

# Channels identification

psspy.delete_all_plot_channels()
psspy.bsys(1,0,[0.0,0.0],0,[],3,[PCC_bus,WTG_bus_1,WTG_bus_2],0,[],0,[])
psspy.chsb(0,1,[-1,-1,-1,1,2,0])
psspy.chsb(0,1,[-1,-1,-1,1,3,0])
psspy.chsb(0,1,[-1,-1,-1,1,12,0])
psspy.chsb(0,1,[-1,-1,-1,1,13,0])
psspy.chsb(0,1,[-1,-1,-1,1,16,0])

LVRT

psspy.strt_2([0,0],out_file11)
psspy.run(0,3.0,L1,L2,L3)
psspy.dist_bus_fault(PCC_bus,3,HV_PCC,[0.0,0.0])
psspy.run(0,3.12,L1,L2,L3)
psspy.dist_clear_fault(1)
psspy.run(0,ttime50,L1,L2,L3)

*PROBLEM: EXPORT ALL CHANNELS TO EXCEL FILE *

I tried to extract the excel/txt file all channels of the .*.out, Firstly, I tried to export only one channel. However, I cannot achieve to record the channel [2] in the excel file. The excel is empty and I have not obtained any error.

Root=os.getcwd()
chnfobj = dyntools.CHNF(out_file11) 
short_title, chanid, chandata = chnfobj.get_data()

print short_title
print chanid
print chandata
p = chandata [2]

Hoja_Parque = Root + 'Case5_1.xlsx'
Hoja_Parque = Hoja_Parque.decode('latin1')
xl = excelpy.workbook(xlsfile=Hoja_Parque, mode='w')
xl.set_range(1, 'a', [p])
xl.save()
xl.close()

 chnfobj.xlsout(channels=[p], show=False, xlsfile= Hoja_Parque, outfile=out_file11, sheet ="'', overwritesheet=True)

Hello, I am writing because I have around 50 .out files. Inside each simulation, I have several channels. I would like to export all of them into an excel file or a txt. I tried to export with a function named " dyntools" and also with "excelpy" but it does not work. I have not got Matlab in my computer so I cannot used the function plt or numpy. Someone knows, How could create an excel file? Could I create a TXT instead and EXCEL file with all the channels info to avoid the overflow error? Could I do a txt file with all the channels without created a graph in python?

    import excelpy
    import dyntools

# LF process

# Channels identification

psspy.delete_all_plot_channels()
psspy.bsys(1,0,[0.0,0.0],0,[],3,[PCC_bus,WTG_bus_1,WTG_bus_2],0,[],0,[])
psspy.chsb(0,1,[-1,-1,-1,1,2,0])
psspy.chsb(0,1,[-1,-1,-1,1,3,0])
psspy.chsb(0,1,[-1,-1,-1,1,12,0])
psspy.chsb(0,1,[-1,-1,-1,1,13,0])
psspy.chsb(0,1,[-1,-1,-1,1,16,0])

LVRT

psspy.strt_2([0,0],out_file11)
psspy.run(0,3.0,L1,L2,L3)
psspy.dist_bus_fault(PCC_bus,3,HV_PCC,[0.0,0.0])
psspy.run(0,3.12,L1,L2,L3)
psspy.dist_clear_fault(1)
psspy.run(0,ttime50,L1,L2,L3)

*PROBLEM: EXPORT ALL CHANNELS TO EXCEL FILE *

I tried to extract the excel/txt file all channels of the .*.out, Firstly, I tried to export only one channel. However, I cannot achieve to record the channel [2] in the excel file. The excel is empty and I have not obtained any error.

out_file11 =r 'Case5_1.out'

Root=os.getcwd()
chnfobj = dyntools.CHNF(out_file11) 
short_title, chanid, chandata = chnfobj.get_data()

print short_title
print chanid
print chandata
p = chandata [2]

Hoja_Parque = Root + 'Case5_1.xlsx'
Hoja_Parque = Hoja_Parque.decode('latin1')
xl = excelpy.workbook(xlsfile=Hoja_Parque, mode='w')
xl.set_range(1, 'a', [p])
xl.save()
xl.close()

Also, I tried to export with the function xlsout but I did not have any results

 chnfobj.xlsout(channels=[p], show=False, xlsfile= Hoja_Parque, outfile=out_file11, sheet ="'', ='', overwritesheet=True)

Hello, I am writing because I have around 50 .out files. Inside each simulation, I have several channels. I would like to export all of them into an excel file or a txt. I tried to export with a function named " dyntools" and also with "excelpy" but it does not work. I have not got Matlab in my computer so I cannot used the function plt or numpy. Someone knows, How could create an excel file? Could I create a TXT instead and EXCEL file with all the channels info to avoid the overflow error? Could I do a txt file with all the channels without created a graph in python?

    import excelpy
    import dyntools

# LF process

# Channels identification

psspy.delete_all_plot_channels()
psspy.bsys(1,0,[0.0,0.0],0,[],3,[PCC_bus,WTG_bus_1,WTG_bus_2],0,[],0,[])
psspy.chsb(0,1,[-1,-1,-1,1,2,0])
psspy.chsb(0,1,[-1,-1,-1,1,3,0])
psspy.chsb(0,1,[-1,-1,-1,1,12,0])
psspy.chsb(0,1,[-1,-1,-1,1,13,0])
psspy.chsb(0,1,[-1,-1,-1,1,16,0])

LVRT

psspy.strt_2([0,0],out_file11)
psspy.run(0,3.0,L1,L2,L3)
psspy.dist_bus_fault(PCC_bus,3,HV_PCC,[0.0,0.0])
psspy.run(0,3.12,L1,L2,L3)
psspy.dist_clear_fault(1)
psspy.run(0,ttime50,L1,L2,L3)

*PROBLEM: EXPORT ALL OUT CHANNELS TO AN EXCEL FILE *

I tried to extract the excel/txt file all channels of the .*.out, Firstly, I tried to export only one channel. However, I cannot achieve to record the channel [2] in the excel file. The excel is empty and I have not obtained any error.

out_file11 =r 'Case5_1.out'

Root=os.getcwd()
chnfobj = dyntools.CHNF(out_file11) 
short_title, chanid, chandata = chnfobj.get_data()

print short_title
print chanid
print chandata
p = chandata [2]

Hoja_Parque = Root + 'Case5_1.xlsx'
Hoja_Parque = Hoja_Parque.decode('latin1')
xl = excelpy.workbook(xlsfile=Hoja_Parque, mode='w')
xl.set_range(1, 'a', [p])
xl.save()
xl.close()

Also, I tried to export with the function xlsout but I did not have any results

 chnfobj.xlsout(channels=[p], show=False, xlsfile= Hoja_Parque, outfile=out_file11, sheet ='', overwritesheet=True)

Hello, I am writing because I have around 50 .out files. Inside each simulation, I have several channels. I would like to export all of them into an excel file or a txt. I tried to export with a function named " dyntools" and also with "excelpy" but it does not work. I have not got Matlab in my computer so I cannot used the function plt or numpy. Someone knows, How could create an excel file? Could I create a TXT instead and EXCEL file with all the channels info to avoid the overflow error? Could I do a txt file with all the channels without created a graph in python?

    import excelpy
    import dyntools

# LF process

# Channels identification

psspy.delete_all_plot_channels()
psspy.bsys(1,0,[0.0,0.0],0,[],3,[PCC_bus,WTG_bus_1,WTG_bus_2],0,[],0,[])
psspy.chsb(0,1,[-1,-1,-1,1,2,0])
psspy.chsb(0,1,[-1,-1,-1,1,3,0])
psspy.chsb(0,1,[-1,-1,-1,1,12,0])
psspy.chsb(0,1,[-1,-1,-1,1,13,0])
psspy.chsb(0,1,[-1,-1,-1,1,16,0])

LVRT

psspy.strt_2([0,0],out_file11)
psspy.run(0,3.0,L1,L2,L3)
psspy.dist_bus_fault(PCC_bus,3,HV_PCC,[0.0,0.0])
psspy.run(0,3.12,L1,L2,L3)
psspy.dist_clear_fault(1)
psspy.run(0,ttime50,L1,L2,L3)

*PROBLEM: EXPORT ALL OUT CHANNELS TO AN EXCEL FILE *

I tried to extract the excel/txt file all channels of the .*.out, Firstly, I tried to export only one channel. However, I cannot achieve to record the channel [2] in the excel file. The excel is empty and I have not obtained any error.

Root=os.getcwd()
out_file11 =r 'Case5_1.out'

Root=os.getcwd()
= r'case5_1.out'
pn, x = os.path.splitext(out_file11)

out_list=[out_file11]

chnfobj = dyntools.CHNF(out_file11) 
short_title, chanid, chandata = chnfobj.get_data()

print short_title
print chanid
print chandata
p = chandata [2]

Hoja_Parque = Root + 'Case5_1.xlsx'
Hoja_Parque = Hoja_Parque.decode('latin1')
xl = excelpy.workbook(xlsfile=Hoja_Parque, mode='w')
xl.set_range(1, 'a', [p])
xl.save()
xl.close()
dyntools.CHNF(out_file11,outvrsn=0) 
print('\n Testing call to txtout')
chnfobj.txtout(channels=[1,4], txtfile=pn)

Also, I tried to export with the function xlsout but I did not have any results

 chnfobj.xlsout(channels=[p], show=False, xlsfile= Hoja_Parque, outfile=out_file11, sheet ='', overwritesheet=True)

Hello, I am writing because I have around 50 .out files. Inside each simulation, I have several channels. I would like to export all of them into an excel file or a txt. I tried to export with a function named " dyntools" and also with "excelpy" but it does not work. I have not got Matlab in my computer so I cannot used the function plt or numpy. Someone knows, How could create an excel file? Could I create a TXT instead and EXCEL file with all the channels info to avoid the overflow error? Could I do a txt file with all the channels without created a graph in python?

    import excelpy
    import dyntools

# LF process

# Channels identification

psspy.delete_all_plot_channels()
psspy.bsys(1,0,[0.0,0.0],0,[],3,[PCC_bus,WTG_bus_1,WTG_bus_2],0,[],0,[])
psspy.chsb(0,1,[-1,-1,-1,1,2,0])
psspy.chsb(0,1,[-1,-1,-1,1,3,0])
psspy.chsb(0,1,[-1,-1,-1,1,12,0])
psspy.chsb(0,1,[-1,-1,-1,1,13,0])
psspy.chsb(0,1,[-1,-1,-1,1,16,0])

LVRT

psspy.strt_2([0,0],out_file11)
psspy.run(0,3.0,L1,L2,L3)
psspy.dist_bus_fault(PCC_bus,3,HV_PCC,[0.0,0.0])
psspy.run(0,3.12,L1,L2,L3)
psspy.dist_clear_fault(1)
psspy.run(0,ttime50,L1,L2,L3)

*PROBLEM: EXPORT ALL OUT CHANNELS TO AN EXCEL FILE *

I tried to extract the excel/txt file all channels of the .*.out, Firstly, I tried to export only one channel. However, I cannot achieve to record the channel [2] in the excel file. .*.out The excel is empty and I have not obtained any error.error. After doing severals tests, PSSe told there are not channels in the *.out file

Root=os.getcwd()
out_file11 = r'case5_1.out'
pn, x = os.path.splitext(out_file11)

out_list=[out_file11]

chnfobj = dyntools.CHNF(out_file11,outvrsn=0) dyntools.CHNF(out_list,outvrsn=0) 
print('\n Testing call to txtout')
chnfobj.txtout(channels=[1,4], txtfile=pn)

ERROR

Testing call to txtout

Error - Reading channel data error. case5_1.out

Hello, I am writing because I have around 50 .out files. Inside each simulation, I have several channels. I would like to export all of them into an excel file or a txt. I tried to export with a function named " dyntools" and also with "excelpy" but it does not work. I have not got Matlab in my computer so I cannot used the function plt or numpy. Someone knows, How could create an excel file? Could I create a TXT instead and EXCEL file with all the channels info to avoid the overflow error? Could I do a txt file with all the channels without created a graph in python?

    import excelpy
    import dyntools

# LF process

# Channels identification

psspy.delete_all_plot_channels()
psspy.bsys(1,0,[0.0,0.0],0,[],3,[PCC_bus,WTG_bus_1,WTG_bus_2],0,[],0,[])
psspy.chsb(0,1,[-1,-1,-1,1,2,0])
psspy.chsb(0,1,[-1,-1,-1,1,3,0])
psspy.chsb(0,1,[-1,-1,-1,1,12,0])
psspy.chsb(0,1,[-1,-1,-1,1,13,0])
psspy.chsb(0,1,[-1,-1,-1,1,16,0])

LVRT

psspy.strt_2([0,0],out_file11)
psspy.run(0,3.0,L1,L2,L3)
psspy.dist_bus_fault(PCC_bus,3,HV_PCC,[0.0,0.0])
psspy.run(0,3.12,L1,L2,L3)
psspy.dist_clear_fault(1)
psspy.run(0,ttime50,L1,L2,L3)

*PROBLEM: EXPORT ALL OUT CHANNELS TO AN EXCEL FILE *

I tried to extract the excel/txt file all channels of the .*.out The excel file is empty and I have not obtained any error. empty. After doing severals tests, PSSe told there are not channels in the *.out file

Root=os.getcwd()
out_file11 = r'case5_1.out'
pn, x = os.path.splitext(out_file11)

out_list=[out_file11]

chnfobj = dyntools.CHNF(out_list,outvrsn=0) 
print('\n Testing call to txtout')
chnfobj.txtout(channels=[1,4], txtfile=pn)

ERROR

Testing call to txtout

Error - Reading channel data error. case5_1.out

Hello, I am writing because I have around 50 .out files. Inside each simulation, I have several channels. I would like to export all of them into an excel file or a txt. I tried to export with a function named " dyntools" and also with "excelpy" but it does not work. I have not got Matlab in my computer so I cannot used the function plt or numpy. Someone knows, How could create an excel file? Could I create a TXT instead and EXCEL file with all the channels info to avoid the overflow error? Could I do a txt file with all the channels without created a graph in python?

    import excelpy
    import dyntools

# LF process

# Channels identification

psspy.delete_all_plot_channels()
psspy.bsys(1,0,[0.0,0.0],0,[],3,[PCC_bus,WTG_bus_1,WTG_bus_2],0,[],0,[])
psspy.chsb(0,1,[-1,-1,-1,1,2,0])
psspy.chsb(0,1,[-1,-1,-1,1,3,0])
psspy.chsb(0,1,[-1,-1,-1,1,12,0])
psspy.chsb(0,1,[-1,-1,-1,1,13,0])
psspy.chsb(0,1,[-1,-1,-1,1,16,0])

LVRT

psspy.strt_2([0,0],out_file11)
psspy.run(0,3.0,L1,L2,L3)
psspy.dist_bus_fault(PCC_bus,3,HV_PCC,[0.0,0.0])
psspy.run(0,3.12,L1,L2,L3)
psspy.dist_clear_fault(1)
psspy.run(0,ttime50,L1,L2,L3)

*PROBLEM: EXPORT ALL OUT CHANNELS TO AN EXCEL FILE *

I tried to extract the excel/txt file all channels of the .*.out The excel file is empty. After doing severals several tests, PSSe told there are not channels in told: Reading channel data error. What can I do? the *.out fileis ok.

Root=os.getcwd()
out_file11 = r'case5_1.out'
pn, x = os.path.splitext(out_file11)

out_list=[out_file11]

chnfobj = dyntools.CHNF(out_list,outvrsn=0) 
print('\n Testing call to txtout')
chnfobj.txtout(channels=[1,4], txtfile=pn)

ERROR

Testing call to txtout

Error - Reading channel data error. case5_1.out

Hello, I am writing because I have around 50 .out files. Inside each simulation, I have several channels. I would like to export all of them into an excel file or a txt. I tried to export with a function named " dyntools" and also with "excelpy" but it does not work. I have not got Matlab in my computer so I cannot used the function plt or numpy. Someone knows, How could create an excel file? Could I create a TXT instead and EXCEL file with all the channels info to avoid the overflow error? Could I do a txt file with all the channels without created a graph in python?

    import excelpy
    import dyntools

# LF process

# Channels identification

psspy.delete_all_plot_channels()
psspy.bsys(1,0,[0.0,0.0],0,[],3,[PCC_bus,WTG_bus_1,WTG_bus_2],0,[],0,[])
psspy.chsb(0,1,[-1,-1,-1,1,2,0])
psspy.chsb(0,1,[-1,-1,-1,1,3,0])
psspy.chsb(0,1,[-1,-1,-1,1,12,0])
psspy.chsb(0,1,[-1,-1,-1,1,13,0])
psspy.chsb(0,1,[-1,-1,-1,1,16,0])

LVRT

psspy.strt_2([0,0],out_file11)
psspy.run(0,3.0,L1,L2,L3)
psspy.dist_bus_fault(PCC_bus,3,HV_PCC,[0.0,0.0])
psspy.run(0,3.12,L1,L2,L3)
psspy.dist_clear_fault(1)
psspy.run(0,ttime50,L1,L2,L3)

*PROBLEM: EXPORT ALL OUT CHANNELS TO AN EXCEL FILE *

I tried to extract the excel/txt file all channels of the .*.out The excel file is empty. After doing several tests, PSSe told: Reading channel data error. What can I do? the *.out is ok.

Root=os.getcwd()
out_file11 = r'case5_1.out'
pn, x = os.path.splitext(out_file11)

out_list=[out_file11]

chnfobj = dyntools.CHNF(out_list,outvrsn=0) 
print('\n Testing call to txtout')
chnfobj.txtout(channels=[1,4], txtfile=pn)

ERROR

Testing call to txtout

Error - Reading channel data error. case5_1.out

Hello, I am writing because I have around 50 .out files. Inside each simulation, I have several channels. I would like to export all of them into an excel file or a txt. I tried to export with a function named " dyntools" and also with "excelpy" but it does not work. Someone knows, How could create an excel file? Could I create a TXT instead and EXCEL file with all the channels info to avoid the overflow error? Could I do a txt file with all the channels without created a graph in python?

    import excelpy
    import dyntools

# LF process

# Channels identification

psspy.delete_all_plot_channels()
psspy.bsys(1,0,[0.0,0.0],0,[],3,[PCC_bus,WTG_bus_1,WTG_bus_2],0,[],0,[])
psspy.chsb(0,1,[-1,-1,-1,1,2,0])
psspy.chsb(0,1,[-1,-1,-1,1,3,0])
psspy.chsb(0,1,[-1,-1,-1,1,12,0])
psspy.chsb(0,1,[-1,-1,-1,1,13,0])
psspy.chsb(0,1,[-1,-1,-1,1,16,0])

LVRT

psspy.strt_2([0,0],out_file11)
psspy.run(0,3.0,L1,L2,L3)
psspy.dist_bus_fault(PCC_bus,3,HV_PCC,[0.0,0.0])
psspy.run(0,3.12,L1,L2,L3)
psspy.dist_clear_fault(1)
psspy.run(0,ttime50,L1,L2,L3)

*PROBLEM: EXPORT ALL OUT CHANNELS TO AN EXCEL FILE *

I tried to extract the excel/txt file all channels of the .*.out The excel file is empty. After doing several tests, PSSe told: Reading channel data error. What can I do? the *.out is ok.

Root=os.getcwd()
out_file11 = r'case5_1.out'
os.path.join(Root,'case5_1.out')
pn, x = os.path.splitext(out_file11)

out_list=[out_file11]

chnfobj = dyntools.CHNF(out_list,outvrsn=0) dyntools.CHNF(out_file11,outvrsn=0) 
print('\n Testing call to txtout')

# The txt file is not created

chnfobj.txtout(channels=[1,4], txtfile=pn)

ERROR

Testing call to txtout

Error - Reading channel data error. case5_1.out

Hello, I am writing because I have around 50 .out files. Inside each simulation, I have several channels. I would like to export all of them into an excel file or a txt. I tried to export with a function named " dyntools" and also with "excelpy" but it does not work. Someone knows, How could create an excel file? Could I create a TXT instead and EXCEL file with all the channels info to avoid the overflow error? Could I do a txt file with all the channels without created a graph in python?

    import excelpy
    import dyntools

# LF process

# Channels identification

psspy.delete_all_plot_channels()
psspy.bsys(1,0,[0.0,0.0],0,[],3,[PCC_bus,WTG_bus_1,WTG_bus_2],0,[],0,[])
psspy.chsb(0,1,[-1,-1,-1,1,2,0])
psspy.chsb(0,1,[-1,-1,-1,1,3,0])
psspy.chsb(0,1,[-1,-1,-1,1,12,0])
psspy.chsb(0,1,[-1,-1,-1,1,13,0])
psspy.chsb(0,1,[-1,-1,-1,1,16,0])

LVRT

psspy.strt_2([0,0],out_file11)
psspy.run(0,3.0,L1,L2,L3)
psspy.dist_bus_fault(PCC_bus,3,HV_PCC,[0.0,0.0])
psspy.run(0,3.12,L1,L2,L3)
psspy.dist_clear_fault(1)
psspy.run(0,ttime50,L1,L2,L3)

*PROBLEM: EXPORT ALL OUT CHANNELS TO AN EXCEL FILE *

I tried to extract the excel/txt file all channels of the .*.out The excel file is empty. After doing several tests, PSSe told: Reading channel data error. What can I do? the *.out is ok.

Root=os.getcwd()
out_file11 = os.path.join(Root,'case5_1.out')
pn, x = os.path.splitext(out_file11)

chnfobj = dyntools.CHNF(out_file11,outvrsn=0) 
print('\n Testing call to txtout')

# The txt file is not created

chnfobj.txtout(channels=[1,4], txtfile=pn)

ERROR

Testing call to txtout

Error - Reading channel data error. case5_1.out

Hello, I am writing because I have around 50 .out files. Inside each simulation, I have several channels. I would like to export all of them into an excel file or a txt. I tried to export with a function named " dyntools" and also with "excelpy" but it does not work. Someone knows, How could create an excel file? Could I create a TXT instead and EXCEL file with all the channels info to avoid the overflow error? Could I do a txt file with all the channels without created a graph in python?

    import excelpy
    import dyntools

# LF process

# Channels identification

psspy.delete_all_plot_channels()
psspy.bsys(1,0,[0.0,0.0],0,[],3,[PCC_bus,WTG_bus_1,WTG_bus_2],0,[],0,[])
psspy.chsb(0,1,[-1,-1,-1,1,2,0])
psspy.chsb(0,1,[-1,-1,-1,1,3,0])
psspy.chsb(0,1,[-1,-1,-1,1,12,0])
psspy.chsb(0,1,[-1,-1,-1,1,13,0])
psspy.chsb(0,1,[-1,-1,-1,1,16,0])

#LVRTLVRT TEST: out_file11

psspy.strt_2([0,0],out_file11)
psspy.run(0,3.0,L1,L2,L3)
psspy.dist_bus_fault(PCC_bus,3,HV_PCC,[0.0,0.0])
psspy.run(0,3.12,L1,L2,L3)
psspy.dist_clear_fault(1)
psspy.run(0,ttime50,L1,L2,L3)

#############=======================TEST 01 ================================

#out_file11 = 'case5_1.out'
txt_file='Case5_1.xlsx'
out_file11 = os.path.join(Root,'case5_1.out')
# txt_file= os.path.join(Root,'Case5_1.xlsx')
#pn, x = os.path.splitext(out_file11)


out_list=[]
# out_list.append.os.path.join(Root,'case5_1.out')
out_list = [out_file11]


#####FOUR OPTIONS

chnfobj = dyntools.CHNF(out_list,0) 
#chnfobj = dyntools.CHNF(out_file11,0) 
#chnfobj = dyntools.CHNF(out_file11,outvrsn=0) 
#chnfobj = dyntools.CHNF(out_list,outvrsn=0) 

##### OPTIONS #############

#chnfobj.xlsout(channels=[1,4], show=true, xlsfile=pn, sheet ='', overwritesheet=True)
chnfobj.xlsout(channels=[1,4], show=True, xlsfile=txt_file, sheet ='', overwritesheet=True)
#chnfobj.xlsout(channels=[1,4], show=True, xlsfile=txt_file, outfile='case5_1.out', sheet ='', overwritesheet=True)
#chnfobj.xlsout(outfile=out_file11,channels=[1,4], show = True, xlsfile=txt_file)

#############=======================TEST 02================================

# Root=os.getcwd()
# #out_file11 = 'case5_1.out'
# #txt_file='Case5_1.xlsx'
# out_file11 = os.path.join(Root,'case5_1.out')
pn, x = os.path.splitext(out_file11)

chnfobj # #txt_file=os.path.join(Root,'Case5_1.xlsx')

#chnfobj = dyntools.CHNF(out_list,0) 
# #chnfobj = dyntools.CHNF(out_file11,0) 
# #chnfobj = dyntools.CHNF(out_file11,outvrsn=0) 
print('\n Testing call to txtout')

# The txt file is not created

chnfobj.txtout(channels=[1,4], txtfile=pn)
# #chnfobj = dyntools.CHNF(out_list,outvrsn=0) 


# short_title, chanid, chandata = chnfobj.get_data()
# xl = excelpy.workbook(xlsfile='Case5_1.xlsx', mode='w')
# xl.set_range(1, 'a', [short_title])
# xl.save()
# xl.close()

#############=======================TEST 03================================

######====================Test_03.A===============
# # import win32com
# #xl = win32com.client.Dispatch("Excel.Application")
# #xl.DisplayAlerts = False

######=======================Test_03.B===============
# xl = excelpy.workbook(xlsfile, mode='w')

# name='case5.1';

# outfile = dyntools.CHNF(name+'.out')
# shorttitle, chaniddict, chandatadict = outfile.getdata()
# xlsfile=name+'.xlsx';
# xl = excelpy.workbook(xlsfile, mode='w')
# outfile.xlsout(sheet=name,overwritesheet=True)
# xl.save();
# xl.close()

Hello, I am writing because I have around 50 .out files. Inside each simulation, I have several channels. I would like to export all of them into an excel file or a txt. I tried to export with a function named " dyntools" and also with "excelpy" but it does not work. Someone knows, How could create an excel file? Could I create a TXT instead and EXCEL file with all the channels info to avoid the overflow error? Could I do a txt file with all the channels without created a graph in python?

    import excelpy
    import dyntools

# LF process

# Channels identification

#LVRT TEST: out_file11

#PROBLEM: EXPORT ALL OUT CHANNELS TO AN EXCEL/TXT FILE

According to the information which I read in the forum, I did several tests in order to find the best way for exporting the .out channels to and text or excel file. However, I have not any reply of my psse, psse reply, The excel is not created and no answer is written in the alert/progress output file. I don´t know how could I fix it.

What can I do? the *.out is ok.

#############=======================TEST 01 ================================

#out_file11 = 'case5_1.out'
txt_file='Case5_1.xlsx'
out_file11 = os.path.join(Root,'case5_1.out')
# txt_file= os.path.join(Root,'Case5_1.xlsx')
#pn, x = os.path.splitext(out_file11)


out_list=[]
# out_list.append.os.path.join(Root,'case5_1.out')
out_list = [out_file11]


#####FOUR OPTIONS

chnfobj = dyntools.CHNF(out_list,0) 
#chnfobj = dyntools.CHNF(out_file11,0) 
#chnfobj = dyntools.CHNF(out_file11,outvrsn=0) 
#chnfobj = dyntools.CHNF(out_list,outvrsn=0) 

##### OPTIONS #############

#chnfobj.xlsout(channels=[1,4], show=true, xlsfile=pn, sheet ='', overwritesheet=True)
chnfobj.xlsout(channels=[1,4], show=True, xlsfile=txt_file, sheet ='', overwritesheet=True)
#chnfobj.xlsout(channels=[1,4], show=True, xlsfile=txt_file, outfile='case5_1.out', sheet ='', overwritesheet=True)
#chnfobj.xlsout(outfile=out_file11,channels=[1,4], show = True, xlsfile=txt_file)

#############=======================TEST 02================================

# Root=os.getcwd()
# #out_file11 = 'case5_1.out'
# #txt_file='Case5_1.xlsx'
# out_file11 = os.path.join(Root,'case5_1.out')
# #txt_file=os.path.join(Root,'Case5_1.xlsx')

#chnfobj = dyntools.CHNF(out_list,0) 
# #chnfobj = dyntools.CHNF(out_file11,0) 
# #chnfobj = dyntools.CHNF(out_file11,outvrsn=0) 
# #chnfobj = dyntools.CHNF(out_list,outvrsn=0) 


# short_title, chanid, chandata = chnfobj.get_data()
# xl = excelpy.workbook(xlsfile='Case5_1.xlsx', mode='w')
# xl.set_range(1, 'a', [short_title])
# xl.save()
# xl.close()

#############=======================TEST 03================================

######====================Test_03.A===============
# # import win32com
# #xl = win32com.client.Dispatch("Excel.Application")
# #xl.DisplayAlerts = False

######=======================Test_03.B===============
# xl = excelpy.workbook(xlsfile, mode='w')

# name='case5.1';

# outfile = dyntools.CHNF(name+'.out')
# shorttitle, chaniddict, chandatadict = outfile.getdata()
# xlsfile=name+'.xlsx';
# xl = excelpy.workbook(xlsfile, mode='w')
# outfile.xlsout(sheet=name,overwritesheet=True)
# xl.save();
# xl.close()

Hello, I am writing because I have around 50 .out files. Inside each simulation, I have several channels. I would like to export all of them into an excel file or a txt. I tried to export with a function named " dyntools" and also with "excelpy" but it does not work. Someone knows, How could create an excel file? Could I create a TXT instead and EXCEL file with all the channels info to avoid the overflow error? Could I do a txt file with all the channels without created a graph in python?

    import excelpy
    import dyntools

# LF process

# Channels identification

#LVRT TEST: out_file11

#PROBLEM: EXPORT ALL OUT CHANNELS TO AN EXCEL/TXT FILE

According to the information which I read in the forum, I did several tests in order to find the best way for exporting the .out channels to and text or excel file. However, I have not any psse reply, The excel is not created and no answer is written in the alert/progress output file. I don´t know how could I fix it.

What can I do? the *.out is ok. After doing several tests, the problem was in the definition of the Output file it was fixed thanks to the post "Using api "pssplot.channelfileexcelexport()" rasise error" , I write the solution and the tests which I did:

SOLUTION*

In the dynamic simulation test the .out should be defined:

psspy.set_chnfil_type(0)  
psspy.strt_2([0,1],out_file11)
psspy.run(0,3.0,L1,L2,L3)


#############=======================TEST 01 ================================

#out_file11 = 'case5_1.out'
txt_file='Case5_1.xlsx'
out_file11 = os.path.join(Root,'case5_1.out')
# txt_file= os.path.join(Root,'Case5_1.xlsx')
#pn, x = os.path.splitext(out_file11)


out_list=[]
# out_list.append.os.path.join(Root,'case5_1.out')
out_list = [out_file11]


#####FOUR OPTIONS

chnfobj = dyntools.CHNF(out_list,0) 
#chnfobj = dyntools.CHNF(out_file11,0) 
#chnfobj = dyntools.CHNF(out_file11,outvrsn=0) 
#chnfobj = dyntools.CHNF(out_list,outvrsn=0) 

##### OPTIONS #############

#chnfobj.xlsout(channels=[1,4], show=true, xlsfile=pn, sheet ='', overwritesheet=True)
chnfobj.xlsout(channels=[1,4], show=True, xlsfile=txt_file, sheet ='', overwritesheet=True)
#chnfobj.xlsout(channels=[1,4], show=True, xlsfile=txt_file, outfile='case5_1.out', sheet ='', overwritesheet=True)
#chnfobj.xlsout(outfile=out_file11,channels=[1,4], show = True, xlsfile=txt_file)

#############=======================TEST 02================================

# Root=os.getcwd()
# #out_file11 = 'case5_1.out'
# #txt_file='Case5_1.xlsx'
# out_file11 = os.path.join(Root,'case5_1.out')
# #txt_file=os.path.join(Root,'Case5_1.xlsx')

#chnfobj = dyntools.CHNF(out_list,0) 
# #chnfobj = dyntools.CHNF(out_file11,0) 
# #chnfobj = dyntools.CHNF(out_file11,outvrsn=0) 
# #chnfobj = dyntools.CHNF(out_list,outvrsn=0) 


# short_title, chanid, chandata = chnfobj.get_data()
# xl = excelpy.workbook(xlsfile='Case5_1.xlsx', mode='w')
# xl.set_range(1, 'a', [short_title])
# xl.save()
# xl.close()

#############=======================TEST 03================================

######====================Test_03.A===============
# # import win32com
# #xl = win32com.client.Dispatch("Excel.Application")
# #xl.DisplayAlerts = False

######=======================Test_03.B===============
# xl = excelpy.workbook(xlsfile, mode='w')

# name='case5.1';

# outfile = dyntools.CHNF(name+'.out')
# shorttitle, chaniddict, chandatadict = outfile.getdata()
# xlsfile=name+'.xlsx';
# xl = excelpy.workbook(xlsfile, mode='w')
# outfile.xlsout(sheet=name,overwritesheet=True)
# xl.save();
# xl.close()