Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

import pssexcel Excel 2016

The following code was meant to redirect folder path when my computer transition between Window 7 to Windows 10. using the same PSSE 33.4

code_loc = r"C:\Common Modules"

sys.path.append(codeloc) os.environ['PATH'] = os.environ['path'] + ';' + codeloc from codedicttofromcsv import *

win10='Y' win10ch=0 win10=str(input('Are you using windows 10? ')) if str(win10).isdigit()==1: desired_location=win10 win10ch=1 win10='Y'

if str(win10.upper())=='N': PSSELOCATION = r"C:\Program Files\PTI\PSSE33\PSSBIN" else: PSSELOCATION = r"C:\Program Files (x86)\PTI\PSSE33\PSSBIN" sys.path.append(PSSELOCATION) os.environ['PATH'] = os.environ['path'] + ';' + PSSELOCATION

import psspy import redirect import pssarrays import pssexcel

On my old computer(WIndows 7, Excel 2010), the following error comes up when I had an excel file opened that can't be closed immediately. Now that I have my new computer, Windows 10, Excel 2016. I get the following error every time I import pssexcel though I can't find any Excel program on Task Manager.

Traceback (most recent call last): File "M:\DiagramsPlatypus\Network Security_PSSE Programs\PSSEOutageProg v3.07_Programrun_PSSE.py", line 57, in <module> import pssexcel # Section 9.2 for API documentation (p9-25) ASB - 12-3-12 File ".\pssexcel.py", line 36, in <module> File ".\pssexceluserin.py", line 10, in <module> File ".\excelpy.py", line 1922, in _getDefaultXLFileExtension AttributeError: 'NoneType' object has no attribute 'Quit'

Might I know if anyone has any idea what the cause is and how I can fix this, please? I can't find the source code for pssexcel to see what it's after.

import pssexcel Excel 2016

The following code was meant to redirect folder path when my computer transition between Window 7 to Windows 10. using the same PSSE 33.4

code_loc 33.4 italic codeloc = r"C:\Common Modules"

Modules" sys.path.append(codeloc) os.environ['PATH'] = os.environ['path'] + ';' + codeloc from codedicttofromcsv import *

* win10='Y' win10ch=0 win10=str(input('Are you using windows 10? ')) if str(win10).isdigit()==1: desired_location=win10 desiredlocation=win10 win10ch=1 win10='Y'

if str(win10.upper())=='N': PSSELOCATION = r"C:\Program Files\PTI\PSSE33\PSSBIN" else: PSSELOCATION = r"C:\Program Files (x86)\PTI\PSSE33\PSSBIN" sys.path.append(PSSELOCATION) os.environ['PATH'] = os.environ['path'] + ';' + PSSELOCATION

LOCATION import psspy import redirect import pssarrays import pssexcelpssexcel italic

On my old computer(WIndows 7, Excel 2010), the following error comes up when I had an excel file opened that can't be closed immediately. Now that I have my new computer, Windows 10, Excel 2016. I get the following error every time I import pssexcel though I can't find any Excel program on Task Manager.

Traceback (most recent call last): File "M:\DiagramsPlatypus\Network Security_PSSE Programs\PSSEOutageProg v3.07_Programrun_PSSE.py", line 57, in <module> import pssexcel # Section 9.2 for API documentation (p9-25) ASB - 12-3-12 File ".\pssexcel.py", line 36, in <module> File ".\pssexceluserin.py", line 10, in <module> File ".\excelpy.py", line 1922, in _getDefaultXLFileExtension AttributeError: 'NoneType' object has no attribute 'Quit'

Might I know if anyone has any idea what the cause is and how I can fix this, please? I can't find the source code for pssexcel to see what it's after.

import pssexcel Excel 2016

The following code was meant to redirect folder path when my computer transition between Window 7 to Windows 10. using the same PSSE 33.4 italic 33.4

_ codeloc = r"C:\Common Modules" sys.path.append(codeloc) os.environ['PATH'] = os.environ['path'] + ';' + codeloc from codedicttofromcsv import * win10='Y' win10ch=0 win10=str(input('Are you using windows 10? ')) if str(win10).isdigit()==1: desiredlocation=win10 win10ch=1 win10='Y'

