Excel Ranges from Python COM server
Robin Becker
robin at jessikat.demon.co.uk
Tue Feb 1 11:30:36 EST 2000
In article <876t6g$iap$1 at nnrp1.deja.com>, Don <don_b at my-deja.com> writes
>I am having trouble setting getting data from Python to set a range in
>Excel VBA. From Python I can manipulate Excel ranges as tuples of
>tuples, just fine. But I am doing something wrong calling Python from
>VB. The following example demonstrates my problem.
>
>An Excel Range gives me a Python tuple of tuples in Python, but a Python
>typle of tuples is not an Excel Range in Excel. What should my
>function, getRange return?
>
.
>
...
I had similar problems. It seems pythoncom has probs with two
dimensional ranges. I just switched to row ranges. I made python do the
work though as python loops were faster than vba.
--
Robin Becker
More information about the Python-list
mailing list