First time here? We are a friendly community of Power Systems Engineers. Check out the FAQ!

Ask Your Question
0

Exporting data to Excel without using Python

asked Aug 5 '15

Yasmine gravatar image

updated Aug 5 '15

Hello everyone :) Can I apply the practice the ExportingPSSEResultstoExcel instead of Python to export results (voltage and frequency, etc ..) to Excel ?

Well, if possible, I want details on ِACCC, QV, PV files? especially when I want to suppose disturbances and run dynamic simulation for suitable load shedding in system under study ! Sorry I don't see Python easy to use it in my search :( Please help and thank you all

1 answer

Sort by » oldest newest most voted
0

answered Aug 5 '15

acd1 gravatar image

Yasmine,

Unfortunately I'm not too familiar with the output format of ACCC, QV, or PV files. However, I think I can offer a suggestion that could possibly help you.

In Excel 2010's "Data" tab on the top, there is a "Text to Columns" button. If you copy the data over from your output file into an Excel file, you can click this button and select where the data should be divided into different cells. It's not always perfect, but I've found it handy in the past.

link

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.
Want to format code in your answer? Here is a one minute demo on Youtube

Add Answer

[hide preview]

Question Tools

Stats

Asked: Aug 5 '15

Seen: 2,169 times

Last updated: Aug 05 '15