Just tried that (pretty sure I already did, but hey... I could have goofed it)
 
No go

 
On 9/11/06, Alan Gauld <[EMAIL PROTECTED]> wrote:
I'm no expert in Excel programming but I assum,e you tried
the obvious:

> I'm looking for something more like
> try:#Loop until rows are null
>    while row in xlwksht != null
>         #Write each row, incriment 1+row in column 5
>         print >> file, "'" + %s + "',", %
> ( xlSht.Cells(1+row,5).Value)

for row in xlSht.Cells:
   print >> file, row.Value

I know you can do something similar in _vbscript_, I'm not sure
if the Python bindinghs to the COM objects are gtthat clever however.

But might be worth some experimenting at the >>> prompt.

Alan G.


_______________________________________________
Tutor maillist  -  Tutor@python.org
http://mail.python.org/mailman/listinfo/tutor

_______________________________________________
Tutor maillist  -  Tutor@python.org
http://mail.python.org/mailman/listinfo/tutor

Reply via email to