如何在powershell中选择Excel范围

$excel = New-Object -ComObject Excel.Application

$workbook = $excel.Workbooks.Open("C:\path\to\excel_file.xlsx")
$worksheet = $workbook.Worksheets.Item(1)  # 选择第一个工作表

$range = $worksheet.Range("A1:B10")  # 选择A1到B10的范围

# 读取范围内的数据
$data = $range.Value

# 写入数据到范围内
$range.Value = $data

$workbook.Close($false)  # 关闭文件但不保存更改
$excel.Quit()  # 退出Excel应用程序
[System.Runtime.Interopservices.Marshal]::ReleaseComObject($range) | Out-Null
[System.Runtime.Interopservices.Marshal]::ReleaseComObject($worksheet) | Out-Null
[System.Runtime.Interopservices.Marshal]::ReleaseComObject($workbook) | Out-Null
[System.Runtime.Interopservices.Marshal]::ReleaseComObject($excel) | Out-Null