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?
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"
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)
change extension to xlsx and retry.
Comments
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?