I am trying to copy content of one excel sheet to another using Win32::OLE.
For the destination file i am able to select the sheet using hte following command
my $Dest_Sheet=$De st_Book->Worksheets(She et_name)
But for the source file when i tried the same i am getting errors. So i am forced to give the sheet No.
Code:
my $Source_Sheet = $Source_Book->Worksheets(1)
Is there a solution for the same.
...