Generating Excel Pivot Table

MMak12

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

miller

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

MMak12

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

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

MMak12

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

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

mikester0421

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

thilse

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