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

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

I've done similar job recently. I've copied part of code so look at it
maybe it could help you:
require 'nokogiri'
require 'spreadsheet'

class XmlParsing
  def test
    row = 0
    column = 0
    book = Spreadsheet::Workbook.new
    sheet = book.create_worksheet

    Dir.chdir("xml")
    puts Dir.pwd
    Dir.glob("*.xml") do |file|
      f = File.open(file)
      doc = Nokogiri::XML(f)
      fullname_node = doc.at_xpath("//full_name")
      sheet[row,column] = fullname_node.content
      f.close
      row += 1
    end
    book.write 'spreadsheet.xls'
  end
end

xml = XmlParsing.new
xml.test


I'm not sure if it works because I've deleted some code from original
script but this is general idea. It script parses xml document and puts
information into excel.

Plus you need spreadsheet gem. You can install it with:
sudo gem install spreadsheet.

Or there is better way to do it. Make one file named Gemfile and put this
content into it:
source 'https://rubygems.org'

gem 'nokogiri'
gem 'spreadsheet'

Save file and go to console cd to dir where Gemfile is located and run:
bundle install

This is preferred way to go because there is no need to install gems one by
one manually. Instead when you want to run your software on different
machine you just invoke bundle install.

Hope it helps.

2012/9/6 Sybren Kooistra <lists@ruby-forum.com>

> Hi Ivan, thanks.
>
> I'm doing my best here, and I do search before I post. I was just
> checking if I was working in the right direction. Excel library is step
> two.
>
> --
> Posted via http://www.ruby-forum.com/.
>
>

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

I&#39;ve done similar job recently. I&#39;ve copied part of code so look at=
 it maybe it could help you:<div><div>require &#39;nokogiri&#39;</div><div>=
require &#39;spreadsheet&#39;</div><div><br></div><div>class XmlParsing</di=
v>

<div>=C2=A0 def test</div><div>=C2=A0 =C2=A0 row =3D 0</div><div>=C2=A0 =C2=
=A0 column =3D 0</div><div>=C2=A0 =C2=A0 book =3D Spreadsheet::Workbook.new=
</div><div>=C2=A0 =C2=A0 sheet =3D book.create_worksheet</div><div>=C2=A0 =
=C2=A0=C2=A0</div><div>=C2=A0 =C2=A0 Dir.chdir(&quot;xml&quot;)</div><div>
=C2=A0 =C2=A0 puts Dir.pwd</div>
<div>=C2=A0 =C2=A0 Dir.glob(&quot;*.xml&quot;) do |file|</div><div>=C2=A0 =
=C2=A0 =C2=A0 f =3D File.open(file)</div><div>=C2=A0 =C2=A0 =C2=A0 doc =3D =
Nokogiri::XML(f)</div><div>=C2=A0 =C2=A0 =C2=A0 fullname_node =3D doc.at_xp=
ath(&quot;//full_name&quot;)</div><div>=C2=A0 =C2=A0 =C2=A0 sheet[row,colum=
n] =3D fullname_node.content</div>

<div>=C2=A0 =C2=A0 =C2=A0 f.close</div><div>=C2=A0 =C2=A0 =C2=A0 row +=3D 1=
</div><div>=C2=A0 =C2=A0 end</div><div>=C2=A0 =C2=A0 book.write &#39;spread=
sheet.xls&#39;</div><div>=C2=A0 end</div><div>end</div><div><br></div><div>=
xml =3D XmlParsing.new</div><div>xml.test</div><div><br>

</div><div><br></div><div>I&#39;m not sure if it works because I&#39;ve del=
eted some code from original script but this is general idea. It script par=
ses xml document and puts information into excel.</div><div><br></div>
<div>
Plus you need spreadsheet gem. You can install it with:</div><div>sudo gem =
install spreadsheet.</div><div><br></div><div>Or there is better way to do =
it. Make one file named Gemfile and put this content into it:</div><div>

<div>source &#39;<a href=3D"https://rubygems.org">https://rubygems.org</a>&=
#39;</div><div><br></div><div>gem &#39;nokogiri&#39;</div><div>gem &#39;spr=
eadsheet&#39;</div></div><div><br></div><div>Save file and go to console cd=
 to dir where Gemfile is located and run:</div>

<div>bundle install</div><div><br></div><div>This is preferred way to go be=
cause there is no need to install gems one by one manually. Instead when yo=
u want to run your software on different machine you just invoke bundle ins=
tall.</div>

<div><br></div><div>Hope it helps.</div><br><div class=3D"gmail_quote">2012=
/9/6 Sybren Kooistra <span dir=3D"ltr">&lt;<a href=3D"mailto:lists@ruby-for=
um.com" target=3D"_blank">lists@ruby-forum.com</a>&gt;</span><br><blockquot=
e class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc sol=
id;padding-left:1ex">

Hi Ivan, thanks.<br>
<br>
I&#39;m doing my best here, and I do search before I post. I was just<br>
checking if I was working in the right direction. Excel library is step<br>
two.<br>
<div class=3D"HOEnZb"><div class=3D"h5"><br>
--<br>
Posted via <a href=3D"http://www.ruby-forum.com/" target=3D"_blank">http://=
www.ruby-forum.com/</a>.<br>
<br>
</div></div></blockquote></div><br></div>

--047d7b33d51845a26804c905d594--