topic Refresh Excel File in Server in Alteryx Server Discussions

Refresh Excel File in Server

VijayAnaparthi — Fri, 02 Dec 2022 13:31:31 GMT

I am able to refresh Excel file in designer by using python package Pywin32 and Xlwings but both packages are not working in Server.

Can anyone please tell me how to refresh Excel file by using any tool or python script that will work in server

Command tool will not work in My server, so i don't have option to choose vbascript for this.

I have tried openpyxl also but i am unable to solve refreshing Excel issue.

Can anyone please tell me how to refresh Excel file by using any tool or python script that will work in server

Re: Refresh Excel File in Server

gabrielvilella — Fri, 02 Dec 2022 14:11:47 GMT

Why are those packaged not working on the Server? Are they installed there already? If not, you need to request it to the Server admin. You can only refresh Excel from Alteryx by calling a custom script like python or something on run command.

Re: Refresh Excel File in Server

VijayAnaparthi — Fri, 02 Dec 2022 14:47:04 GMT

All python packages are installed on server but i am getting error related to that packages. Unfortunately command tool will not run in my server. so i.e why i am looking for alternative solution that will work on server.

Re: Refresh Excel File in Server

NicolasSz — Fri, 02 Dec 2022 16:07:01 GMT

Hi @VijayAnaparthi ,

I ran into the same type of issue. You probably need to install excel onto your server to have the necessary drivers.

But this is quite bad practice as Excel is not supported for Server as per Microsoft documentation.

On my side, I didn't find any proper way of doing this. Best is to get rid of need to refresh an excel file onto the server as much as you can.

But happy to look if anyone as a good and proper solution here.