From: Sandro Paganotti <sandro.paganotti@...>
Date: 2008-08-26T16:47:52+09:00
Subject: Re: parceexcel and fields in xls file

------=_Part_5110_16273823.1219737136093
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

I think it could be some sort of strange character encoding, try this:

utf8(row.at(0))

where utf is defined as follow:

def utf8(val)
      val.to_s('Latin1').unpack("C*").pack("U*")
end

this last function depends heavily on which encoding are you using... try
some different
encoding strings to find the one that fix your problem.

Sandro


On Tue, Aug 26, 2008 at 7:02 AM, Vidya Ramachandren <
vidya_ramachandren@yahoo.co.in> wrote:

> I am having a problem in reading the columns from an xls file.
>
> Following is the code:
> workbook = Spreadsheet::ParseExcel.parse(params[:dump][:file])
>        worksheet = workbook.worksheet(0)
>
>        skip=0
>        worksheet.each(skip) { |row|
>
>        puts row.at(0)
>
>        }
>
> I am storing "Customer" in the first row first column. When I print, it
> is received as C[]u[]s[]t[]o[]m[]e[]r[] (I mean a box in between each
> letter).
> Am i missing out anything in the code?
>
> Please help.
>
> Thanks in advance.
> --
> Posted via http://www.ruby-forum.com/.
>
>


-- 
Go outside! The graphics are amazing!

------=_Part_5110_16273823.1219737136093--