Quantitative Analysis
Parallel Processing
Numerical Analysis
C++ Multithreading
Python for Excel
Python Utilities
Author

I. Motivation and design (PFE).
II. Installation of the Python for Excel.
III. Tutorial introduction into the Python for Excel.
1. Stability guarantee.
2. PythonForExcel ControlShell.
3. What to do if the connection to Excel from the ControlShell is lost or if the prompt "waits" for too long.
4. Possible littering of memory with orphaned Excel processes.
5. In-cell execution of Python statements.
6. Calling Python from VBA.
7. Calling VBA from Python.
8. Debugging with Python for Excel.
9. Unicode support.
10. Deactivation of Python for Excel.
11. Very important note about pfe-script execution.
IV. PFE Programmer's reference.
Index. Contents.

What to do if the connection to Excel from the ControlShell is lost or if the prompt "waits" for too long.


ontrolShell's function is experimentation. If the user did something dangerous or incorrect then the ControlShell may lose control of the Excel application. In such case the user may press<Ctrl>+<Delete> to kill the addin shell for that Excel instance. Then the user should switch to the Excel instance and press one of the key combinations <Alt>+<Shift>+<P>, <Alt>+<Shift>+<Q>, <Alt>+<Shift>+<Z> to reestablish the connection.





Index. Contents.


















Copyright 2007