The series of digits is being read from a cell in excel using the following,


spreadsheetdata[:pinnumber] = row.cells(4,13) ['text']

the cell will contain 5 digits, (pin number)
I need to place the digits into an array to be used later in the script
during pin number validation e.g 'what is the second and third digit of
your  five  digit  pin  number'


On 5/14/07, Charley Baker <[EMAIL PROTECTED]> wrote:

Can you give us an example of some of the data in the cell you're trying
to collect into an array? You should be able to do something like splitting
it into different strings possibly, depends on what you're getting from your
cell.

-Charley

On 5/12/07, Tunde Jinadu <[EMAIL PROTECTED]> wrote:

> Hi,
>
> I'm looking to read the data from a spreadsheet cell into an array, a
> series of five digits.
> I need data in an array to enable me read the values according to a
> random prompt for two of the five digits that will be in the array with
> respect to their positions in the array.
> The problem I have is the data/values captured from the cell are indexed
> as one group, not distinct values... any help will do in achieving indexing
> a number of digits from an individual spreadsheet cell into an array and
> each digit referenced.
> thanks.
>
> --
> The second half of a man's life is made up of nothing but the habits he
> has acquired during the first half.
>   - Fyodor Dostoevsky
> _______________________________________________
> Wtr-general mailing list
> [email protected]
> http://rubyforge.org/mailman/listinfo/wtr-general
>


_______________________________________________
Wtr-general mailing list
[email protected]
http://rubyforge.org/mailman/listinfo/wtr-general




--
Why is it that our memory is good enough to retain the least triviality that
happens to us, and yet not good enough to recollect how often we have told
it to the same person?
 - Francois de La Rochefoucauld
_______________________________________________
Wtr-general mailing list
[email protected]
http://rubyforge.org/mailman/listinfo/wtr-general

Reply via email to