Read excel file

dubstep · July 27, 2011, 4:55am

How to read the excel file(.xls)

I tried to use the gem ‘parseexcel’,
but it can’t exactly parser the string.

Does have other better method to parser the xls content?

cc_c · July 27, 2011, 9:26am

Use win32ole. Easier than falling off a log.

cc_c · July 27, 2011, 5:32pm

Win32ole is easy to use. The website that Mike linked to is a great
resource. I script excel all day. Do you have a sample excel sheet?

Timothy

cc_c · July 27, 2011, 11:00am

parseexcel was merged in spreadsheet some years ago.

you can install spreadsheet via gem

Masa

2011/7/27 Mike S. [email protected]:

cc_c · July 27, 2011, 6:47pm

On Wed, Jul 27, 2011 at 3:59 AM, Masa [email protected] wrote:

parseexcel was merged in spreadsheet some years ago.

http://spreadsheet.ch/

you can install spreadsheet via gem

This. just use it. it works & is dead simple.
Andrew McElroy