From: Jacob Helwig <jacob@...>
Date: 2009-10-16T00:45:54+09:00
Subject: Re: parseexcel, how to select a worksheet using the name

On Thu, Oct 15, 2009 at 07:53, Mario Ruiz <tcblues@gmail.com> wrote:
> Hi,
> I know it's possible to select a worksheet using its number  but I don't
> know how to select it using the worksheet name. is it possible?
>
> workbook = Spreadsheet::ParseExcel.parse(file)
> worksheet = workbook.worksheet(2)
>
> thanks.
>

Replace 2 with the name of the worksheet.

worksheet = workbook.worksheet('worksheet name')