From: "reed.adam@..." <reed.adam@...>
Date: 2006-08-10T22:40:08+09:00
Subject: Re: Entering data into Excel, in specific iterated rows/colu

Wow David, that's dedication -- coding before tea?  Were you at least
wearing a helmet or other protection?

I really do appreciate the reply, that's _exactly_ what I was looking
for.  Even if it happens to not fully work, that's the logic I was
looking for so the commands should quickly follow.

Thanks again --


David Mullet wrote:

>
> xl = WIN32OLE.new("Excel.Application")
> xl.Visible = 1
> wb = xl.Workbooks.Add
> ws = wb.Worksheets(1)
> row = 0
> $ie.links.each do |link|
>     next if link.innerText.empty?
>     row = row + 1
>     ws.Cells(row, 1).Value = link.innerText
>     ws.Cells(row, 2).Value = link.href
> end
>
> [ Not tested, and posted before I've had my morning tea... ]
> 
> Mully
> 
> 
> -- 
> Posted via http://www.ruby-forum.com/.