467,074 Members | 933 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,074 developers. It's quick & easy.

Generating Excel Pivot Table

I am trying to generate pivot table in excel using perl which brings data from MSAccess .If some body has done this before can you please help me.
Feb 17 '07 #1
  • viewed: 7304
Share:
7 Replies
miller
Expert 1GB
I am trying to generate pivot table in excel using perl which brings data from MSAccess .If some body has done this before can you please help me.
I have no idea how to do this. I can only point you to the CPAN modules for parsing and writing excel spreadsheets: Spreadsheet::ParseExcel and Spreadsheet::WriteExcel. There is rather extensive documentation available for both, and they also include sample scripts within the package tars.
Feb 19 '07 #2
Hi Miller,


Can you tell where is the documentation, I will look into it so that if i am lucky enough to get some info.


Thanks
Feb 19 '07 #3
miller
Expert 1GB
cpan Spreadsheet::ParseExcel
cpan Spreadsheet::WriteExcel

I have no experience working with Pivot Tables, and searching the documentation does not appear to even include the word "pivot". But maybe you'll get lucky or at least find a potential alternative.
Feb 19 '07 #4
Hi Miller,


Thanks for the documentation i have solved it and i am successful in generating the pivot table.


Thanks
Feb 21 '07 #5
miller
Expert 1GB
Hi Miller,

Thanks for the documentation i have solved it and i am successful in generating the pivot table.

Thanks
That's fantastic. Great job.
Feb 21 '07 #6
Was wondering if anyone could actually post the procedure to create a pivot table in perl. I would like the pivot table to reside in a sheet of the excel file and be based on data residing in other sheets of the file. Any help is greatly appreciated.
Apr 3 '07 #7
Hi Mmak12,
Could you share the snippet or share with us how did you achieve, generate a pivot table in excel using Perl, which I'm trying to do. but not getting proper direction on this.

Thank you so much for your help.
Nov 25 '20 #8

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Bajal Mohamed via SQLMonster.com | last post: by
1 post views Thread by matthew kramer | last post: by
reply views Thread by Tim_k | last post: by
2 posts views Thread by LittlePhil via AccessMonster.com | last post: by
2 posts views Thread by Gary Dunne | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.