if str(win10.upper())=='N': PSSELOCATION = r"C:\Program Files\PTI\PSSE33\PSSBIN" else: PSSELOCATION = r"C:\Program Files (x86)\PTI\PSSE33\PSSBIN" sys.path.append(PSSELOCATION) os.environ['PATH'] = os.environ['path'] + ';' + PSSELOCATION import psspy import redirect import pssarrays import pssexcel italic_

On my old computer(WIndows 7, Excel 2010), the following error comes up when I had an excel file opened that can't be closed immediately. Now that I have my new computer, Windows 10, Excel 2016. I get the following error every time I import pssexcel though I can't find any Excel program on Task Manager.

Traceback (most recent call last): File "M:\DiagramsPlatypus\Network Security_PSSE Programs\PSSEOutageProg v3.07_Programrun_PSSE.py", line 57, in <module> import pssexcel # Section 9.2 for API documentation (p9-25) ASB - 12-3-12 File ".\pssexcel.py", line 36, in <module> File ".\pssexceluserin.py", line 10, in <module> File ".\excelpy.py", line 1922, in _getDefaultXLFileExtension AttributeError: 'NoneType' object has no attribute 'Quit'

Might I know if anyone has any idea what the cause is and how I can fix this, please? I can't find the source code for pssexcel to see what it's after.

import pssexcel Excel 2016

The following code was meant to redirect folder path when my computer transition between Window 7 to Windows 10. using the same PSSE 33.4

_ codeloc = r"C:\Common Modules" sys.path.append(codeloc) os.environ['PATH'] = os.environ['path'] + ';' + codeloc from codedicttofromcsv import * win10='Y' win10ch=0 win10=str(input('Are you using windows 10? ')) if str(win10).isdigit()==1: desiredlocation=win10 desired_location=win10 win10ch=1 win10='Y'

if str(win10.upper())=='N': PSSELOCATION = r"C:\Program Files\PTI\PSSE33\PSSBIN" else: PSSELOCATION = r"C:\Program Files (x86)\PTI\PSSE33\PSSBIN" sys.path.append(PSSELOCATION) os.environ['PATH'] = os.environ['path'] + ';' + PSSELOCATION import psspy import redirect import pssarrays import pssexcel ___

On my old computer(WIndows 7, Excel 2010), the following error comes up when I had an excel file opened that can't be closed immediately. Now that I have my new computer, Windows 10, Excel 2016. I get the following error every time I import pssexcel though I can't find any Excel program on Task Manager.

_ Traceback (most recent call last): File "M:\DiagramsPlatypus\Network Security_PSSE Programs\PSSEOutageProg v3.07_Programrun_PSSE.py", runPSSE.py", line 57, in <module> import pssexcel # Section 9.2 for API documentation (p9-25) ASB - 12-3-12 File ".\pssexcel.py", line 36, in <module> File ".\pssexceluserin.py", line 10, in <module> File ".\excelpy.py", line 1922, in _getDefaultXLFileExtension getDefaultXLFileExtension AttributeError: 'NoneType' object has no attribute 'Quit''Quit' _

Might I know if anyone has any idea what the cause is and how I can fix this, please? I can't find the source code for pssexcel to see what it's after.

import pssexcel Excel 2016

The following code was meant to redirect folder path when my computer transition between Window 7 to Windows 10. using the same PSSE 33.4

_ codeloc = r"C:\Common Modules" sys.path.append(codeloc) os.environ['PATH'] = os.environ['path'] + ';' + codeloc from codedicttofromcsv import * win10='Y' win10ch=0 win10=str(input('Are you using windows 10? ')) if str(win10).isdigit()==1: desired_location=win10 desiredlocation=win10 win10ch=1 win10='Y'

if str(win10.upper())=='N': PSSELOCATION = r"C:\Program Files\PTI\PSSE33\PSSBIN" else: PSSELOCATION = r"C:\Program Files (x86)\PTI\PSSE33\PSSBIN" sys.path.append(PSSELOCATION) os.environ['PATH'] = os.environ['path'] + ';' + PSSELOCATION import psspy import redirect import pssarrays import pssexcel ___

On my old computer(WIndows 7, Excel 2010), the following error comes up when I had an excel file opened that can't be closed immediately. Now that I have my new computer, Windows 10, Excel 2016. I get the following error every time I import pssexcel though I can't find any Excel program on Task Manager.

