[python-win32] Range('A:A,D:D,G:G') in excel

Sylvain FAUVEAU (apli-agipa) info at apli-agipa.com
Fri Feb 3 14:23:56 CET 2006


Hello.

I have a little problem with this instruction.

If i run a macro in excel (Office 2003 SP1) to select 3 columns for exemple, 
the code in VB is :
Range('A:A,D:D,G:G')

But if I try this in python, I have a beautiful traceback :
excel.ActiveSheet.Range('A:A,D:D,G:G')

Traceback (most recent call last):
  File "<interactive input>", line 1, in ?
  File 
"C:\usr\Python24\lib\site-packages\win32com\gen_py\00020813-0000-0000-C000-000000000046x0x1x5.py", 
line 31738, in Range
    , Cell2)
com_error: (-2147352567, "Une exception s'est produite.", (0, None, None, 
None, 0, -2146827284), None)

Any idea ?

Sylvain FAUVEAU 



More information about the Python-win32 mailing list