search

paulyoder / LinqToExcel

Use LINQ to retrieve data from spreadsheets and csv files
MIT License
1.06k stars 300 forks source link

.NetCore 3.1 support? #184

Open MagicAndre1981 opened 4 years ago

MagicAndre1981 commented 4 years ago

Is it possible to get .Net Standard 2.x support? This would fix my NU1701 warning:

warning NU1701: Package 'LinqToExcel 2.0.0-PRERELEASE-2' was restored using '.NETFramework,Version=v4.6.1, .NETFramework,Version=v4.6.2, .NETFramework,Version=v4.7, .NETFramework,Version=v4.7.1, .NETFramework,Version=v4.7.2, .NETFramework,Version=v4.8' instead of the project target framework '.NETCoreApp,Version=v3.1'. This package may not be fully compatible with your project.

MagicAndre1981 commented 4 years ago

ok, .net standard doesn't have OleDb support. So direct .NetCore 3.1 support is needed.

mrworkman commented 4 years ago

Interesting, Oledb wasn't supported in .Net Core before... I'll have to look into it.

MagicAndre1981 commented 3 years ago

ok, System.Data.OleDb package supports .net standard 2.0 and 3.1, but I have no idea how to test it. nunit console only has a beta to test .net core, but this fails.

In my application it looks like it works to load the Excel file and query data.

MagicAndre1981 commented 3 years ago

I tried to implement it with #188 @mrworkman

MagicAndre1981 commented 3 years ago

I gave it up now. I switched to ExcelMapper which is based on a pure managed excel reading library which is an advantage over LinqToExcel so that it doesn't require Office runtimes.

BarsikV commented 2 years ago

I gave it up now. I switched to ExcelMapper which is based on a pure managed excel reading library which is an advantage over LinqToExcel so that it doesn't require Office runtimes.

Thanks man, that helped a lot and the libraries work in a very similar way :)