Ask Your Question

Export the PV analysis output in an Excel file

asked 2022-04-19 12:14:13 -0500

Moji gravatar image

updated 2022-04-19 12:53:27 -0500

I have the result for a PV analysis that contains about 14000 contingency cases. When I want to export the result in an excel file using either in Export data tool in PSSe or Python automated, I only get the result for up to 360 contingencies analysis. Is there any limitation to exporting the data? Does anybody know how I can export the whole result for all contingencies?

edit retag flag offensive close merge delete


I guess that it is because of the limitation of writing data into Excel which maybe support writing data up to a specific number of rows/cells. Do you all agree with that?

Moji gravatar imageMoji ( 2022-04-20 14:15:10 -0500 )edit

2 answers

Sort by ยป oldest newest most voted

answered 2022-04-22 13:51:32 -0500

Moji gravatar image

Here is the part of python for excel output:

pvfile = r"resultdouble.pv" string = ['s','v','m','g','l','b','i'] xlsfile = 'result.xls' sheet = '' overwritesheet = True pssexcel.pv(pvfile,string,colabel=colabelnew,xlsfile=xlsfile,sheet=sheet,overwritesheet=overwritesheet)

edit flag offensive delete link more


change extension to xlsx and retry.

jconto gravatar imagejconto ( 2022-04-22 14:20:22 -0500 )edit

answered 2022-04-21 15:36:08 -0500

jconto gravatar image

updated 2022-04-21 16:18:43 -0500

can you show the python script in use?

The pssexcel module is able to slice the PV analysis results contained in a *.pv file by setting a list of contingencies whose results will be exported. If the hard limit is 360, a python loop that keep slicing the list of contingencies in continuous sub-groups of 360 and saving the sliced-results to new excel files would do the trick.

Still, results of only 360 contingencies as max export limit seems very small. Excel limits are large, it can be found by searching the internet for "Excel specifications and limits"

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


Asked: 2022-04-19 12:14:13 -0500

Seen: 92 times

Last updated: Apr 22