Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"
 
PerlMonks  

Re: Excel opening problems

by strat (Canon)
on Jun 23, 2007 at 09:13 UTC ( #622966=note: print w/ replies, xml ) Need Help??


in reply to Excel opening problems

I usually use something like the following code to open an excel file:

#! /usr/bin/perl use warnings; use strict; use Win32; use Win32::OLE; # the following two may or may not be needed, depending on # your excel file and your code use Win32::OLE::Const 'Microsoft Excel'; use Win32::OLE::Variant; my $excelFile = shift( @ARGV ); # or whatever defined $excelFile or die "Usage: $0 excelFile\n"; -f $excelFile or die "Error: file '$excelFile' doesn't exist"; # convert to windows-full-path my $fullFilename = Win32::GetFullPath( $excelFile ); # try to re-use running instance of Excel my $excel; eval { $excel = Win32::OLE->GetActiveObject( 'Excel.Application' ) }; if( $@ ) { die "Error: no Excel installed: $@\n"; } # if unless( defined $excel ) { # if not running, start it $excel = Win32::OLE->new( 'Excel.Application', sub { $_[0]->Quit } ) or die "Error: can't start Excel\n"; } # unless # to see what happens; useful for debugging $excel->{Visible} = 1; my $workbook = $excel->Workbooks->Open( $fullFilename ) or die "Error: can't open Workbook '$fullFilename'\n"; ...
(not tested)

Best regards,
perl -e "s>>*F>e=>y)\*martinF)stronat)=>print,print v8.8.8.32.11.32"


Comment on Re: Excel opening problems
Download Code
Re^2: Excel opening problems
by merrymonk (Friar) on Jun 25, 2007 at 09:03 UTC
    Many thanks for the Perl code. I will try this and see if it helps to open and/or find the problem

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others contemplating the Monastery: (8)
As of 2015-07-06 10:09 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (71 votes), past polls