I am totally newbie and trying to make an application that can handle an Excel spreadsheet. I am making it in Visual Studio 2019. It is a WPF application (.NET Core) using MVVM model (I used a template from Windows Template Studio). The idea is to be able to read or import the file .xls, .xlsx, .ods, .cvs, etc. and display it in a DataGridView, create or edit items, and rewrite or export it to the spreadsheet. I installed different nuget packages. OleDB, compatibility, others that I do not remember. Finally, I deleted the project and started again. Now I posted it on GitHub. I currently have the nuget package System.Data.OleDb and Microsoft.Windows.Compatibility installed. I followed a tutorial but I had to correct many compatibility errors with net framework and windows form. https://github.com/Lestradez/WPF_NET_CORE_EXCEL
The specific question would be what is the most correct way to implement this functionality or what is the way to correct compatibility errors?
Thanks in advance!