Beefy Boxes and Bandwidth Generously Provided by pair Networks
laziness, impatience, and hubris
 
PerlMonks  

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

by jagdish.eashwar (Novice)
on Dec 07, 2008 at 06:07 UTC ( #728660=note: print w/replies, xml ) Need Help??


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

Is it possible to read an excel file without opening it? I have written a small script for reading several excel files in turn. Each of these excel files have a workbook_open macro which puts out a message. Because of this, running the script is very tedious. I have to keep pressing the enter key or click the ok button to get the msgbox out of the way whenever an excel file is opened by the script.
  • Comment on Re: Using Win32::OLE and Excel - Tips and Tricks

Replies are listed 'Best First'.
Re^2: Using Win32::OLE and Excel - Tips and Tricks
by roboticus (Chancellor) on Jan 07, 2010 at 13:52 UTC

    cacharbe:

    About as easily as you can read a book without opening it... ;^)

    ...roboticus

Re^2: Using Win32::OLE and Excel - Tips and Tricks
by cacharbe (Curate) on Jul 29, 2009 at 22:28 UTC
    It would completely depend on the format of the file, but in terms of OLE, no. This methodolgy uses the Excel application as the vehicle to read the files, and it requires the doc to be opened in the engine.

    C-.

    ---
    Flex the Geek

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://728660]
help
Chatterbox?
[Lady_Aleena]: Discipulus, then that is a problem. I wanted to find total seconds of my entire .mp3 collection to do some math on it to see how many days of continuous music i have.
[LanX]: darn. .. I wanted to see Marine and Melonchon go to next round, just for fun xD
[Discipulus]: LA use Perl: traversing a dir tree is simple; foreach file mp3 $sec+= use Mp3::Info
[Lady_Aleena]: Discipulus, I was able to get the sum of the seconds on the command line using awk. Then I ran the result through a perl script and got the result. It came bach with 4 days, 9 hours, 56 minutes, 43 seconds.
[Lady_Aleena]: s/bach/back/;
[Discipulus]: gired anyway is the intermediate state between hired and fired (and vice versa;)
[Lady_Aleena]: Discipuluis, I don't know if I want to fight with File::Find. File::Find and I are not friends.
[Discipulus]: 4 day Bach is too muche even for me
[Discipulus]: LA you know who is paco?
[Lady_Aleena]: Disc, nope.

How do I use this? | Other CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (9)
As of 2017-04-23 20:32 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    I'm a fool:











    Results (432 votes). Check out past polls.