Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses
 
PerlMonks  

Re: Troubles transposing a range in Excel with Win32::OLE

by c-era (Curate)
on Jan 10, 2002 at 01:34 UTC ( #137580=note: print w/ replies, xml ) Need Help??


in reply to Troubles transposing a range in Excel with Win32::OLE

I tried it on my pc, and got the same result. I'm running win2k, office 2k, and perl 5.6.1. I then tried using VB to write the code, and wasn't able to make the call either. I'm guessing something isn't right with the ole object. You can always transpose the vaules yourself. If you use my $range_values = $sheet->Range("A1:C5")->{'Value'}; range_values will be a reference to a 2d array. Simply flip the array and write the results with $sheet->Range("D1:F5")->{'Value'} = $range_values; Let me know if you find anything else out.


Comment on Re: Troubles transposing a range in Excel with Win32::OLE
Select or Download Code

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others romping around the Monastery: (4)
As of 2014-07-31 02:14 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    My favorite superfluous repetitious redundant duplicative phrase is:









    Results (244 votes), past polls