From: Do Re Mi chel La Si Do <enleverlesO.OmcO@...>
Date: 2005-11-15T05:17:16+09:00
Subject: Re: win32ole --Test-- Ruby vs. Python

Bonsoir !     Hi!

Regardez ce code :   (look this coding : )


import time
Gime = time.time()
from win32com.client import Dispatch

xlApp = Dispatch("Excel.Application")
xl_file = ('c:\\testdata.xls')
xlApp.Workbooks.Open(xl_file)

excel_cells_total=0

#for i in xlApp.Range("B1:B1001").Value: 
#1st mode
for i in xlApp.Range(xlApp.Cells(1,2),xlApp.Cells(1001,2)).Value:     #2nd 
mode
    excel_cells_total+=i[0]

xlApp.ActiveWorkbook.Close()
xlApp.Quit

print 'Excel 1000 cells total is '
print excel_cells_total
print 'Python Elapsed '
print (time.time() - Gime)





@-salutations

Michel Claveau