[Tutor] Traversing Excel Columns

John Fouhy john at fouhy.net
Tue Sep 12 08:03:06 CEST 2006


On 12/09/06, Chris Hengge <pyro9219 at gmail.com> wrote:
> I don't suppose that anyone has a fix for me eh? I've tried about all I
> can think of and I'd like to be able to give this program a trial
> tomorrow when I get back to work.. sure would save me some time :]

Will there be internal blanks?  You could just scan for Cells(row,
col).Value in (None, '').

Otherwise, run makepy.py (if you haven't already) on Excel, and then
look through the code it generates.  It will show you all the methods
you can call, and what arguments they expect.  Something may leap out
at you.

-- 
John.


More information about the Tutor mailing list