Menu
I need to parse xlsx file on Linux from .NET Core Console application. However, I couldn't find any library for parsing Microsoft Office files that is supported by .NET Core 5 framework.
813
using (ExcelPackage xlPackage = new ExcelPackage(existingFile)) { // get the first worksheet in the workbook ExcelWorksheet worksheet = xlPackage. Workbook. Worksheets[1]; int iCol = 2; // the column to read // output the data in column 2 for (int iRow = 1; iRow < 6; iRow++) Console. WriteLine("Cell({0},{1}).
You could use EPPlus to read Excel file. EPPlus is a . net library that reads and writes Excel 2007/2010 files using the Open Office Xml format (xlsx).
Have you taken a look at Excel Data Reader?
There's also a NuGet package if that makes it easier to install.
The API project file doesn't appear to have any COM interop requirements with Office, which is further supported by the existence of Android and Silverlight compatible projects included in the library.
184
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
