When I started playing around a bit with Excel and Perl, Excel's macro recorder helped me quite a lot finding out which methods and properties are available for a certain object.

At first, I told excel to record everything I do from now on as a macro, and then manually did the changes I was interested in finding out how it worked, e.g. formatting a certain cell. Then I stopped the recording, and threw a look into the VbScriptcode generated by the macrorecorder, and tried to translate it somehow to perl. The only problems I had were so called standard properties that didn't work with perl (I just had to find out excactly which property is used), and constants that were not known in Win32::OLE. But by trying to output the constant's value in Excel, I usually found an integer I could use.

Best regards,
perl -le "s==*F=e=>y~\*martinF~stronat~=>s~[^\w]~~g=>chop,print"