_ Traceback (most recent call last): File "M:\DiagramsPlatypus\Network Security_PSSE Programs\PSSEOutageProg v3.07_ProgramrunPSSE.py", run_PSSE.py", line 57, in <module> import pssexcel # Section 9.2 for API documentation (p9-25) ASB - 12-3-12 File ".\pssexcel.py", line 36, in <module> File ".\pssexceluserin.py", line 10, in <module> File ".\excelpy.py", line 1922, in getDefaultXLFileExtension _getDefaultXLFileExtension AttributeError: 'NoneType' object has no attribute 'Quit' _

Might I know if anyone has any idea what the cause is and how I can fix this, please? I can't find the source code for pssexcel to see what it's after.

import pssexcel Excel 2016

The following code was meant to redirect folder path when my computer transition between Window 7 to Windows 10. using the same PSSE 33.4

_ codeloc = r"C:\Common Modules" sys.path.append(codeloc) os.environ['PATH'] = os.environ['path'] + ';' + codeloc from codedicttofromcsv import * win10='Y' win10ch=0 win10=str(input('Are you using windows 10? ')) if str(win10).isdigit()==1: desiredlocation=win10 win10ch=1 win10='Y'

if str(win10.upper())=='N': PSSELOCATION = r"C:\Program Files\PTI\PSSE33\PSSBIN" else: PSSELOCATION = r"C:\Program Files (x86)\PTI\PSSE33\PSSBIN" sys.path.append(PSSELOCATION) os.environ['PATH'] = os.environ['path'] + ';' + PSSELOCATION import psspy import redirect import pssarrays import pssexcel _pssexcel

On my old computer(WIndows 7, Excel 2010), the following error comes up when I had an excel file opened that can't be closed immediately. Now that I have my new computer, Windows 10, Excel 2016. I get the following error every time I import pssexcel though I can't find any Excel program on Task Manager.

_ Traceback (most recent call last): File "M:\DiagramsPlatypus\Network Security_PSSE Programs\PSSEOutageProg v3.07_Programrun_PSSE.py", line 57, in <module> import pssexcel # Section 9.2 for API documentation (p9-25) ASB - 12-3-12 File ".\pssexcel.py", line 36, in <module> File ".\pssexceluserin.py", line 10, in <module> File ".\excelpy.py", line 1922, in _getDefaultXLFileExtension AttributeError: 'NoneType' object has no attribute 'Quit' _'Quit'

Might I know if anyone has any idea what the cause is and how I can fix this, please? I can't find the source code for pssexcel to see what it's after.

import pssexcel Excel 2016

The following code was meant to redirect folder path when my computer transition between Window 7 to Windows 10. using the same PSSE 33.4

codeloc code_loc = r"C:\Common Modules" sys.path.append(codeloc) Modules"

sys.path.append(code_loc)

os.environ['PATH'] = os.environ['path'] + ';' + code_loc

from codeloc from codedictdicttotofromfromcsv import * win10='Y' win10ch=0 *

win10='Y'

win10ch=0

win10=str(input('Are you using windows 10? ')) '))

if str(win10).isdigit()==1: desiredlocation=win10 str(win10).isdigit()==1:

desired_location=win10

win10ch=1
    win10='Y'

win10='Y'

if str(win10.upper())=='N': PSSELOCATION PSSE_LOCATION = r"C:\Program Files\PTI\PSSE33\PSSBIN" Files\PTI\PSSE33\PSSBIN"

else: PSSELOCATION PSSE_LOCATION = r"C:\Program Files (x86)\PTI\PSSE33\PSSBIN" sys.path.append(PSSELOCATION) (x86)\PTI\PSSE33\PSSBIN"

sys.path.append(PSSE_LOCATION)

os.environ['PATH'] = os.environ['path'] + ';' + PSSELOCATION import psspy import redirect import pssarrays PSSE_LOCATION

import psspy

import redirect

import pssarrays

import pssexcel

On my old computer(WIndows 7, Excel 2010), the following error comes up when I had an excel file opened that can't be closed immediately. Now that I have my new computer, Windows 10, Excel 2016. I get the following error every time I import pssexcel though I can't find any Excel program on Task Manager.

