Copy Paste Excel by Powershell

  • I am having the Excel File 1 and Excel File 2 where the contents in the excel file 2 needs to be copied to excel file 1.Whether the copying can be done through the Sheet name ?

    I am having this powershell script to copy but the copying is happening but it should happen according to the sheet present.Can any one help on the same ?

    $excel=new-object -comobject excel.application;
    $SourceRange.copy() | out-null;
    $SourceWorkBook.close($false) # close source workbook w/o saving
    $TargetWorkBook.close($true) # close and save destination workbook

  • Can anyone help on the same if not busy ?

  • @lakshmana sorry am very busy....

Log in to reply