Exception from HRESULT: 0x80020005 (DISP_E_TYPEMISMATCH)


Type of reusable component:

background: read range from sheet3 in workbook as a datatable, write down the datatable in sheet4 in the same workbook. it is ok until here. next step is to read the sheet4 ,

Current Behavior: error Exception from HRESULT: 0x80020005 (DISP_E_TYPEMISMATCH)

Expected Behavior: read sheet4

Studio/Robot/Orchestrator Version: 2018.4

screenshot is here:
excel is a variable, namely the workbook.
sometimes it works; sometime it doesn’t! can’t find out why…


What is the data type of variable ‘i’ ?
Make sure that the value read from excel and data type of variable ‘i’ are matching.
I guess sometimes the value is not matching with the data type of ‘i’.

Karthik Byggari


thank you !@[KarthikByggar
i is an integer.
i changed a computer and the workflow. It works fine.
I have two version of excel on my computer, 2010 and 2016. the other has only one version. I don’t know if it matters…