[pywin32] - Excel COM problem

[Andrea Gavana]

Hi All,

I have a very simple python script that tries to put a rectangular
shape in a worksheet and then add some text inside that shape. The
main problem, is that as usual Excel doesn't like input strings longer
than 200 and something characters. So, by just recording a macro in
Excel, I tried to append the text in the shape by dividing it in
chunks. For example, I tried this little script:

#----------------------------------
from win32com.client import Dispatch

finalText = "A"*1250

xlsapp = Dispatch("Excel .Application")
wb = xlsapp.Workbook s.Add()
sheet = wb.Sheets[0]

myShape = sheet.Shapes.Ad dShape(1, 315, 200, 400, 300)
myShape.Select( )

xlsapp.Selectio n.Characters.Te xt = finalText[0:200]
xlsapp.Selectio n.Characters(20 0).Insert(final Text[200:400])

excelfile = "Hello.xls"
wb.SaveAs(excel file)
wb.Close()
xlsapp.Quit()

#----------------------------------

And it crashes with an impossible error:

Traceback (most recent call last):
File "D:\MyProjects\ pywin32.py", line 13, in <module>
xlsapp.Selectio n.Characters(20 0).Insert(final Text[200:400])
File "C:\Python25\li b\site-packages\win32c om\client\dynam ic.py", line 172, in
__call__
return self._get_good_ object_(self._o leobj_.Invoke(* allArgs),self._ olerepr_.
defaultDispatch Name,None)
pywintypes.com_ error: (-2147352573, 'Member not found.', None, None)

However, the macro I recorded in Excel does exactly that: it appends
chunks of the string with a maximum length of 200 chars.
Am I missing something here?
This is with Python 2.5, PythonWin 2.5 (r25:51908, Sep 19 2006,
09:52:17) [MSC v.1310 32 bit (Intel)] on win32, Windows XP SP2.

Thank you for your consideration.

Andrea.

"Imaginatio n Is The Only Weapon In The War Against Reality."
http://xoomer.virgilio.it/infinity77/