CsvBenchmarks
ClosedXML
CsvBenchmarks | ClosedXML | |
---|---|---|
12 | 26 | |
14 | 4,421 | |
- | 2.0% | |
5.4 | 9.4 | |
21 days ago | 5 days ago | |
C# | C# | |
- | MIT License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
CsvBenchmarks
-
CSV reader recommendations...
The Sylvan.Data.Csv library is also the fastest CSV parser for .NET, and can load data about 3x faster than MTD based on my limited testing.
-
What's the best way to read an Excel file into a DataGrid in WinUi 3?
I don't want to disparage NPOI, because I'm sure it's great for its primary use-case, which is creating/editing spreadsheets. However, from a performance perspective it is one of the slowest libraries for reading Excel data in .NET. Since the OP seemed to be very concerned about performance and only needs to read data, this probably isn't the best choice.
-
Help needed with .xlsb files
I'm pretty sure NPOI doesn't support .xlsb. At least it didn't the last time I updated my benchmarks: https://github.com/MarkPflug/Benchmarks/blob/main/docs/ExcelBenchmarks.md
-
How would I use an Excel file as Data Source for SQLite connection?
If you're trying to load an Excel worksheet into a DataTable, I maintain a library that can make this quite easy: Sylvan.Data.Excel. It is available as a nuget package, open source, MIT licensed, and the fastest Excel reader for .NET.
-
How to convert an Excel file to Data table
I maintain a library, Sylvan.Data.Excel that might work for you. I claim it is the fastest Excel library in the .NET ecosystem. It is open source and MIT licensed, so feel free to use it however you wish. It has no external dependencies other than .NET itself.
-
Read .xls, .xlsx files using interop and import to datatable
It provides a forward only data reader (DbDataReader) for all common excel formats (.xlsx, .xlsb, and .xls). It is the fastest and lowest allocating Excel reader in the .NET ecosystem.
-
Read uploaded excel file
This one is one that I personally maintain: Sylvan.Data.Excel It isn't fully featured, but it is the fastest that I'm aware of.
-
Microsoft .net XLSX to CSV library?
I maintain a couple libraries that should make this quite easy: Sylvan.Data.Csv, and Sylvan.Data.Excel. They are both open-source and MIT licensed. They are also both fastest-in-class at their particular tast.
-
Read Excel file in .NET 6 deployed on Linux?
It isn't exactly a full-featured library, but it is cross-platform and is the fastest and lowest allocating Excel reader that I'm aware of for .NET. That might not be a huge concern if you're just processing the occasional file.
-
The Fastest Csv Parser In Net
Thanks for this -- I've pushed a PR that corrects a slight incorrectness issue that biased the results in Cursively's favor, uses the original byte array directly instead of needlessly wrapping it in a MemoryStream, and uses the same optimization that you used to make SylvanSimplePool win in its category. CursivelyCsv is now the winner on my machine in this category when doPooling is on.
ClosedXML
-
When XML in Word Became Illegal
It's also country specific.
I work on Excel library and the text to number/date feature was one of less fun things to implement at least semi-correctly.
I remember my comment on the PR back then:
https://github.com/ClosedXML/ClosedXML/pull/1899
-
Visual Studio C#: Is it possible to manipulate Excel file via Visual Studio
Once installed, you can start using ClosedXML directly in your project. Go through their wiki for some sample codes based on what you are trying to achieve in your app.
-
VBA script in Excel runs much slower is Outlook is open
There are alternatives to requiring opening the full Excel application and its resource overhead. Especially given you're simply reading, sorting, and writing. One of the most popular is CloseXML which you add via a NuGet package.
-
Any tips on converting a XLSX file to HTML without using a licensed library?
Time to dig into those open xml docs. Honestly it’s not that bad once you get your bearings. ClosedXML offers a somewhat thin wrapper as well. I’ve used these with great success but they are quite low level.
- I need a Data-Grid that I can copy/paste excel data with
-
adding cell color in Excel file using c#
ClosedXML is an open wrapper around OOXML.
- How do I get Excel column data type with OpenXml?
-
Discovered a NuGet package called ClosedXML. Takes away the pain of dealing with OpenXML
It's open-source: https://github.com/ClosedXML/ClosedXML
- Need help with reading files in C#
- Does anyone have an opensource project they'd like a hand with?
What are some alternatives?
ExcelMapper - An Excel to object mapper. Maps POCOs to and from Excel. Configuration via convention, attributes, or fluent methods.
Open XML SDK - Open XML SDK by Microsoft
Sylvan.Data.Excel - The fastest .NET library for reading Excel data files.
EPPlus
NPOI - a .NET library that can read/write Office formats without Microsoft Office installed. No COM+, no interop.
ExcelDataReader - Lightweight and fast library written in C# for reading Microsoft Excel files
MiniExcel - Fast, Low-Memory, Easy Excel .NET helper to import/export/template spreadsheet (support Linux, Mac)
Sylvan - A collection of .NET libraries, including the fastest general-purpose CSV parser for .NET.
DocX - Fast and easy to use .NET library that creates or modifies Microsoft Word files without installing Word.