in reply to how to enter formula in excel

I've never used Win32::OLE, but just from looking at what you've posted I'd guess that you need to properly escape the quotes in your string. Try this: 
$Sheet->Cells(3,1)->{Value} = "=IF(A1=B1,\"PASS\",\"FAIL\")";

[download]
Cheers,
Darren :)

Replies are listed 'Best First'.
Re^2: how to enter formula in excel
by ayrnieu (Beadle) on Feb 14, 2006 at 09:27 UTC

    Or rather:

    $Sheet->Cells(3,1)->{Value} = q/=IF(A1=B1,"PASS","FAIL")/;

    Please don't ever actually write a string in Perl with escaped embedded quotes.

[reply]
[d/l]

In Section Seekers of Perl Wisdom