Alteryx server scenarios

Question

Hi Alteryx engineer,

We have one alteryx server owned by company and it is not allowed to install Office-Excel.

Our user case is to perform some vbscript to call a excel macro getting data and on the other hand, there are some formular in the excel and when data is flushed we need to perform vbscript to open the excel save it and close to read the calculated value from the formular.

But without Excel installed, we failed at  the first step

Set ExcelProgram = CreateObject("Excel.Application")

is there any workaround for our scenarios?

Giv

Samantha_Jayne · Answer

@187

Have you got the following driver installed on your server

https://www.microsoft.com/en-us/download/details.aspx?id=13255

Also you can interact with excel documents with this driver installed. I have previously used blog input and output to copy excel templates and paste new data into it.

Not sure if this is something you need but its certainly worth checking you have this installed.

187 · Answer

@ArtApa

what if user insists on using formula and the excel macro is irreplaceable？Any workaround?

ArtApa · Answer

Hi @187 - I'd suggest to consider implementing the logic into an Alteryx workflow and get rid off vbscripts.