PowerShell无法打开Excel数据表报错求助（附代码与错误信息）

环境配置 #

• PowerShell版本：5.1.19041.2364
• Office版本：Office Professional 2019 Excel

脚本代码 #

# Create a new Excel COM object
$excel = New-Object -ComObject Excel.Application
  
# Open the specified Excel file
$workbook = $excel.Workbooks.Open("F:\Tabele.xlsx")

# Select the sheet containing the data
$worksheet = $workbook.Worksheets.Item("LO1")

# Read the data from the specified range
$data = $worksheet.Range("B9:E24").Value

# Output the data to the console
$data

# Close the workbook and quit Excel
$workbook.Close($false)
$excel.Quit()

执行错误信息 #

PS F:> ."test excel.ps1"
You cannot call a method on a null-valued expression.
At F:\test excel.ps1:5 char:1
- $workbook = $excel.Workbooks.Open("F:\Tabele.xlsx")
- 
  + CategoryInfo          : InvalidOperation: (:) [], RuntimeException
  + FullyQualifiedErrorId : InvokeMethodOnNull

You cannot call a method on a null-valued expression.
At F:\test excel.ps1:8 char:1
- $worksheet = $workbook.Worksheets.Item("LO1")
- 
  + CategoryInfo          : InvalidOperation: (:) [], RuntimeException
  + FullyQualifiedErrorId : InvokeMethodOnNull

You cannot call a method on a null-valued expression.
At F:\test excel.ps1:11 char:1
- $data = $worksheet.Range("B9:E24").Value
- 
  + CategoryInfo          : InvalidOperation: (:) [], RuntimeException
  + FullyQualifiedErrorId : InvokeMethodOnNull

You cannot call a method on a null-valued expression.
At F:\test excel.ps1:17 char:1
- $workbook.Close($false)
- 
  + CategoryInfo          : InvalidOperation: (:) [], RuntimeException
  + FullyQualifiedErrorId : InvokeMethodOnNull

Exception calling "Quit" with "0" argument(s): "Unable to cast COM object of type
'Microsoft.Office.Interop.Excel.ApplicationClass' to interface type 'Microsoft.Office.Interop.Excel._Application'.
This operation failed because the QueryInterface call on the COM component for the interface with IID
'{000208D5-0000-0000-C000-000000000046}' failed due to the following error: Error loading type library/DLL. (Exception
from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY))."
At F:\test excel.ps1:18 char:1
- $excel.Quit()
- 
  + CategoryInfo          : NotSpecified: (:) [], MethodInvocationException
  + FullyQualifiedErrorId : InvalidCastException

已尝试操作 #

• 确认Excel已正常安装
• 验证文件路径正确，且尝试更换路径分隔符（\与/）
• 确认$excel对象非空（添加存在性检查）
• 以管理员身份运行脚本

解决方法 #

1. 检查PowerShell与Office的位数匹配情况 #

Office默认安装为32位，而Windows 10/11默认的PowerShell是64位，位数不匹配会导致COM对象调用异常：

• 若安装的是32位Office，需运行32位PowerShell（路径：C:\Windows\SysWOW64\WindowsPowerShell\v1.0\powershell.exe）
• 若安装的是64位Office，直接使用默认的64位PowerShell即可

2. 重新注册Excel的COM组件 #

以管理员身份打开对应位数的PowerShell，执行以下命令：

# 32位Office
regsvr32.exe "C:\Program Files (x86)\Microsoft Office\Root\Office16\EXCEL.EXE"

# 64位Office
regsvr32.exe "C:\Program Files\Microsoft Office\Root\Office16\EXCEL.EXE"

执行完成后重启PowerShell再测试脚本。

3. 修复Office安装 #

打开控制面板→程序和功能→找到Office Professional 2019→右键选择更改→先尝试快速修复（无效则选择联机修复），修复完成后重启电脑测试。

4. 替代方案：使用ImportExcel模块（推荐） #

COM对象操作Excel易出现权限、位数、残留进程等问题，可使用PowerShell的ImportExcel模块，无需依赖Excel COM对象：

1. 安装模块：

Install-Module -Name ImportExcel -Scope CurrentUser -Force

2. 替换脚本为：

# 读取指定工作表和区域的数据
$data = Import-Excel -Path "F:\Tabele.xlsx" -WorksheetName "LO1" -StartRow 9 -EndRow 24 -StartColumn 2 -EndColumn 5

# 输出数据
$data

内容的提问来源于stack exchange，提问作者JohnT