Python accessing Excel 97 via com

Ulf Engström ulf.engstrom at b2b-link.com
Thu Feb 24 10:20:37 EST 2000


You can access one cell or many cells with Range()

Like in mySpread.Range('A1').Value = 'Spam'
mySpread.Range('A1:A3').Value = ['spam','and','eggs']

going vertical/both ways takes some thinking sometimes:
vertical
mySpread.Range('A1:A2').Value = [['More'],['Spam']]

and going both
mySpread.Range('A1:B2').Value = [['row1col1','row1col2'],['row2col1','row2col2']]

Hope this helps :)
Regards
Ulf
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-list/attachments/20000224/8c26fe70/attachment.html>


More information about the Python-list mailing list