First time here? We are a friendly community of Power Systems Engineers. Check out the FAQ!
Hi all,
When exporting acc files to excel, I'm running out of excel lines. I tried exporting summary first and then selecting half the contingencies from them ansd export using colabel, but i'm unable to figure out the syntax, I tried all the types I could but was not able to figure out.
Any help is greatly appreciated.
You can either:
Try 64-bit Excel. It supports more lines, but you will have to update the entire Office suite. Also, I never used PSSE with 64-bit Excel so I don't know whether it would work or not.
Export as CSV files instead, then use a good text editor to read/modify the CSV. CSV has no limit (but Excel probably cannot open it if lines are exceeded). Good text editors are : VSCode, Sublime, Atom, etc. You can use pandas and matplotlib to do the data processing/visualisation. Don't rely on Excel, it's not for science/engineering.
Asked: Jun 7 '0
Seen: 267 times
Last updated: Jun 16 '20
whit loves you. Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
