F25 PROG1322 11.3 - Step 17 - EPPlus for working with Excel Files
Since Microsoft Office switched to a zipped XML format (OOXML), we can now easily create and manipulate office documents, including Excel Spreadsheets, without the need for OLE or Office .dll files! This is fantastic for both Web Development and Cross Platform.
EPPlus uses OfficeOpenXML and has been updated for .NET Standard so it works just as well in .NET Core as .Net Framework. Get to know it and you will love it. Warning: Version 5 and beyond is no longer totally free to use, at least for commercial use.
https://github.com/JanKallman/EPPlus/...
Nice Resource for EPPlus snippits:
https://www.codeproject.com/articles/...