[python-win32] Pywin32-Excel Range/Cells problems

Sylvain Fauveau (apli-agipa) info at apli-agipa.com
Mon Mar 15 11:51:20 CET 2010


Hello everybody.

I have detected a problem with a cell with loooong text in it but I'm 
not sure of his source.

To reproduce it :
from win32com.client import Dispatch
excel = Dispatch('Excel.Application')
sheet = excel.ActiveSheet

sheet.Range('A1:C1').Value = ['test','test'*400,'test']
doesn't work :
pywintypes.com_error(-2147352567,"Une exception s'est produite.", (0, 
None, None, None, 0, -2416827284), None)

But :
sheet.Cells('A1').Value = 'test'*400
work

I have searching on google to see if I found an excel problem, but 
doesn't find. If I make copy/paste from Excel, it's ok.
Python 2.5
Pywin32-211
Office 2003 SP3

If someone has an idee...

Best regards

-- 

*Sylvain Fauveau*
Apli-Agipa
Tél: 03-26-58-18-28
Logo d'APLI-AGIPA
--Pensez à la nature et n'imprimez cet email que si nécessaire--

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-win32/attachments/20100315/edfd6af0/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature_agipa-apli.JPG
Type: image/jpeg
Size: 12696 bytes
Desc: not available
URL: <http://mail.python.org/pipermail/python-win32/attachments/20100315/edfd6af0/attachment.jpe>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: info.vcf
Type: text/x-vcard
Size: 176 bytes
Desc: not available
URL: <http://mail.python.org/pipermail/python-win32/attachments/20100315/edfd6af0/attachment.vcf>


More information about the python-win32 mailing list