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).
a.
__call__ method (vba.Workbooks).
b.
Add method (vba.Workbooks).
c.
Close method (vba.Workbooks).
d.
Count property (vba.Workbooks).
e.
Dispatch property (vba.Workbooks).
f.
Item method (vba.Workbooks).
g.
Open method (vba.Workbooks).
h.
Parent property (vba.Workbooks).
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.
Close method (vba.Workbooks).
he Close method of the vba.Workbooks object closes all workbooks of the Excel instance. To close a single workbook use the Close property of a vba.Workbook object.
Index.
Contents.
Copyright 2007