Revision history  [back]

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 accc_single_run_report_4 API. Currently this is what my code looks like:

import os,sys

PSSE__LOCATION = r"C:\Program Files\PTI\PSSE33\PSSBIN" sys.path.append(PSSE_LOCATION) 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?