在powershell中的工作簿之间复制和粘贴excel范围

$excel = New-Object -ComObject Excel.Application
$sourceWorkbook = $excel.Workbooks.Open("C:\path\to\source\workbook.xlsx")
$targetWorkbook = $excel.Workbooks.Open("C:\path\to\target\workbook.xlsx")

$sourceWorksheet = $sourceWorkbook.Worksheets.Item(1) # 选择第一个工作表
$sourceRange = $sourceWorksheet.Range("A1:B10") # 选择范围为A1到B10的单元格

$targetWorksheet = $targetWorkbook.Worksheets.Item(1) # 选择第一个工作表
$targetRange = $targetWorksheet.Range("C1") # 选择C1单元格作为粘贴位置

$sourceRange.Copy($targetRange)

$excel.Quit()
[System.Runtime.Interopservices.Marshal]::ReleaseComObject($sourceRange) | Out-Null
[System.Runtime.Interopservices.Marshal]::ReleaseComObject($targetRange) | Out-Null
[System.Runtime.Interopservices.Marshal]::ReleaseComObject($sourceWorksheet) | Out-Null
[System.Runtime.Interopservices.Marshal]::ReleaseComObject($targetWorksheet) | Out-Null
[System.Runtime.Interopservices.Marshal]::ReleaseComObject($sourceWorkbook) | Out-Null
[System.Runtime.Interopservices.Marshal]::ReleaseComObject($targetWorkbook) | Out-Null
[System.Runtime.Interopservices.Marshal]::ReleaseComObject($excel) | Out-Null