[Tutor] Traversing Excel Columns
pyro9219 at gmail.com
Wed Sep 13 10:06:35 CEST 2006
I'll give that a shot tomorrow when I work on the script some more.
Thanks for the note on 'file'... none of the IDE's I've used have
colored or yelled at me, so I just assumed it was free for the taking..
(used to VS where it yells at you for more then I'd care)
I've just started using SPE though... I'm very impressed with it
compared to some of the others of tried which either just weren't quite
ready for retail or to much like a plain text editor for my liking.
Unless something comes up that I can't get working right, I'll be
pitching the author a few bucks for his work :]
Thanks again for all the help. Hopefully one day I'll be able to
contribute some back!
On Wed, 2006-09-13 at 04:12 +0100, Alan Gauld wrote:
> > I can get file.write("'%s',") % xlSht.Cells(row,1).Value
> > to work..
> file.write("'%s'," % xlSht.Cells(row,1).Value)
> Try that....
> The string formatting must happen inside the parens.
> BTW using 'file' as a variab;e is not good since file is a
> built-in function name (albeit an alias for open) and could
> confuse a reader..
> Alan G.
More information about the Tutor