472,368 Members | 2,422 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,368 software developers and data experts.

Generating Excel Pivot Table

5
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
7 8213
miller
1,089 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
MMak12
5
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
1,089 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
MMak12
5
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
1,089 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
thilse
1
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

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

Similar topics

1
by: Bajal Mohamed via SQLMonster.com | last post by:
I am facing problem like; We generate reports thru Excel Pivot table. The data is coming from sales cube. Let?s assume that there are 2 products A and B. The user wants to filter for each...
0
by: Bruce | last post by:
Is there a way to create the "old style" Excel pivot table form in MSAccess 2002/2003? I've seen several postings "dancing around this issue", but no definite answer. Is there a way to clone the...
1
by: matthew kramer | last post by:
Hi, I'm using the reverse pivot technique on an excel spreadsheet to create a list dataset from which I can make a pivot table in excell. The only problem is that because there are so many...
0
by: Alexander Mandl | last post by:
Hello I have a pivot table in an Access form and open the pivot Table (Excel OLE Object) from within Access. In the Excel Table is a macro (signed) (in teh open event) running when opening the...
0
by: Tim_k | last post by:
Does anyone have an example of how to export a datagrid to an Excel pivot table? The code below exports the grid contents to Excel using the Response object. I'd like to expand it to show the...
1
by: NS3687 | last post by:
Hi, Is there a way to simulate the Excel Pivot table flexibility in MS Access? I mean, once I get the needed data into one table, instead of writing one query to for an analysis point, I'd lke to...
2
by: LittlePhil via AccessMonster.com | last post by:
Someone please help before i start to cry. I'm trying to export from Access to Excel, then create a new excel sheet with a pivot table to display the data held in columns A:P. I get the error...
2
by: Gary Dunne | last post by:
Hi All, I'm struggling to find the correct syntax for creating a Pivot table in an excel file via VB . Net 2005 The Excel help file is not particularly helpful where parameters are concerned...
0
by: dmitry chov | last post by:
using Excel = Microsoft.Office.Interop.Excel; ... Excel.Application xlApp = new Excel.Application(); Excel.Worksheet xlWorkBook = xlApp.Workbooks.Open(templateFileReport); Excel.Worksheet...
2
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and efficiency. While initially associated with cryptocurrencies...
0
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was proposed, which integrated multiple engines and...
0
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and credentials and received a successful connection...
0
hi
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific technical details, Gmail likely implements measures...
1
by: Matthew3360 | last post by:
Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web server and have made sure to enable curl. I get a...
0
BLUEPANDA
by: BLUEPANDA | last post by:
At BluePanda Dev, we're passionate about building high-quality software and sharing our knowledge with the community. That's why we've created a SaaS starter kit that's not only easy to use but also...
0
by: Rahul1995seven | last post by:
Introduction: In the realm of programming languages, Python has emerged as a powerhouse. With its simplicity, versatility, and robustness, Python has gained popularity among beginners and experts...
2
by: Ricardo de Mila | last post by:
Dear people, good afternoon... I have a form in msAccess with lots of controls and a specific routine must be triggered if the mouse_down event happens in any control. Than I need to discover what...
1
by: ezappsrUS | last post by:
Hi, I wonder if someone knows where I am going wrong below. I have a continuous form and two labels where only one would be visible depending on the checkbox being checked or not. Below is the...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.