convert a html table to CSV using ruby

table_to_csv.rb

# run using ```rvm jruby-1.6.7 do  jruby "-J-Xmx2000m" "--1.9" tej.rb```

require 'rubygems'
require 'nokogiri'
require 'csv'

f = File.open("/tmp/preview.html")
doc = Nokogiri::HTML(f)
csv = CSV.open("/tmp/output.csv", 'w',{:col_sep => ",", :quote_char => '\'', :force_quotes => true})

#doc.xpath('//table/tbody/tr').take(10).each do |row|
doc.xpath('//table/tbody/tr').each do |row|
  tarray = [] 
  row.xpath('td').each do |cell|
    tarray << cell.text
  end
  csv << tarray
end

csv.close

This saved me some time. Thanks!

Thanks! It works for me. :D

thanks

Thanks!

Many Thanks!

Hi can anyone provide w with the script which convert full html file in csv file including tables and text

THANKS!!