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.

Hidden property (vba.Range).


orksheet cells may be visible or hidden. The Hidden property controls such state. Not every range may be hidden. Rows and columns may be hidden but individual cells could not be hidden. The Hidden property would throw an exception when this property is not applicable. Otherwise it would return a boolean value. This is a read/write property. Setting it to True hides ranges.


Figure


Figure





Index. Contents.


















Copyright 2007