Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine
 
PerlMonks  

Re^2: Query Data for Data-Pivot

by cocl04 (Sexton)
on Nov 20, 2009 at 14:49 UTC ( [id://808452]=note: print w/replies, xml ) Need Help??


in reply to Re: Query Data for Data-Pivot
in thread Query Data for Data-Pivot

I appreciate you help. I was able to get it to work. I was also able to create an array using the following:

foreach $i(0..$#{$a_row}) { foreach $j (0..$#{$a_row->[$i]} ) { $array[$i][$j] = $a_row->[$i][$j]; } } print Dumper(\@array);

I don't like the Data-Pivot module. It is not pivoting my dates to be the column headers like I want. So, I am going to try Win32::OLE. I just don't know if I can feed the data to a spreadsheet without specifing the range of the spreadsheet. With Spreadsheet::WriteExcel it loads the data to the end of file. All of the examples of Win32::OLE are asking for a range. I am trying to load data from a query where I don't know the range. Anyway, I appreciate you help.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://808452]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others having an uproarious good time at the Monastery: (2)
As of 2024-04-25 03:28 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found