Access Microsoft Excel from Alteryx Gallery

Question

Hi

I am using a run command tool to run a PowerShell script. This script opens an excel created by Alteryx and Refresh its excel formulas in different tab. This is working fine when I am running on my system or server.

However when running on Gallery it is not able to open the excel because Gallery (a web app) is not able to access Microsoft Excel app.

Any help would be highly appreciated

SowmyaNagaraju · Answer

Hi, I'm facing the same issue - while trying to modify Excel file using PowerShell script. Could you please tell if you found the solution to this problem. Thank you!

AmeliaG · Answer

Hi @kkanda,

When Set-StrictMode is off, uninitialized variables (Version 1) are assumed to have a value of 0 (zero) or $Null, depending on type. References to non-existent properties return $Null, and the results of function syntax that is not valid vary with the error. Unnamed variables are not permitted.

Where is the excel file located which you are trying to open with the script?

kkanda · Answer

Thanks AmeliaG

All the assets are included while publishing the workflow. Actually, the PowerShell script used is opening an excel which is giving the error on Gallery.

I have logged the PowerShell error and below is the error generated.