When exporting data into excel, we are exception thrown on Microsoft Interop Excel in Net Core 3.1

[saiganesh-sakthivel]

• .NET Core Version: (e.g. 3.0 Preview1, or daily build number, use dotnet --info)
• Windows version: (winver)
• Does the bug reproduce also in WPF for .NET Framework 4.8?: Yes/No
• Is this bug related specifically to tooling in Visual Studio (e.g. XAML Designer, Code editing, etc...)? If yes, please file the issue via the instructions here.

• Security issues and bugs should be reported privately, learn more via our responsible disclosure guidelines.

  Problem description: When exporting data into excel, we are facing the exception is thrown on Microsoft Interop Excel in Net Core 3.1, the same code works fine in WPF Framework.

  Actual behavior:

Expected behavior: It should work correctly.

Minimal repro:

GanttWPF_Core.zip

[lindexi]

@saiganesh-sakthivel See c# - How to reference Microsoft.Office.Interop.Excel dll? - Stack Overflow

And you miss the Office.dll which will be referenced as assmeblies in .NET Framework. And you should add the Office.dll explicitly in .NET Core.

I fixed your code in : https://github.com/lindexi/lindexi_gd/tree/3e2f2a2bbb0c433148a547b20f321dcb866e10cf/GanttWPF_Core