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

I. Motivation and design (PFE).
II. Installation of the Python for Excel.
1. How to confirm that the PFE did properly install?
2. What to do if the PythonForExcel ControlShell does not activate?
3. The otsPythonForExcel.xla is registered among the Excel add-ins but the ControlShell still does not activate.
4. The Excel macros are operational but the ControlShell still does not activate.
III. Tutorial introduction into the Python for Excel.
IV. PFE Programmer's reference.
Index. Contents.

How to confirm that the PFE did properly install?


he program (PythonForExcel ControlShell) should activate when the user presses one of the key combinations<Alt>+<Shift>+<P>, <Alt>+<Shift>+<Q>, <Alt>+<Shift>+<Z> from Excel or if the user enters the following in-cell formula:

=pfeEval("a")

Note that on Excels 2007 and 2010 the combination <Alt>+<Shift>+<P> is reserved by Excel for another function. If the user presses such combination then the Excel would interpret <Alt>+<Shift>+<Q> in context of that function. Hence, <Alt>+<Shift>+<Q> won't work either. One has to exit the context (for example, by pressing <Esc>) before trying another key combination.





Index. Contents.


















Copyright 2007