sql-server - Excel.Application 不能使用 SQL 作业在 PowerShell 中运行，但可以从命令行运行

Question

我正在使用 PowerShell 来解锁锁定的 Excel 电子表格。当我从作业运行脚本时(使用我自己作为代理用户)，脚本的 Excel 部分不会运行。但是，当我直接从命令行执行相同的脚本时，它工作正常。我的代码是:

#Unlock Attatchment 
$x = New-Object -comObject Excel.Application
$x.visible = $false
$x.DisplayAlerts = $False
$workbook = $x.Workbooks.Open($spreadsheetFileName,1,$false,
                              5,$spreadsheetPassword,$spreadsheetPassword)
$workbook.SaveAs($tmpFileName,1,$null,$null,$null,$null,$null,
                $x.XlSaveConflictResolution.xlLocalSessionChanges,
                $null,$null,$null,$null)
$x.Workbooks.Close()
$x.Quit()

编辑:我添加了日志记录。以下是日志结果:

Exception calling "Open" with "6" argument(s): Microsoft Office Excel cannot access the file "_____"
There are several possible reasons:
• The file name or path does not exist.
• The file is being used by another program.
• The workbook you are trying to save has the same name as a currently open workbook.

Answer 1

好的!原来的解决方案如下(以防出现在搜索结果中):

添加目录:C:\Temp

添加目录:C:\Windows\SysWOW64\config\systemprofile\Desktop

那应该可以解决问题。