Traceback (most recent call last): File "M:\DiagramsPlatypus\Network Security_PSSE Programs\PSSEOutageProg v3.07_Programrun_PSSE.py", line 57, in <module> import pssexcel # Section 9.2 for API documentation (p9-25) ASB - 12-3-12 File ".\pssexcel.py", line 36, in <module> File ".\pssexceluserin.py", line 10, in <module> File ".\excelpy.py", line 1922, in _getDefaultXLFileExtension AttributeError: 'NoneType' object has no attribute 'Quit'

Might I know if anyone has any idea what the cause is and how I can fix this, please? I can't find the source code for pssexcel to see what it's after.

import pssexcel Excel 2016

The following code was meant to redirect folder path when my computer transition between Window 7 to Windows 10. using the same PSSE 33.4

code_loc = r"C:\Common Modules"

sys.path.append(code_loc)

os.environ['PATH'] = os.environ['path'] + ';' + code_loc

from codedicttofromcsv import *

win10='Y'

win10ch=0

win10=str(input('Are you using windows 10? '))

if str(win10).isdigit()==1:

desired_location=win10

win10ch=1

win10='Y'

if str(win10.upper())=='N': PSSE_LOCATION = r"C:\Program Files\PTI\PSSE33\PSSBIN"

else: PSSE_LOCATION = r"C:\Program Files (x86)\PTI\PSSE33\PSSBIN"

sys.path.append(PSSE_LOCATION)

os.environ['PATH'] = os.environ['path'] + ';' + PSSE_LOCATION

import psspy

import redirect

import pssarrays

import pssexcel

On my old computer(WIndows 7, Excel 2010), the following error comes up when I had an excel file opened that can't be closed immediately. Now that I have my new computer, Windows 10, Excel 2016. I get the following error every time I import pssexcel though I can't find any Excel program on Task Manager.

Traceback (most recent call last): last):

File "M:\DiagramsPlatypus\Network Security_PSSE Programs\PSSEOutageProg v3.07_Programrun_PSSE.py", line 57, in <module> <module>

import pssexcel  # Section 9.2 for API documentation (p9-25) ASB - 12-3-12
 

File ".\pssexcel.py", line 36, in <module> <module>

File ".\pssexceluserin.py", line 10, in <module> <module>

File ".\excelpy.py", line 1922, in _getDefaultXLFileExtension _getDefaultXLFileExtension

AttributeError: 'NoneType' object has no attribute 'Quit'

Might I know if anyone has any idea what the cause is and how I can fix this, please? I can't find the source code for pssexcel to see what it's after.

import pssexcel Excel 2016

The following code was meant to redirect folder path when my computer transition between Window 7 to Windows 10. using the same PSSE 33.4

code_loc = r"C:\Common Modules"

sys.path.append(code_loc)

os.environ['PATH'] = os.environ['path'] + ';' + code_loc

from codedicttofromcsv import *

win10='Y'

win10ch=0

win10=str(input('Are you using windows 10? '))

if str(win10).isdigit()==1:

desired_location=win10

win10ch=1

win10='Y'

if str(win10.upper())=='N': PSSE_LOCATION = r"C:\Program Files\PTI\PSSE33\PSSBIN"

else: PSSE_LOCATION = r"C:\Program Files (x86)\PTI\PSSE33\PSSBIN"

sys.path.append(PSSE_LOCATION)

os.environ['PATH'] = os.environ['path'] + ';' + PSSE_LOCATION

import psspy

import redirect

import pssarrays

import pssexcel

On my old computer(WIndows 7, Excel 2010), the following error comes up when I had an excel file opened that can't be closed immediately. Now that I have my new computer, Windows 10, Excel 2016. I get the following error every time I import pssexcel though I can't find any Excel program on Task Manager.

Traceback (most recent call last):

File "M:\DiagramsPlatypus\Network Security_PSSE Programs\PSSEOutageProg v3.07_Programrun_PSSE.py", line 57, in <module>

import pssexcel  # Section 9.2 for API documentation (p9-25) ASB - 12-3-12
pssexcel

File ".\pssexcel.py", line 36, in <module>

File ".\pssexceluserin.py", line 10, in <module>

File ".\excelpy.py", line 1922, in _getDefaultXLFileExtension

AttributeError: 'NoneType' object has no attribute 'Quit'

Might I know if anyone has any idea what the cause is and how I can fix this, please? I can't find the source code for pssexcel to see what it's after.