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.

[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.

[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

[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.

[MMak12]

Hi Miller,


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


Thanks

[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.

[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.

[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.