R
reed.adam
I have a script that spiders a page looking for elements. In this
specific case, I'm looking for links (innerText and href).
I have this script working so far to output data to a text file, but
I'd like to output it to an Excel file for organization. I'm getting
stuck however trying to think of the correct method to put all of the
link.innerText values into A1, A2, A3, etc and the corresponding
link.href into B1, B2, etc.
Here is the code I have so far (with the normal text file code in place
of the excel code I have yet to think of):
ef grab_links(url)
$ie.goto(url)
excel = WIN32OLE.new("excel.application")
excel.visible = true
workbook = excel.workbooks.add
workbook.saveas("#{Project}_links.xls")
workbook.close
linkfile.puts "\n#{url}"
$ie.links.each{|link|
linkfile.puts("#{link.innerText} - #{link.href}") unless
link.innerText.empty?
}
linkfile.puts "\n\n"
end
One big file with it formatted like this would be fine, or even a
different worksheet for each URL would be great. I'm not really
concered with that. Can you guys give me hand?
Thanks!
specific case, I'm looking for links (innerText and href).
I have this script working so far to output data to a text file, but
I'd like to output it to an Excel file for organization. I'm getting
stuck however trying to think of the correct method to put all of the
link.innerText values into A1, A2, A3, etc and the corresponding
link.href into B1, B2, etc.
Here is the code I have so far (with the normal text file code in place
of the excel code I have yet to think of):
ef grab_links(url)
$ie.goto(url)
excel = WIN32OLE.new("excel.application")
excel.visible = true
workbook = excel.workbooks.add
workbook.saveas("#{Project}_links.xls")
workbook.close
linkfile.puts "\n#{url}"
$ie.links.each{|link|
linkfile.puts("#{link.innerText} - #{link.href}") unless
link.innerText.empty?
}
linkfile.puts "\n\n"
end
One big file with it formatted like this would be fine, or even a
different worksheet for each URL would be great. I'm not really
concered with that. Can you guys give me hand?
Thanks!