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

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.

Possible littering of memory with orphaned Excel processes.

f Excel is closed while it is connected to the ControlShell then an orphaned Excel process remains in memory. The reason lies in the COM architecture. There is no way around it.

Such an orphan process may be removed from Windows Task Manager. To avoid creation of an orphaned Excel process, either close the ControlShell before closing Excel or disconnect the Excel instance from the ControlShell by pressing <Ctrl>+<Delete> at the addin prompt.

Index. Contents.

Copyright 2007