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

[BhavanaPaul1]

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
------------------------------

[hossein.azimi]

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
------------------------------

[divasgupta1]

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

Regards
Divas

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

[hossein.azimi]

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
------------------------------

[Chan_Thomas]

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? 

[MichealCharron]

@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.