My issue is this, I am writing a program that will read excel spreadsheet files and take specific cells in those spreadsheets and put them in a separate spreadsheet that I am writing in the program. I am using CPAN modules Spreadsheet::Read and Spreadsheet::WriteExcel. However when I run this program I get to the part where I am actually writing the excel output file and I run into this error:
"Can't call method 'write' on an undefined value at bluehillcomp.plx line 94, <STDIN> line 6."
and heres the code at that part:
<# Write 00 temperature data into file:
$read = 4+(($day-1)*58);
$temp = $xls->1{("B", $read)};
$row = $day + 1;
my $worksheet->write($row,$col,$temp); # Line 94 !
$day = $day + 1; >
So I thought this was an issue with me not declaring the variable "$worksheet", but looking at earlier code I think I did declare it:
< my $workbook = ();
my $worksheet = ();
# Create output file with user filename:
if ($outfile ne "d") {
my $workbook = Spreadsheet::WriteExcel->new($outfile);
my $worksheet = $workbook->add_worksheet();
print "What should we label the column containing the data?\n";
my $colname = <STDIN>;
chomp($colname);
$worksheet->write(0,"A",$colname);
} >
Any ideas?
In reply to Issue with Spreadsheet::WriteExcel by mprogan365
| For: | Use: | ||
| & | & | ||
| < | < | ||
| > | > | ||
| [ | [ | ||
| ] | ] |