Quantitative Analysis
Parallel Processing
Numerical Analysis
C++ Multithreading
Python for Excel
Python Utilities

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.

EntireColumn property (vba.Range).

he EntireColumn property returns the minimal column collection containing the given range.


Index. Contents.

Copyright 2007