From: Anu Sebastian <anu@...>
Date: 2009-08-04T17:50:56+09:00
Subject: Re: Spreadsheet::ParseExcel

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

        }

But it prints 'nil'. I have data in my excel file.

Could you please help me?

Thanks,
Anu

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 <hwyss@ywesee.com>
> 
> Enjoy, and thanks for your feedback!
> Hannes

-- 
Posted via http://www.ruby-forum.com/.