From: Siddharth Venkatesan Date: 2013-01-25T07:50:20+09:00 Subject: Re: Reading and looping through Excel --14dae9340847580ddd04d4103a0b Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable +1 on the spreadsheet gem. It makes excel file reading such a trivial task. On Thursday, January 24, 2013, Dix wrote: > 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_txt.html > > > To open all the files: > > dir =3D "./yourdirectory/" > files =3D Dir.entries(dir) > > files. each do |file| > book =3D Spreadsheet.open dir + file > sheet =3D book.worsheet 0 > > =85=85. your work > > end > > > > -- > Pablo > > El jueves, 24 de enero de 2013 a las 17:41, Wayne Brisette escribi=F3: > > Joel: > > Thanks. That may work. I'll just have to query for the OS and have one > routine > for PC and one for Mac. > > Wayne > > > ----- Original Message ---- > From: Joel Pearson 'lists@ruby-forum.com');>> > To: ruby-talk ML 'ruby-talk@ruby-lang.org');>> > Sent: Thu, January 24, 2013 10:27:44 AM > Subject: Re: Reading and looping through Excel > > Does this look like what you need (bottom of the page)? > http://www.apeth.net/matt/aserrata.html > > -- > Posted via http://www.ruby-forum.com/. > > > --14dae9340847580ddd04d4103a0b Content-Type: text/html; charset=windows-1252 Content-Transfer-Encoding: quoted-printable +1 on the spreadsheet gem. It makes excel file reading such a trivial task.= =A0

On Thursday, January 24, 2013, Dix wrote:
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<= /div>

here'= ;s the guide


To open all the files:

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

files. each do |file|=A0
=A0 book = =3D Spreadsheet.open dir + file
=A0 sheet =3D book.worsheet 0

=A0 =A0=85=85. your work

end=



--=A0
<= div>Pablo

=20

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

Joel:

Th= anks. That may work. I'll just have to query for the OS and have one ro= utine
for PC and one for Mac.

=20 =20 =20 =20
=20

--14dae9340847580ddd04d4103a0b--