From: Dix <thedixie@...>
Date: 2013-01-25T04:18:28+09:00
Subject: Re: Reading and looping through Excel

--51018730_71f32454_9e
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

I've done something similar using the spreadsheet gem, it's easy to open =
a workbook and iterate over the rows extracting what you want

here's the guide
http://spreadsheet.rubyforge.org/files/GUIDE=5Ftxt.html


To open all the files:

dir =3D =22./yourdirectory/=22
files =3D Dir.entries(dir)

files. each do =7Cfile=7C =20
  book =3D Spreadsheet.open dir + file
  sheet =3D book.worsheet 0

   =E2=80=A6=E2=80=A6. your work

end



-- =20
Pablo


El jueves, 24 de enero de 2013 a las 17:41, Wayne Brisette escribi=C3=B3:=


> Joel: =20
> =20
> Thanks. That may work. I'll just have to query for the OS and have one =
routine =20
> for PC and one for Mac.
> =20
> Wayne
> =20
> =20
> ----- Original Message ----
> =46rom: Joel Pearson <lists=40ruby-forum.com (mailto:lists=40ruby-forum=
.com)>
> To: ruby-talk ML <ruby-talk=40ruby-lang.org (mailto:ruby-talk=40ruby-la=
ng.org)>
> Sent: Thu, January 24, 2013 10:27:44 AM
> Subject: Re: Reading and looping through Excel
> =20
> Does this look like what you need (bottom of the page)=3F =20
> http://www.apeth.net/matt/aserrata.html
> =20
> -- =20
> Posted via http://www.ruby-forum.com/.
> =20
> =20



--51018730_71f32454_9e
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline


                <div style=3D=22font-family: 'Comic Sans MS'; font-size: =
12px; =22>I've done something similar using the spreadsheet gem, it's eas=
y to open a workbook and iterate over the rows extracting what you want</=
div><div style=3D=22font-family: 'Comic Sans MS'; font-size: 12px; =22><b=
r></div><div style=3D=22font-family: 'Comic Sans MS'; font-size: 12px; =22=
>here's the guide</div><div style=3D=22font-family: 'Comic Sans MS'; font=
-size: 12px; =22><a href=3D=22http://spreadsheet.rubyforge.org/files/GUID=
E=5Ftxt.html=22>http://spreadsheet.rubyforge.org/files/GUIDE=5Ftxt.html</=
a></div>
                <div><div><br></div><div><font face=3D=22Comic Sans MS=22=
><span style=3D=22font-size: 12px;=22><br></span></font></div><div><font =
face=3D=22Comic Sans MS=22><span style=3D=22font-size: 12px;=22>To open a=
ll the files:</span></font></div><div><font face=3D=22Comic Sans MS=22><s=
pan style=3D=22font-size: 12px;=22><br></span></font></div><div><font fac=
e=3D=22Comic Sans MS=22><span style=3D=22font-size: 12px;=22>dir =3D&nbsp=
;</span></font><span style=3D=22font-family: 'Comic Sans MS'; font-size: =
12px; =22>=22./yourdirectory/=22</span></div><div><font face=3D=22Comic S=
ans MS=22><span style=3D=22font-size: 12px;=22>files =3D Dir.entries(dir)=
</span></font></div><div><font face=3D=22Comic Sans MS=22><span style=3D=22=
font-size: 12px;=22><br></span></font></div><div><font face=3D=22Comic Sa=
ns MS=22><span style=3D=22font-size: 12px;=22>files. each do =7Cfile=7C&n=
bsp;</span></font></div><div><font face=3D=22Comic Sans MS=22><span style=
=3D=22font-size: 12px;=22>&nbsp; book =3D Spreadsheet.open dir + file</sp=
an></font></div><div><font face=3D=22Comic Sans MS=22><span style=3D=22fo=
nt-size: 12px;=22>&nbsp; sheet =3D book.worsheet 0</span></font></div><di=
v><font face=3D=22Comic Sans MS=22><span style=3D=22font-size: 12px;=22><=
br></span></font></div><div><font face=3D=22Comic Sans MS=22><span style=3D=
=22font-size: 12px;=22>&nbsp; &nbsp;=E2=80=A6=E2=80=A6. your work</span><=
/font></div><div><font face=3D=22Comic Sans MS=22><br></font></div><div><=
font face=3D=22Comic Sans MS=22><span style=3D=22font-size: 12px;=22>end<=
/span></font></div><div><br></div><div><br></div><div><br></div><div>--&n=
bsp;</div><div>Pablo</div><div><br></div></div>
                =20
                <p style=3D=22color: =23A0A0A8;=22>El jueves, 24 de enero=
 de 2013 a las 17:41, Wayne Brisette escribi=C3=B3:</p>
                <blockquote type=3D=22cite=22 style=3D=22border-left-styl=
e:solid;border-width:1px;margin-left:0px;padding-left:10px;=22>
                    <span><div><div><div>Joel: </div><div><br></div><div>=
Thanks. That may work. I'll just have to query for the OS and have one ro=
utine </div><div>for PC and one for Mac.</div><div><br></div><div>Wayne</=
div><div><br></div><div><br></div><div>----- Original Message ----</div><=
div>=46rom: Joel Pearson &lt;<a href=3D=22mailto:lists=40ruby-forum.com=22=
>lists=40ruby-forum.com</a>&gt;</div><div>To: ruby-talk ML &lt;<a href=3D=
=22mailto:ruby-talk=40ruby-lang.org=22>ruby-talk=40ruby-lang.org</a>&gt;<=
/div><div>Sent: Thu, January 24, 2013 10:27:44 AM</div><div>Subject: Re: =
Reading and looping through Excel</div><div><br></div><div>Does this look=
 like what you need (bottom of the page)=3F </div><div><a href=3D=22http:=
//www.apeth.net/matt/aserrata.html=22>http://www.apeth.net/matt/aserrata.=
html</a></div><div><br></div><div>-- </div><div>Posted via <a href=3D=22h=
ttp://www.ruby-forum.com=22>http://www.ruby-forum.com</a>/.</div></div></=
div></span>
                =20
                =20
                =20
                =20
                </blockquote>
                =20
                <div>
                    <br>
                </div>
            
--51018730_71f32454_9e--