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…