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

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.

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

Replies are listed 'Best First'.
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]