如何在PowerShell中获取打开的Excel工作簿列表

$excel = New-Object -ComObject Excel.Application

$workbooks = $excel.Workbooks
$workbookCount = $workbooks.Count

for ($i = 1; $i -le $workbookCount; $i++) {
    $workbook = $workbooks.Item($i)
    # 在这里可以获取工作簿的相关信息，如名称、路径等
    $workbookName = $workbook.Name
    $workbookPath = $workbook.Path
    # 输出工作簿信息
    Write-Host "工作簿名称: $workbookName"
    Write-Host "工作簿路径: $workbookPath"
}

# 关闭工作簿
$workbooks.Close()

# 退出Excel应用程序
$excel.Quit()

# 释放COM对象
[System.Runtime.Interopservices.Marshal]::ReleaseComObject($workbooks)
[System.Runtime.Interopservices.Marshal]::ReleaseComObject($excel)