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).
a.
__call__method (vba.Worksheets).
b.
AddAfter method (vba.Worksheets).
c.
AddBefore method (vba.Worksheets).
d.
CopyAfter method (vba.Worksheets).
e.
CopyBefore method (vba.Worksheets).
f.
Count property (vba.Worksheets).
g.
Dispatch property (vba.Worksheets).
h.
Item method (vba.Worksheets).
i.
Parent property (vba.Worksheets).
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.
Worksheets object (PFE).
he vba.Worksheets object represents the collection of sheets of a workbook. Such object may be obtained by invoking Worksheets property of a vba.Workbook object. The vba.Worksheets is a callable Python object.
a.
__call__method (vba.Worksheets).
b.
AddAfter method (vba.Worksheets).
c.
AddBefore method (vba.Worksheets).
d.
CopyAfter method (vba.Worksheets).
e.
CopyBefore method (vba.Worksheets).
f.
Count property (vba.Worksheets).
g.
Dispatch property (vba.Worksheets).
h.
Item method (vba.Worksheets).
i.
Parent property (vba.Worksheets).
Index.
Contents.
Copyright 2007