topic RE: Internal : Could not execute code stage because exception thrown by code stage: Method's type signature is not Interop compatible. in Product Forum

Internal : Could not execute code stage because exception thrown by code stage: Method's type signature is not Interop compatible.

BhavanaPaul1 — Tue, 15 Dec 2020 20:11:00 GMT

Anyone come across below issue while using MsExcel VBO-Write Collection
Internal : Could not execute code stage because exception thrown by code stage: Method's type signature is not Interop compatible.

------------------------------
Bhavana Paul
RPA Developer
IBM
Asia/Kolkata
------------------------------

RE: Internal : Could not execute code stage because exception thrown by code stage: Method's type signature is not Interop compatible.

hossein.azimi — Wed, 16 Dec 2020 11:37:00 GMT

Hi Bhavana,

The problem I faced with the Error: "Method's type signature is not Interop compatible", was that I was trying to write a TimeSpan data item into the Excel file. Didn't work so changed the TimeSpan data item to a Text data item.

I suggest checking your data type.

------------------------------
Hossein Azimi
Customer Support Engineer, APAC
Blue Prism
Sydney NSW
------------------------------

RE: Internal : Could not execute code stage because exception thrown by code stage: Method's type signature is not Interop compatible.

divasgupta1 — Thu, 13 Oct 2022 09:18:00 GMT

Hi Hossein Azimi,
Would you be able to share how did you convert the timespan to text format.

Regards
Divas

------------------------------
divas gupta
------------------------------

RE: Internal : Could not execute code stage because exception thrown by code stage: Method's type signature is not Interop compatible.

hossein.azimi — Sun, 16 Oct 2022 07:20:00 GMT

Hi Divas,

Thank you for contacting customer support.

You can change the data type from timespan to text format from inside the data item properties.

------------------------------
Hossein Azimi
Customer Support Engineer, APAC
Blue Prism
Sydney NSW
------------------------------

Re: RE: Internal : Could not execute code stage because exception thrown by code stage: Method's typ

Chan_Thomas — Fri, 15 Nov 2024 15:05:36 GMT

hi, with this answer, I need a timespan to be in my data as Excel can't give me the correct answer when looking for the time difference between two times (across 2 dates).
If I simply change the TimeSpan to Text, then all my previous work wouldn't work as I need the timespan. How do I get the timespan to a text without just changing the drop down please so it can write to excel?

Re: RE: Internal : Could not execute code stage because exception thrown by code stage: Method's typ

MichealCharron — Fri, 15 Nov 2024 15:39:45 GMT

@Chan_Thomas

If are just looking to use the Set Cell Value in Blue Prism's MS Excel VBO, you can simply put the TimeSpan data item into the Value parameter. When you drag the data item into the parameter Blue Prism will complain that that is not the correct data type but at run-time it will automatically cast the TimeSpan as text.