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