#!/usr/bin/perl -w

use strict;
use warnings;
use Spreadsheet::ParseExcel;

my $file = "test.xls";

use vars qw($user_name $user_number $identification);

my $workbook = Spreadsheet::ParseExcel::Workbook->Parse($file)or die "
+Unable to open $file\n";

foreach my $page (@{$workbook->{Worksheet}}) {
print "Page $page\n";

    if ((defined $page->{MinCol}) && (defined $page->{MaxCol})) {
        foreach my $col ($page->{MinCol} .. $page->{MaxCol}) {
            if ($page->{Cells}[0][$col]->{Val} eq "User Name") {
                $user_name = $col;
                print "$user_name\n";
            }

            if ($page->{Cells}[0][$col]->{Val} eq "User Number") {
                $user_number = $col;
                print "$user_number\n";
            }

            if ($page->{Cells}[0][$col]->{Val} eq "Identification") {
                $identification = $col;
                print "$identification\n";
            }

        }
    }
    if ((defined $page->{MinRow}) && (defined $page->{MaxRow})) {
        foreach my $row ($page->{MinRow}+1 .. $page->{MaxRow}) {

            my $got_user_name = $page->{Cells}[$row][$user_name]->{Val
+};
            my $got_user_number = $page->{Cells}[$row][$user_number]->
+{Val};
            my $got_identification = $page->{Cells}[$row][$identificat
+ion]->{Val};

            print "\n This will be inserted into the database: $got_us
+er_name\n$got_user_number\n$got_identification\n";

        }
    }
}

exit;
[download]

That is a very poor example. Use the example in the Spreadsheet::ParseExcel docs as a starting point instead.

--
John.

Other than this line print "Page $page\n";, there is no need for it, why is this a "poor example"?