Access Microsoft Excel from Alteryx Gallery

[kkanda]

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

[AmeliaG]

Hi @kkanda,

Workflows kicked off to run from the Gallery are running on the server. If it works on the server and all of the dependent files are saved to the Gallery, it should work fine in the Gallery as well. Please check:

1. The script is saved to the Gallery with the workflow, see manage workflow assets in the 'Save As' flow

2. The system user has access to the relevant Excel file 

If this does not resolve, can you please send a screenshot of the error message?

[kkanda]

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.

[AmeliaG]

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?

[SowmyaNagaraju]

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!