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).
B. Workbooks object (PFE).
C. Workbook object (PFE).
a. Activate method (vba.Workbook).
b. ActiveSheet property (vba.Workbook).
c. Close method (vba.Workbook).
d. Dispatch property (vba.Workbook).
e. Name property (vba.Workbook).
f. Names property (vba.Workbook).
g. Parent property (vba.Workbook).
h. Path property (vba.Workbook).
i. Save method (vba.Workbook).
j. SaveAs method (vba.Workbook).
k. Worksheets property (vba.Workbook).
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.

Activate method (vba.Workbook).


n Excel instance displays only one workbook at a time. The Activate method of the vba.Workbook object brings the workbook on top.

Do not use this method during initial execution of the pfe-script and in "OnWorkbookOpen" event handlers.


Figure





Index. Contents.


















Copyright 2007