Fetch an excel sheet name in ruby

[Deepa Rajendran]

Hai friends,
How to fetch an excel sheet name in ruby...

 

[Daniel Berger]

Hai friends,
How to fetch an excel sheet name in ruby...

gem install spreadsheet

Regards,

Dan

 

[Deepa Rajendran]

Dan,
Thanks......
I installed spreadsheet. My concept is.
I download the .xls attachment file from my inbox,but i need to fetch
the excel sheet name through ruby coding.Could you plz help me.

 

[Heesob Park]

Hai friends,
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0How to fetch an excel sheet name in rub=

y...

You can do it using win32ole like this:

require 'win32ole'

xl =3D WIN32OLE.new('Excel.Application')
wb =3D xl.Workbooks.Open("c:/work/test.xls")
ws =3D wb.Worksheets(1)
puts ws.Name
wb.Close
xl.Quit


Regards,

Park Heesob

 

[Hannes Wyss]

You can do it using win32ole like this:

require 'win32ole'

xl =3D WIN32OLE.new('Excel.Application')
wb =3D xl.Workbooks.Open("c:/work/test.xls")
ws =3D wb.Worksheets(1)
puts ws.Name
wb.Close
xl.Quit

... and in Spreadsheet:

book =3D Spreadsheet.open("/path/to/xls")
sheet =3D book.worksheets.first
puts sheet.name


see also:
http://spreadsheet.rubyforge.org
http://spreadsheet.rubyforge.org/files/GUIDE_txt.html
http://spreadsheet.rubyforge.org/classes/Spreadsheet/Worksheet.html

hth

cheers,
Hannes