Ask Your Question
0

Excel running out of lines.

asked 2020-06-06 22:07:21 -0500

vrj88 gravatar image

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.

edit retag flag offensive close merge delete

1 answer

Sort by ยป oldest newest most voted
0

answered 2020-06-16 18:18:12 -0500

drsgao gravatar image

You can either:

  1. 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.

  2. 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.

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

Stats

Asked: 2020-06-06 22:07:21 -0500

Seen: 252 times

Last updated: Jun 16 '20