From: Heesob Park <phasis@...>
Date: 2009-02-24T16:11:48+09:00
Subject: Re: Fetch an excel sheet name in ruby

2009/2/24 Deepa Rajendran <deeparaj12@gmail.com>:
> Hai friends,
>          How to fetch an excel sheet name in ruby...

You can do it using win32ole like this:

require 'win32ole'

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


Regards,

Park Heesob