Formula copy in Win32::OLE

buntoo has asked for the wisdom of the Perl Monks concerning the following question:

Monks, I have the following formula to be copied from (11,2) to (11,13) using Win32::OLE. Please advice how to do it. $worksheet->Cells(11,2)->{Formula} = "=STDEV(B3:B7)"; Also please give help pointers to know more on Perl Excel interface functions using win32::ole Thanks

Comment on Formula copy in Win32::OLE

Replies are listed 'Best First'.
Re: Formula copy in Win32::OLE by Corion (Patriarch) on Sep 12, 2008 at 09:25 UTC
Also see Use The Macro Recorder, Luke (Re: Using Win32::OLE and Excel - Tips and Tricks) for tips on how to automate automating Excel.	[reply]
Re: Formula copy in Win32::OLE by binf-jw (Monk) on Sep 12, 2008 at 11:07 UTC
Best bet is to look at to work out how to do stuff. Excel Object Model Reference Then the CPAN Win32::OLE (Mentioned in first reply) on the syntax of how to call methods and set/get attributes documented in the Excel Object Model Reference	[reply]
Re: Formula copy in Win32::OLE by Narveson (Chaplain) on Sep 12, 2008 at 09:05 UTC
Help pointer: Win32::OLE	[reply]