&extract_data();
sub extract_data()
{
my $parsedata = Spreadsheet::ParseExcel->new();
my $workbook_data = $parsedata->parse('test.xls');
for my $worksheet1 ( $workbook_data->worksheet(0) )
{
for my $col ($col_min .. $col_max)
{
my $cell = $worksheet1->get_cell( 0, $col );
if($p_name eq $cell)
{
print("Done");
}
}
}
}
####
Can't call method "worksheet" on an undefined value at D:\Perl\Xls_handling.pl line 110, line 6.
####
Can't call method "worksheet" on an undefined value at D:\Perl\Xls_handling.pl line 110, line 6.