Re: Using Win32::OLE and Excel

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	[reply]
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	[reply]