$row = 0;



#=================================



#Opens Excel to work on 
use Win32::OLE qw(in with);
use Win32::OLE::Const 'Microsoft Excel';
use Win32::OLE::Variant;
use Win32::OLE::NLS qw(:LOCALE :DATE);

$Win32::OLE::Warn = 3; # Die on Errors.
Win32::OLE->new('Excel.Application')->{DisplayAlerts} = "False";


# OPENING INPUT FILE
#============================    
my $Excel = Win32::OLE->new('Excel.Application', sub {$_[0]->Quit;})  
+|| die "Oops, cannot start Excel");      #OPen Excel file 
my $excelfile = 'c:\\test\\inputsheet.xls';       #File that is opened
+ to be edited
my $Book = $Excel->Workbooks->Open($excelfile);                       
+   
        

my $Sheet = $Book->Worksheets("Example");        #Open sheet in docume
+nt
$Sheet->Activate();    
#==========================================



#GET INPUT DATA FROM INPUTSHEET.XLS
#============================    
$Sheet->Range("b$col ")->Select();


#==========================================
$rowi = 1; flag = 0; $refcode = "  ";
while($sheetip->Range("b$row")->has_data)
#====
{
    my $inputcode = $sheetip->range("b$rowi");

    maxrow = $sheetop->range();
    $rowop =1
    for($rowop = 1; $rowop<maxrow;$rowop++)
    $sheetop->range("b$row");
  
if (strcompare($inputcode,$currentcode)

{
  $currentrowop = $rowop
  $rowop = $maxrow + 1;
}
 else
 $rowop++;
}
if(flag = 0)
{
 $refcode = $currentcode
}
else
flag = 1;
$sheetop->range(====


if($currentcode = $retcode)
$ sheetop->range ("$currentrowop")->{value}=$defect

else
$sheetop->range ("$currentrowop)->{value}=$defect;
$rowi++;
}


# OPENING OUTPUT FILE
#============================        
my $Excel = Win32::OLE->new('Excel.Application', sub {$_[0]->Quit;})  
+|| die "Oops, cannot start Excel");      #OPen Excel file 
my $excelfile1 = 'c:\\test\\testmetrics.xls';       #File that is open
+ed to be edited
my $Book1 = $Excel->Workbooks->Open($excelfile1);                     
+     
        

my $Sheetop = $Book->Worksheets("TQ-CETK");        #Open sheet in docu
+ment
$Sheetop->Activate();    
#==========================================

















$Book->Save();        #Saves updated file
$Excel->ActiveWorkbook->Close(0);#Closes file    
$Excel->Quit();            #Stops excel from running 
undef $Excel;            #Cleanup
Win32::OLE->new("Excel.Application")->{DisplayAlerts} = "True";# Turn 
+them back on (just in case)

    #  ................................ Close the input & output chann
+els ..........
#    close (LOGFILE) ;
#    close (OUTFILE) ;

[download]

20050119 Janitored by Corion: Added code tags, as per Writeup Formatting Tips.

In reply to Re^2: help needed urgent by ash0404
in thread Copy to Excel spreadsheet by ash0404

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.