Hmm... ok... after some thought... this is what I'm looking for
#some great line that gives me an int for the number of not null cells
intLastUsedRow = xlSht.Cells.LastValue #Made this up, but basically what I need.
I need to iterate through a range() because I dont know another good way to tell it not to use the column headings and other junk over the data I want to collect.
try: #Loop through rows
for row in range(5,intLastUsedRow):
#Write each row, incriment 1+row in column 5
file.write(xlSht.Cells(1+row,5).Value)
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
