From: "Иван Бишевац" <ivan.bisevac@...>
Date: 2012-09-09T21:31:07+09:00
Subject: Re: Parsing through downloaded html

--f46d042dfff5ce525104c94403f1
Content-Type: text/plain; charset=UTF-8

require 'nokogiri'
require 'spreadsheet'

Spreadsheet.client_encoding = 'UTF-8'
book = Spreadsheet::Workbook.new
sheet1 = book.create_worksheet

# Numbering is zero based. This means that first row is labeled 0, first
column 0.
row = 0

Dir.chdir("anattempt")
Dir.glob['*.html'].each do |document|
  f = file.open(document)
  searchablefile = Nokogiri::HTML(f)

  # use at_xpath rather than xpath since first one method returns just 1
element,
  # but second method xpath returns array of all found records matching
criteria
  var1 = searchablefile.at_xpath("your xpath here..")
  var2 = searchablefile.at_xpath("your xpath here..")

  # In first pass it saves data to first row, and two columns A and B.
  # Every nest pass increments row by 1, but columns are same A and B.
  sheet1[row, 0] = variabelebasedonaxpath.content
  shhet1[row, 1] = variabelebasedonaxpath.content

  #After saving data increment row position by 1
  row += 1
end

book.write 'htmltoexcel.xls'


I didn't tested this, but if something goes wrong ask here.
Also read http://nokogiri.org/tutorials for learning how to parse xml/html
documents, that's short but useful resource.

--f46d042dfff5ce525104c94403f1
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div>require &#39;nokogiri&#39;</div><div>require &#39;spreadsheet&#39;</di=
v><div><br></div><div>Spreadsheet.client_encoding =3D &#39;UTF-8&#39;</div>=
<div>book =3D Spreadsheet::Workbook.new</div><div>sheet1 =3D book.create_wo=
rksheet</div>

<div><br></div><div># Numbering is zero based. This means that first row is=
 labeled 0, first column 0.</div><div>row =3D 0</div><div><br></div><div>Di=
r.chdir(&quot;anattempt&quot;)</div><div>Dir.glob[&#39;*.html&#39;].each do=
 |document|</div>

<div>=C2=A0 f =3D file.open(document)</div><div>=C2=A0 searchablefile =3D N=
okogiri::HTML(f)</div><div>=C2=A0=C2=A0</div><div>=C2=A0 # use at_xpath rat=
her than xpath since first one method returns just 1 element,</div><div>=C2=
=A0 # but second method xpath returns array of all found records matching c=
riteria</div>

<div>=C2=A0 var1 =3D searchablefile.at_xpath(&quot;your xpath here..&quot;)=
</div><div>=C2=A0 var2 =3D searchablefile.at_xpath(&quot;your xpath here..&=
quot;)</div><div>=C2=A0=C2=A0</div><div>=C2=A0 # In first pass it saves dat=
a to first row, and two columns A and B.</div>

<div>=C2=A0 # Every nest pass increments row by 1, but columns are same A a=
nd B.</div><div>=C2=A0 sheet1[row, 0] =3D variabelebasedonaxpath.content</d=
iv><div>=C2=A0 shhet1[row, 1] =3D variabelebasedonaxpath.content</div><div>=
=C2=A0=C2=A0</div><div>=C2=A0 #After saving data increment row position by =
1</div>

<div>=C2=A0 row +=3D 1</div><div>end</div><div><br></div><div>book.write &#=
39;htmltoexcel.xls&#39;</div><div><br></div><div><br></div><div>I didn&#39;=
t tested this, but if something goes wrong ask here.</div><div>Also read=C2=
=A0<a href=3D"http://nokogiri.org/tutorials">http://nokogiri.org/tutorials<=
/a>=C2=A0for learning how to parse xml/html documents, that&#39;s short but=
 useful resource.</div>


--f46d042dfff5ce525104c94403f1--