Refresh Excel File in Server
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Labels:
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.