Read data from Excel


#1

If you work on Windows you can use the win32ole implementation:
http://www.rubygarden.org/ruby?ScriptingExcel
You’ll also find an introduction in the “Programming Ruby” Book.

Otherwise your client could save the excel sheets as csv.

derkaan

A client of mine has a ton of data stored in Excel spreadsheets. I’m
building a web application for her (backed by a real db of course) and
want
to import all that data. Is there a library available to read data from
Excel? Is there an easy way to upload the spreadsheets and then read the
data?


No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.371 / Virus Database: 267.14.18/230 - Release Date:
14.01.2006