in reply to Excel column into an array
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 |