This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
When I run this in Designer, it runs fine. I open a file that has a connection to Sharepoint, refresh the connection in this spreadsheet, save the file, and then have a separate branch of Alteryx pull the data elsewhere. When I attempt to schedule this workflow, it fails with the following error:
Thank you so much for the post on community about pywin32. This behavior is known interaction with pywin32 and our scheduler and even Server/Gallery. It boils down to how those products run workflows vs when they are ran in Designer itself. Opening a third party software like excel while running in scheduler is not fully supported, there are have some customers that have gotten it to work. I have seen some customers have success with the xlrd library (the newer version of this library cannot support files that are not xls), the older versions of this library can support xlsx though.