I am attempting to write a simple formula using Spreadsheet:WriteExcel.
Here is the line:
$colletter = 'B';
my $formula = "=sum($colletter"."3:"."$colletter$rowcnt)";
$ws1->write_formula($rowcnt,$colcnt,$formula,$workbook->add_format(size => 10,
bold
=> 0,
italic => 0,
underline=>0,
text_wrap=>1,
align=> 'center',
-bg_color => 9,
-border => 1));
Tthe error I get back is:
Couldn't parse formula: =sum(b3:b163) at program.pl line 669
Any ideas?
Ken Barker
IT Lead
Americall Group, Inc
314-213-7927
[EMAIL PROTECTED]
_______________________________________________
ActivePerl mailing list
ActivePerl@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
