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

Re: Using Win32::OLE and Excel - Tips and Tricks

by kersht (Initiate)
on Jan 15, 2003 at 19:16 UTC ( #227202=note: print w/replies, xml ) Need Help??


in reply to Using Win32::OLE and Excel - Tips and Tricks

Great "tutorial" on Excel with Win32::OLE! I am trying to extract data from one Excel file, and input that data into another Excel file. The problem comes when trying to have two open Excel files, and make the data transfer happen in the same block. I was thinking of creating a subroutine for each function -- one for extracting the data and sticking it in an array, and one for inputing the data from the array into the other spreadsheet ... However, before I go through the effort, I thought I'd ask the Pro's! Any good guidance or experience in this or a similar Excel problems? Thanks ...
  • Comment on Re: Using Win32::OLE and Excel - Tips and Tricks

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://227202]
help
Chatterbox?
[Discipulus]: next time you can add `SARGV-1` and if still not impressed pass a 'rm -f..' as last arg
[Eily]: :)
[Eily]: or I might be tempted to send him an Acme::EyeDropsed file next time
[Eily]: Acme::Bleach is tempting, but it will look like I'm just using the one module that does precisely exactly what he wants

How do I use this? | Other CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (8)
As of 2017-04-26 15:14 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    I'm a fool:











    Results (483 votes). Check out past polls.