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.

Unicode support.

he control shell '>>> ' has full support for the Unicode.

The addin shells have support with one limitation. If you want to manually enter a Unicode string into an addin shell then you have to create a py-file like so:

# -*- coding: utf-8 -*-

data=u"<some unicode characters>"

(see the document http://www.python.org/peps/pep-0263.html for more details) and then run it in the addin shell via an execfile statement.

This is the only limitation. One may read unicode data from Excel, manipulate it, examine it and put it into Excel.

The reason for the limitation is absence of a unicode version of the PyRun_SimpleString in the Python API. There seems to be no way to force it to interpret a command of the form

a='<some unicode>'

without loosing half of the information.

If anyone knows a solution I would appreciate a pointer.

Index. Contents.

Copyright 2007