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).
D. Worksheets object (PFE).
E. Worksheet object (PFE).
a. Activate method (vba.Worksheet).
b. Calculate method (vba.Worksheet).
c. Cells property (vba.Worksheet).
d. Columns property (vba.Worksheet).
e. CopyAfter method (vba.Worksheet).
f. CopyBefore (vba.Worksheet).
g. Delete method (vba.Worksheet).
h. Dispatch property (vba.Worksheet).
i. Hyperlinks property (vba.Worksheet).
j. Index method (vba.Worksheet).
k. MoveAfter method (vba.Worksheet).
l. MoveBefore method (vba.Worksheet).
m. Name property (vba.Worksheet).
n. Names property (vba.Worksheet).
o. Parent property (vba.Worksheet).
p. Range method (vba.Worksheet).
q. Rows property (vba.Worksheet).
r. Visible property (vba.Worksheet).
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.

Visible property (vba.Worksheet).


orksheets may be visible or hidden. The Visible property controls such state. It is a read/write property. It takes values from the enumeration vba.XlSheetVisibility.


Figure





Index. Contents.


















Copyright 2007