Thank you for reporting this issue 👍

It seems that the problem is not with RoslynPad but with the Microsoft.Office.Interop.Excel DLL
Unfortunately, this DLL has not been updated to work with .NET 6
The latest framework compatible with Microsoft.Office.Interop.Excel is .NET 4.8

As an example, if we create a console application targeting .NET 6, we will get the same error:

Thank you for reporting this issue 👍

It seems that the problem is not with RoslynPad but with the Microsoft.Office.Interop.Excel DLL Unfortunately, this DLL has not been updated to work with .NET 6 The latest framework compatible with Microsoft.Office.Interop.Excel is .NET 4.8

As an example, if we create a console application targeting .NET 6, we will get the same error:

Thank you for your reply.
This Microsoft.Office.Interop.Excel DLL can be used in LinqPad7 with DotNet6.0, and it works well, so I guess there are some tricks that can fix this bug.

Microsoft.Office.Interop.Excel targets .NET Standard 2.0. As a result, this DLL can work with .NET 6.0.
However, this DLL has not been updated to work with .NET Core by default.

If we take the example of the console application, it is necessary to import the DLL manually and to define the EmbedInteropTypes property.

Regarding LinqPad, indeed the developers have added the possibility to integrate the Office Interop COM libraries from the 6th version for .NET Core 3.1 and above.

So can we classify this issue as an enhancement?

I will try to work on it! 😉

@tsiank, I created a PR to solve this issue 👍
Thank you for your feedback!

@jboinembalome ，I have't thought it's fixed so quickly, thank you for your work, that's great! I will have a try.

@jboinembalome ，I have tested, it works perfectly now, thank you again!

Good news! You’re welcome @tsiank, it's a pleasure to help you 😉