Don't ask to ask, just ask | |
PerlMonks |
Re: Creating Pivot tables from Perlby marto (Cardinal) |
on Nov 08, 2005 at 20:11 UTC ( [id://506869]=note: print w/replies, xml ) | Need Help?? |
narashima, Not a complete Perl soultion but.. Could you not have your pivot table in an Excel sheet**, then append the output from your Perl script to the file? **If you pre define a piviot table you should be able to update it when the excel file is next opened using a VBS (within the Excel file, NOT your Perl script) like:
Please excuse the fact that this is not Perl code :( Are you currently able to write data to an Excel file? Cpan has many modules regards Excel writting. Hope this helps. Martin
In Section
Seekers of Perl Wisdom
|
|