I am using ruby ruby 1.8.6 and spreadsheet (0.6.4).
I am trying to oarse an excel file.
My code is like :
But it prints 'nil'. I have data in my excel file.
Hannes Wyss wrote:
> Spreadsheet::ParseExcel - Get information from an Excel file.
> ============
> Version: 0.3.2
> Date: 2005-12-15
> Short Description:
> Spreadsheet::ParseExcel allows you to get information out of a simple
> Excel file
> This Package is an - as of today incomplete - translation of Kawai
> Takanoris Perl-Module.
> Requirements
> ------------
> * ruby 1.8
> Install
> -------
> De-Compress archive and enter its top directory.
> Then type:
> $ ruby setup.rb config
> $ ruby setup.rb setup
> ($ su)
> # ruby setup.rb install
> You can also install files into your favorite directory
> by supplying setup.rb some options. Try "ruby setup.rb --help".
> Usage
> -----
> workbook = Spreadsheet::ParseExcel.parse(path_to_file)
> worksheet = workbook.worksheet(0)
> worksheet.each(1) { |row|
> puts row.at(0)
> }
> License
> -------
> LGPL
> URL: http://download.ywesee.com/parseexcel
> Author: Hannes Wyss <hw...@ywesee.com>
> Enjoy, and thanks for your feedback!
> Hannes
--