in reply to Excel column into an array

blackadder,
I understand what it is like to be in a hurry, but taking two minutes on CPAN would have turned up Spreadsheet::ParseExcel. TFM is quite friendly.

Cheers - L~R

Update: Ok, since I read TFM just to be sure it was possible, here is 1 way to do it:
#!/usr/bin/perl use strict; use warnings; use Spreadsheet::ParseExcel; my $xls = Spreadsheet::ParseExcel->new(); my $xls_book = $xls->Parse( 'example.xls' ); my $xls_worksheet = $xls_book->{Worksheet}[0]; # B1 - B3 my @vals = map { $xls_worksheet->Cell( $_ , 1 )->Value } 0 .. 2; print "$_\n" for @vals;

Replies are listed 'Best First'.
Re: Re: Excel column into an array
by Sameet (Beadle) on May 02, 2004 at 19:37 UTC
    Dear Limbic-Region,
    I wanted to do exactly the same. I just floated the query, and i remembered something like this had happened in the recent past. Thank you very much for the answer.
    regards
    sameet