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
