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

Anu Sebastian wrote:
> Hi,

> 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 :

>     require 'rubygems'
>     require 'spreadsheet'
>     require 'parseexcel'
>     equire 'parseexcel/parseexcel'
>     require 'parseexcel/parser'

>       workbook =
> Spreadsheet::ParseExcel.parse("public/downloads/commissions/google/test.xls ")
>       worksheet = workbook.worksheet(0)

>         worksheet.each { |row|
>                 puts row.at(0).to_s

>         }

Norman Smith wrote:
> Anu Sebastian wrote:
>> Hi,

>> 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 :

>>     require 'rubygems'
>>     require 'spreadsheet'
>>     require 'parseexcel'
>>     equire 'parseexcel/parseexcel'
>>     require 'parseexcel/parser'

>>       workbook =
>> Spreadsheet::ParseExcel.parse("public/downloads/commissions/google/test.xls ")
>>       worksheet = workbook.worksheet(0)

>>         worksheet.each { |row|
>>                 puts row.at(0).to_s

>>         }

> nil usually means empty rows. Also each row is an array of cells. You
> could use inspect instead of to_s to see what's really there. This is
> how I get data from a spreadsheet:

>   ws.each { |row|
>       if row != nil
>             #
>             # cycle over each cell in this row if it's not an empty row
>             #
>         row.each { |cell|
>           if cell != nil
>             contents = cell.to_s('latin1')
>             puts("Cell Contents: #{contents}\n")
>           end
>         }
>       end
>   }