Using Microsoft.Office.Interop.Excel.Application class causes Validation Error in Invoke Code activity

Writing a script that uses Microsoft.Office.Interop.Excel.Application causes validation and cannot be run.

  • Add the nuget package for Microsoft.Office.Interop.Excel.Application to your package.
    • The nuget package is available here for download
  • This website can be added as a custom nuget feed by adding the source from here
  • To add custom nuget feed, refer here