Mario Ruiz wrote:
> So it's not possible using parseexcel.
> 
> Thanks a lot.
It it is possible. Take a look at the documentation. Here is a quick 
example:

require 'rubygems'
require 'parseexcel'
file='c:/download/test.xls'
workbook = Spreadsheet::ParseExcel.parse(file)
worksheet = workbook.worksheet(1)
puts 'worksheet by number is ' + worksheet.name
worksheet = workbook.worksheet('Sheet2')
puts 'worksheet by name is ' + worksheet.name

[DEPRECATED] By requiring 'parseexcel', 'parseexcel/parseexcel' and/or
             'parseexcel/parser' you are loading a Compatibility layer 
which
             provides a drop-in replacement for the ParseExcel library. 
This
             code makes the reading of Spreadsheet documents less 
efficient and
             will be removed in Spreadsheet version 1.0.0

worksheet by number is Sheet2
worksheet by name is Sheet2

Pretty much the same as the response by Jacob.

Take a look at your error "can't convert String into Integer".
Hope it helps.
-- 
Posted via http://www.ruby-forum.com/.