Hi, I would like to ask for help regarding openning the excel file. There seems to be errror that i could not debug it. It can sometimes run succesfull and sometimes show error during openninng the sheet Below is the code that i have written: 
use strict;
use Win32::OLE qw(in with);
use Win32::OLE::Const;
use Win32::OLE::Const 'Microsoft Excel';
$Win32::OLE::Warn = 3;        # die on errors...

my $filename = 'X:\KFD_Plot_Data.xls';
my $filename1 = 'X:\KFD_Raw_Data.csv';
my $filter = 'GIF';           # can be GIF, JPG, JPEG or PNG
my $count = 0;

my $Excel = Win32::OLE->GetActiveObject('Excel.Application') 
    || Win32::OLE->new('Excel.Application', 'Quit');  # use the Excel 
+application if it's open, otherwise open new
#my $Excel = Win32::OLE->new('Excel.Application', 'Quit');  # use the 
+Excel application if it's open, otherwise open new
my $Book1 = $Excel->Workbooks->Open( $filename1 );      # open the fil
+e
my $Book = $Excel->Workbooks->Open( $filename );      # open the file
#$Book1->Close;
foreach my $Sheet (in $Book->Sheets) {                # loop through a
+ll sheets
    print "Start $Sheet \n";
    foreach my $ChartObj (in $Sheet->ChartObjects) {  # loop through a
+ll chartobjects in the sheet
        my $savename = "$filename." . $count++ . ".$filter";
       $ChartObj->Chart->Export({
            FileName    => $savename,
            FilterName  => $filter,
            Interactive => 0});
         print "Done Saving $savename \n";
    }
}
#my $Sheet1 = $Book->Sheets(3);
#my $ChartObj = $Sheet1->ChartObjects;
#my $savename1 = "Yield". ".$filter";
#        $ChartObj->Chart->Export({
#        FileName   => $savename1,
#        FilterName => $filter});

#$Book->{Saved} = 1;
$Book->SaveAs( 'KTF_unused.xls' );
$Book->Close;
#$Book1->Close;
#$Excel->Quit();

[download]
Hope that you can help me. Thanks in advance.

2006-02-09 Retitled by planetscape, as per Monastery guidelines
Original title: 'Error in the code'

In reply to Problem opening Excel file using Win32::OLE by johntio

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.