Re: Trying to modify multisheets using Spreadsheet::ParseExcel::SaveParser


No such thing as a small change
	PerlMonks

Re: Trying to modify multisheets using Spreadsheet::ParseExcel::SaveParser

by poj (Abbot)

on Aug 12, 2015 at 08:05 UTC ( [id://1138283]=note: print w/replies, xml )

Need Help??

in reply to Trying to modify multisheets using Spreadsheet::ParseExcel::SaveParser

Check the names of your worksheets, maybe you have leading spaces

#!usr/bin/perl
use strict;
use warnings;
use Spreadsheet::ParseExcel::SaveParser;

my $parser = Spreadsheet::ParseExcel::SaveParser->new();
my $xls = 'B_MUM_dashboard_month_latency_corrected_FDB.XLS';
my $wb = $parser->Parse($xls);
for ($wb->worksheets){
  print "'$_->{Name}'\n";
}
[download]

poj