Re: coding for excel in perl

There are two things you might want to try. One is using 1 and 0 instead of true and false - I'm not sure how Win32::OLE will parse False. The other is that some Excel properties need to be in {braces}. The rules for which need braces and which don't seem to have something to do with the checksum of the property being divisible by Bill Gates's birthday. So I would try (using strict and all the other fruit):

$xl = Win32::OLE->new('Excel.Application');
$xl->{CutCopyMode} = 0;
[download]

But you may need to get rid of the braces - I haven't tested this.

Regards,

John Davies

Comment on Re: coding for excel in perl Download Code

Replies are listed 'Best First'.
Re^2: coding for excel in perl by ruxer (Acolyte) on Dec 27, 2009 at 17:52 UTC
Thank you, John. You are so right! I had done some trial and error and came up with that same line. Came online to let everyone know. It works perfectly. Thank you so much for your response. david	[reply]