Description: Error in Hyperstudy while optimization run using Excel
I trying optimization in hyperstudy using excel sheet. Excel sheet contains design inputs. It has macro to run analysis and generate output, which needs to be optimized.
I have given macroname and path in solver input argument
— Calculate ${filepath_resource}
I am facing following error
85 Error : Command ( runmodel ) to ( Spreadsheet )failed with error ( Traceback (most recent call last):
File ".\alt\hst\eac\impl\spreadsheet_client.py", line 82, in startReceiveLoop
File ".\alt\hst\eac\impl\spreadsheet_client.py", line 112, in __RunModel
File ".\alt\hst\eac\impl\spreadsheet_intf.py", line 146, in RunModel
File ".\alt\hst\utl\hstappintfxls.py", line 461, in RunMacro
File "<COMObject Excel.Application>", line 14, in Run
File "\\10.20.4.62\altair-sw\Altair\2021.2\common\python\python3.5\win64\lib\site-packages\win32com\client\dynamic.py", line 287, in _ApplyTypes_
result = self._oleobj_.InvokeTypes(*(dispid, LCID, wFlags, retType, argTypes) + args)
pywintypes.com_error: (-2147352567, 'Exception occurred.', (0, None, None, None, 0, -2147352562), None)
)
86 Error : The ( Execute ) task has failed for model ( Spreadsheet 1 ( m_1 ) ).
87 Error : The execute task has failed for model ( Spreadsheet 1 ( m_1 ) ).
Product/Topic Name : Hyperstudy 2021.2
*Note from Community Team - Once you receive a satisfactory answer on your question, kindly mark your answers as "Accepted" so it can help others with similar problems. Thanks.