How to access the spreadsheet with name in Openoffice - Using roo gem

[Preci]

I am able to access the first worksheet using "oo.sheets.first". Can
anyone help me in accessing the rest of the worsheet in ods file.


Thanks
Preci

[Thomas Preymesser]

On May 14, 8:46 am, Preci <precilla.j...@gmail.com> wrote:
> I am able to access the first worksheet using "oo.sheets.first". Can
> anyone help me in accessing the rest of the worsheet in ods file.

"oo.sheets.first" is the same as "oo.sheets[0]", which is the first
element of the "sheets"-array.
The second sheet is "oo.sheets[1]".

'.first' and '.last' are methods from the class Array, but there is no
such thing as 'second', 'third', ...



-Thomas

[Hugh McGowan]

You can specify a sheet with:

oo.default_sheet = 'Sheet2'
oo.default_sheet = oo.sheeets(3)
oo.sheets.each { |sheet|  ...do stuff ...}

See the rdoc here: http://roo.rubyforge.org/rdoc/index.html

Thanks!
Hugh