ACCC Output to Excel
I am currently working on outputting the results of a directory of .acc files to a single excel sheet. I am using PSSE33 and just playing with the pssexcel function to see if it improves over our current method of using the acccsinglerunreport4 API. Currently this is what my code looks like:
import os,sys
PSSE_LOCATION = r"C:\Program Files\PTI\PSSE33\PSSBIN" sys.path.append(PSSELOCATION) os.environ['PATH'] = os.environ['PATH'] + ';' + PSSE_LOCATION
import pssexcel
pssexcel.accc('conting.acc', 's', 'contingency.xls')
When I run this in PSSE I get the following error:
File ".\pssexcel.py", line 36, in 'module' File ".\excelpy.py", line 168, in 'module' File "C:\Python27\lib\site-packages\win32com_init_.py", line 5, in 'module' import win32api, sys, os ImportError: DLL load failed: The specified module could not be found. Couldn't open Python file:C:\Users\def\Documents\Python\CSV\Acc2exc.py
Does anyone know what DLL this is? Any Idea of a fix?
I tried re-installing Python 2.7. That didn't work out. This was simply an investigation into a better method than the method we have in place now for creating an output spreadsheet of ACCC's. I'm going to set the idea on the shelf for a little while and come back to it with a fresh perspective.
Are you on the latest point release of PSSE? I ran into some win32com bugs with the early versions of the v33 releases while working with the accc functions. An upgrade to the latest PSSE release fixed it up.
I am running V33.4 as well as V32.2 on this computer. I installed V33.4 just last week.
DId you try installing `pywin32` - it doesn't come with Python2.7 so re-installing Python wouldn't have done anything.