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

Close ACCC excel report

Peter B
125 ●10 ●13 ●19

Hi,

I have a script I use to run ACCC studies that uses the pssexcel.accc command. At the moment it's very basic and just runs a study for whatever case is loaded into PSS/E.

I'm trying to update the script so that it runs on multiple cases recorded in a .dat file.

My issue is that it seems to only give me an ACCC excel report for the last case listed in the .dat file. So what I think I'm missing is some code to save and close each excel report as the code loops through.

How do I save and close an excel workbook created by pssexcel.accc?

Thanks,

Peter

Comments

Can we look at your code? That would make things much easier.

amaity (Oct 16 '13)

add a comment

1 answer

Sort by » oldest newest most voted

answered Oct 16 '13

Peter B
125 ●10 ●13 ●19

I figured this out:

import excelpy
xl = excelpy.workbook()
xl.close()

Will close an open excel workbook created by pssexcel.accc.

But I've got far stranger issues in my script that I might put a separate question up for.

link

Comments

Just FYI, I never had to add the above extra code in order to use pssexcel. BTW, did you run you code outside of PSS/E (i.e., directly from Python IDLE or other types of python interpreter)?

yfwing (Oct 18 '13)

I was running from Python IDLE. I don't need the above lines to run pssexcel.accc on a single case, but when looping through multiple cases it seems to need it.

Peter B (Oct 21 '13)

add a comment

Question Tools

Stats

Asked: Oct 15 '13

Seen: 847 times

Last updated: Oct 15 '13

Close ACCC excel report

Comments

1 answer

Comments

Your Answer

Question Tools

Stats

Related questions