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).
F. Range object (PFE).
a. __call__ method (vba.Range).
b. Activate method (vba.Range).
c. Address property (vba.Range).
d. Borders property (vba.Range).
e. Calculate method (vba.Range).
f. Cells property (vba.Range).
g. Clear method (vba.Range).
h. Column property (vba.Range).
i. ColumnWidth property (vba.Range).
j. Columns property (vba.Range).
k. Count property (vba.Range).
l. CurrentRegion property (vba.Range).
m. Delete method (vba.Range).
n. Dispatch property (vba.Range).
o. EntireColumn property (vba.Range).
p. EntireRow property (vba.Range).
q. FillDown method (vba.Range).
r. FillLeft method (vba.Range).
s. FillRight method (vba.Range).
t. FillUp method (vba.Range).
u. Font property (vba.Range).
v. Formula property (vba.Range).
w. Height property (vba.Range).
x. Hidden property (vba.Range).
y. Hyperlinks property (vba.Range).
z. Interior property (vba.Range).
{. Item method (vba.Range).
|. Name property (vba.Range).
}. NumberFormat property (vba.Range).
~. Offset method (vba.Range).
. Parent property (vba.Range).
. Resize method (vba.Range).
. Row property (vba.Range).
. RowHeight property (vba.Range).
. Rows property (vba.Range).
. Select method (vba.Range).
. Show method (vba.Range).
. Value property (vba.Range).
. Width property (vba.Range).
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.

__call__ method (vba.Range).


he vba.Range may represent an individual cells, a collection of individual cells, a collection of rows or a collection of columns. The __call__ provides access to items of such collection. The __call__ (or Item) takes an integer index as the only argument. The returned value depends on the origin of the Range object. If the Range object was returned from Rows or Columns property then the __call__ method returns a row or a column. An otherwise generated Range object is a collection of individual cells. A Range object with a different rearrangement of cell indexing may obtained by calling the properties Cells, Rows and Columns of the given Range object.


Figure





Index. Contents.


















Copyright 2007