> I'm having a horrendous time trying to write to cells in my spreadsheet
that
> are specified by variables.
>
> I'm trying to write like this:
>
> $active_sheet -> Cells ($set, ($loop + 24)) -> {Value} = ("$loop");
> $active_sheet -> Cells (($set + 1), ($loop + 24)) -> {Value} = ("some
> text");
>
The Value property needs to be quoted. Also, why do you have the right-side
expression in parens in each case? Here is a known-good call to the cells
function:
$resultsheet->Cells($row,$col)->{'Value'} = $data;
$data could be replaced with a string literal, as in your example.
Steve
_______________________________________________
Perl-Win32-Users mailing list
[EMAIL PROTECTED]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
