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.
I suggest checking your data type.