Re^2: How to create pivot tables via perl?

Thanks Martin. I have read your reply on this query before and have also looked into the other links you mentioned. I'm gonna look again and see if there's anything I missed.

Most of my knowledge on this are only based on examples I found on the web. As commented by an Anonymous Monk on "Using Win32::OLE and Excel - Tips and Tricks", I too have yet to stumble upon documentation containing all the valid fields and subfields. An example is how to format all the cells of a column as a Number with 2 decimal places, stuff like that.

To ww, I did try to look for it in "Super Search", but I really haven't found what I am looking for. Just hoping that this time someone can give me an answer. Thanks for the advice nonetheless.

Rafa

Comment on Re^2: How to create pivot tables via perl?

Replies are listed 'Best First'.
Re^3: How to create pivot tables via perl? by Corion (Patriarch) on Feb 01, 2007 at 18:44 UTC
The easy way is, as always with MS Office automation, to record whatever you're doing with the macro recorder and then translate the created VB code to Perl.	[reply]
Re^4: How to create pivot tables via perl? by rafa (Novice) on Feb 01, 2007 at 19:55 UTC
Thanks for your reply. I tried it and I think it would be the easiest way to go. One can easily translate the basic VB code to Perl. Problem will be converting those that are a little complicated. Have you tried using the Perl Dev Kit on this?	[reply]
Re^5: How to create pivot tables via perl? by Corion (Patriarch) on Feb 02, 2007 at 08:26 UTC
Why would I want to try the Perl Dev Kit with this? As you don't show us which parts you have problems translating from VB to Perl it'll be hard for us to help you there. As a point of reference, I found no problems in automating the creation of a pivot table and pivot chart in Excel.	[reply]
Re^3: How to create pivot tables via perl? by marto (Cardinal) on Feb 01, 2007 at 20:32 UTC
In addition to the fantastic advice Corion has provided for you, please check out the resources I link to in Re: Excel VB Controls. If you hit any problems post the code and the monks will do their best to help you. Cheers Martin	[reply]