From: Love U Ruby <lists@...>
Date: 2013-02-13T16:05:44+09:00
Subject: Re: Issue with Excel column values read.

David Mullet wrote in post #1096585:

Wowwww... Really nice, I never have thought about the things,you pointed 
out here. Definitely I will give it a try.

> Use the Text property of a cell, rather than the Value property.
>
> For example, change...
>
>     wbs.cells(rows,8).value
>
> ...to...
>
>     wbs.cells(rows,8).Text
>
> The Value property returns the underlying value as stored by Excel (for
> numbers this is a decimal).
>
> The Text property returns the value as it is displayed.
>
> David
>
> http://rubyonwindows.blogspot.com/search/label/excel

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