How to interact with com object via Powershell with Adaxes?

Question

I have to generate an Excel sheet populated with some users informations. It works on the server itself, but not when i run it via Custom commands.

There is the code that need to be executed to launch Excel :

$excel = New-Object -ComObject excel.application -ErrorAction STOP $excel.visible = $false $workbook = $excel.Workbooks.Open($FilePath)

This should open my excel workbook. Although it does'nt open and throws an error :

How to interact with com objects on Adaxes?

Answer 1

Hello,

Please, make sure that Excel is installed on the computer where Adaxes service runs. For an example of the script that creates and emails a report in Excel file, please, have a look at Script 1: Report in Excel section of the following repository article: https://www.adaxes.com/script-repository/computers-with-bitlocker-installed-or-not-installed-s496.htm. Additionally, please, make sure that you selected the PowerShell script type in the configuration of the Run a program or PowerShell script action and pasted the script into the corresponding field.

Comments

Hi, thanks for your quick reply !

I will check this article.

Excel is already installed and i can run my script via the Powershell command line from Adaxes server.

I tried as script or program run, but i have the same error.