ROO set_value

[dakshayini]

Hello,
I want to write the data to excel/excelx file.My problem is,i am using 'roo' gem where set_value/set/set_cell_values method cannot be accessed.
Say if i use like this,
oo = Openoffice.new( "C:\\Book1.ods" )
oo.set_value(0, 0,"Hello")
I am getting an error,
Method set_value is missing
What alternative method i can use to make it work/write into excel using 'roo'?Please help me.

[improvcornartist]

You might just need to specify the sheet. For example, oo.default_shee t = oo.sheets.first