[Tutor] Traversing Excel Columns

[Chris Hengge]

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 <alan.gauld at btinternet.com> 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 at python.org
> http://mail.python.org/mailman/listinfo/tutor
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.python.org/pipermail/tutor/attachments/20060911/06c3e6e5/attachment.htm