I am trying to use “StudioX” Excel Activities in “Studio”.
(1)After exporting data from SAP, that exported data is read with Read Range Activity once into DataTable.
(2)Within Use Excel File Activity (StudioX >> Business >> Excel), I placed Write Cell Activity (Studio X >> Business >> Excel)) to write some values from (1) DataTable.
However, this always triggers error: “Use Excel File: COM object that has been separated from its underlying RCW cannot be used.”
Whereas I placed Delay Activity to intentionally slow down the processes between (1) and (2), still the error message is popped out.
Is anyone having a solution or mitigation? Thanks in advance!