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.

Workbook object (PFE).


he vba.Workbook object represents the Excel file (Excel workbook) loaded into the Excel application. The vba.Workbook object may be obtained by calling the ActiveWorkbook property of the Application object, by using indexing property of the vba.Workbooks object or by calling the Parent property of the vba.Worksheet(s) object. The vba.Workbook object is supplied into several event handlers by the ExcelListener.


Figure




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).

Index. Contents.


















Copyright 2007