How about pin_array = spreadsheetdata[:pinnumber].to_a
-Charley On 5/14/07, Tunde Jinadu <[EMAIL PROTECTED]> wrote:
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
_______________________________________________ Wtr-general mailing list [email protected] http://rubyforge.org/mailman/listinfo/wtr-general
