From: Greg Halsey <ghalsey@...>
Date: 2009-10-20T23:02:23+09:00
Subject: Re: parseexcel, how to select a worksheet using the name

Mario Ruiz wrote:
> Any help???

require 'rubygems'
require 'spreadsheet'
file='c:/download/test.xls'
workbook=Spreadsheet.open file

worksheet = workbook.worksheet(1)
p worksheet.inspect
# <Spreadsheet::Excel::Worksheet:0x000000015fafa4 @name=Sheet2 ...

worksheet = workbook.worksheet('Sheet2')

p worksheet.inspect
#<Spreadsheet::Excel::Worksheet:0x000000015fafa4 @name=Sheet2 ...

# Start with GUIDE.TXT located 
C:\Ruby\lib\ruby\gems\1.8\gems\spreadsheet-0.6.4.1
# hope it helped.


-- 
Posted via http://www.ruby-forum.com/.