[WPF] What control should I use to embed Excel in my app

Question

Hello, thanks for reading,

I am upgrading an app from VB6 to VB.NET using WPF, in this old VB6 app there was "OLE" objects allowing the app to show Excel graph, sheets, and more.
In WPF i couldn't find any similar objects, so i found this tuto allowing me to indeed embed an Excel sheet in my app :
https://www.codeproject.com/Articles/15760/How-to-Integrate-Excel-in-a-Windows-Form-Applicati
And it works. It uses the WebBrowser object from WPF controls. But after using it for a bit it really seems like it is not made to open local documents and more for web browsing (as the name implies).

So here is my question : Is there a WFP object made for embeding Excel, word ect... (With for exemple methods for opening and closing properly the app) or should i go on with the WebBrowser Object?

Thanks again for reading,
Have a good day
Théo

Answer 1

You can use DocumentViewer to show the Excel. In order to show Excel content you could either convert the content into FlowDocument or XPS format.I will show my steps to open excel in WPF.(txt for code)
Step 1 :Add Microsoft.Office.Interop.Excel in the Project Nuget.
Step 2 :The code for MainWindow.xaml

Step 3 :The code for MainWindow.xaml.cs

Here is the result picture:

Answer 2

There is spreadsheet gear. Depending on the size of your spreadsheets you might have to buy a license

https://www.nuget.org/packages/SpreadsheetGear/