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.
III. Tutorial introduction into the Python for Excel.
IV. PFE Programmer's reference.
1. Direct access to Excel API.
A. Application object (PFE).
a. ActiveCell property (vba.Application).
b. ActiveSheet property (vba.Application).
c. ActiveWindow property (vba.Application).
d. ActiveWorkbook property (vba.Application).
e. Calculate method (vba.Application).
f. CalculateBeforeSave property (vba.Application).
g. Calculation property (vba.Application).
h. Dispatch property (vba.Application).
i. EnableEvents property (vba.Application).
j. Evaluate method (vba.Application).
k. ExecuteExcel4Macro method (vba.Application).
l. Intersect method (vba.Application).
m. MemoryUsed property (vba.Application).
n. Name property (vba.Application).
o. Path property (vba.Application).
p. PathSeparator property (vba.Application).
q. Quit method (vba.Application).
r. Run method (vba.Application).
s. ScreenUpdating property (vba.Application).
t. Selection property (vba.Application).
u. StatusBar property (vba.Application).
v. Union method (vba.Application).
w. Windows property (vba.Application).
x. Workbooks property (vba.Application).
B. Workbooks object (PFE).
C. Workbook object (PFE).
D. Worksheets object (PFE).
E. Worksheet object (PFE).
F. Range object (PFE).
G. Borders object (PFE).
H. Border object (PFE).
I. Interior object (PFE).
J. Names object (PFE).
K. Name object (PFE).
L. Font object (PFE).
2. Lower level access to Excel API.
3. Event trapping (PFE).
4. Configuration files (PFE).
Index. Contents.

Application object (PFE).


he Application object is the root of all direct access to the Excel API. It is a predefined object accessible from any addin shell prompt.


Figure

The type of the Application object is defined in the vba module.


Figure

The vba module is predefined in every addin shell.




a. ActiveCell property (vba.Application).
b. ActiveSheet property (vba.Application).
c. ActiveWindow property (vba.Application).
d. ActiveWorkbook property (vba.Application).
e. Calculate method (vba.Application).
f. CalculateBeforeSave property (vba.Application).
g. Calculation property (vba.Application).
h. Dispatch property (vba.Application).
i. EnableEvents property (vba.Application).
j. Evaluate method (vba.Application).
k. ExecuteExcel4Macro method (vba.Application).
l. Intersect method (vba.Application).
m. MemoryUsed property (vba.Application).
n. Name property (vba.Application).
o. Path property (vba.Application).
p. PathSeparator property (vba.Application).
q. Quit method (vba.Application).
r. Run method (vba.Application).
s. ScreenUpdating property (vba.Application).
t. Selection property (vba.Application).
u. StatusBar property (vba.Application).
v. Union method (vba.Application).
w. Windows property (vba.Application).
x. Workbooks property (vba.Application).

Index. Contents.


















Copyright 2007