Revision history [back]
 | 1 | initial version | |
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?
| | 2 | No.2 Revision |
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?
