I am using two Excel 2010 file in order to Transfer data from one file to another. I am using Excel application scopes in order to open the Excel file. The first Excel opens without a Problem but when Uipath tries to open the second Excel, then I am getting the error (Excel application scope: Exception from HRESULT: 0x80020005 (DISP_E_TYPEMISMATCH)).
Note : for transferring data I am using data table from one excel to another
Type of data I am transferring are following
- Date type ,2) String type 3) double type 4) Integer type
Below are some temporary solutions which I have used after getting above issue
- Some time I debug the code after getting above issue then it works fine after that
- Some time I just close the UI path and re-open it then works fine
Problem is, I don’t have permanent solution and this error I get 3 out of 10 times. Please help.