Welcome to the Gallery. Please feel free to post and comment, and check out our FAQ!

Community Gallery

Post, download, and share all of your favorite tools and workflows — from Alteryx supported to user-built.
Introducing Alteryx Marketplace

Easily access verified, supported, and secure Add-Ons.

LEARN MORE
Comments
Richard_Data
5 - Atom

The alteryx version has an issue with the naming of the designer.venv and should instead be named Jupyter venv now.

Bargeton
7 - Meteor

Hello,

 

On my desktop it's working well.

But deploying on server I had issue... (see error log copy bellow).

 

Note that on both (desktop and server) I have only the builtin python installed.

 

Regards,

 

Alex

 

 

00:00:54.273 - Error - ToolId 6: Tool #3: ---------------------------------------------------------------------------
com_error Traceback (most recent call last)
d:\apps\alteryx\bin\miniconda3\envs\designerbasetools_venv\lib\site-packages\win32com\client\dynamic.py in _GetGoodDispatch(IDispatch, clsctx)
88 try:
---> 89 IDispatch = pythoncom.connect(IDispatch)
90 except pythoncom.ole_error:
com_error: (-2147221005, 'Invalid class string', None, None)

During handling of the above exception, another exception occurred:
com_error Traceback (most recent call last)
<ipython-input-4-04ef72a74d7b> in <module>
17 while (rowcount<max_rows):
18 print(str(rowcount) + " " + df.iloc[rowcount, df.columns.get_loc('FullPath')])
---> 19 save_xls_as_xlsx(df.iloc[rowcount, df.columns.get_loc('FullPath')])
20 rowcount = rowcount + 1
<ipython-input-4-04ef72a74d7b> in save_xls_as_xlsx(path)
3 def save_xls_as_xlsx(path):
4 # Opening Excel application
----> 5 excel = win32.gencache.EnsureDispatch('Excel.Application')
6 wb = excel.Workbooks.Open(path)
7
d:\apps\alteryx\bin\miniconda3\envs\designerbasetools_venv\lib\site-packages\win32com\client\gencache.py in EnsureDispatch(prog_id, bForDemand)
525 def EnsureDispatch(prog_id, bForDemand = 1): # New fn, so we default the new demand feature to on!
526 """Given a COM prog_id, return an object that is using makepy support, building if necessary"""
--> 527 disp = win32com.client.Dispatch(prog_id)
528 if not disp.__dict__.get("CLSID"): # Eeek - no makepy support - try and build it.
529 try:
d:\apps\alteryx\bin\miniconda3\envs\designerbasetools_venv\lib\site-packages\win32com\client\__init__.py in Dispatch(dispatch, userName, resultCLSID, typeinfo, UnicodeToString, clsctx)
93 """
94 assert UnicodeToString is None, "this is deprecated and will go away"
---> 95 dispatch, userName = dynamic._GetGoodDispatchAndUserName(dispatch,userName,clsctx)
96 return __WrapDispatch(dispatch, userName, resultCLSID, typeinfo, clsctx=clsctx)
97
d:\apps\alteryx\bin\miniconda3\envs\designerbasetools_venv\lib\site-packages\win32com\client\dynamic.py in _GetGoodDispatchAndUserName(IDispatch, userName, clsctx)
112 else:
113 userName = str(userName)
--> 114 return (_GetGoodDispatch(IDispatch, clsctx), userName)
115
116 def _GetDescInvokeType(entry, invoke_type):
d:\apps\alteryx\bin\miniconda3\envs\designerbasetools_venv\lib\site-packages\win32com\client\dynamic.py in _GetGoodDispatch(IDispatch, clsctx)
89 IDispatch = pythoncom.connect(IDispatch)
90 except pythoncom.ole_error:
---> 91 IDispatch = pythoncom.CoCreateInstance(IDispatch, None, clsctx, pythoncom.IID_IDispatch)
92 else:
93 # may already be a wrapped class.
com_error: (-2147221005, 'Invalid class string', None, None)