Sylvan
A collection of .NET libraries, including the fastest general-purpose CSV parser for .NET. (by MarkPflug)
NPOI
a .NET library that can read/write Office formats without Microsoft Office installed. No COM+, no interop. (by nissl-lab)
Our great sponsors
| Sylvan | NPOI | |
|---|---|---|
| 10 | 16 | |
| 334 | 5,510 | |
| - | 1.7% | |
| 7.5 | 9.1 | |
| 6 days ago | 5 days ago | |
| C# | C# | |
| MIT License | Apache License 2.0 |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
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.
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.
Sylvan
Posts with mentions or reviews of Sylvan.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-01-31.
-
Reading CSV 180k records - Calculate something within 60 second time while grouping
A while back I needed to process CSV with millions of records in a timescale of seconds. Sylvan Data was the best fit in terms of speed and memory efficiency. It might help you. https://github.com/MarkPflug/Sylvan
-
CSV reader recommendations...
I maintain a couple libraries that aim to provide similar functionality to MTD: Sylvan.Data and Sylvan.Data.Csv.
-
Any tips on converting a XLSX file to HTML without using a licensed library?
Here is a simple, complete gist showing how to turn a DbDataReader into an HTML table. The WriteHtmlTable extension method can be used with any ADO.NET compatible driver, which the Sylvan.Data.Excel and Sylvan.Data.Csv libraries both support.
-
Need some help/direction reading CSV into MySQL without duplication
I maintain a couple libraries that can help with reading the data files: Sylvan.Data.Csv and Sylvan.Data.Excel. I see no reason to not allow users to provide whichever format is convenient for them.
-
How would I go about parsing a CSV like file that uses "SPACE" as delimiter and other quirks.
I maintain a CSV library, Sylvan.Data.Csv, that shouldn't have any issue parsing this. You'll need to explicitly specify that space (' ') is the delimiter.
- How do I get Excel column data type with OpenXml?
-
Read uploaded excel file
Here is a some sample code of how to echo the contents of an Excel spreadsheet as CSV to the client browser using my libraries Sylvan.Data.Excel and Sylvan.Data.Csv:
-
TimeThis! - Simple timings for code blocks (Fun with IDisposable)
``` For reference, my implementation is here.
-
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.
-
Using C# StreamReader in System.IO, I am able to read external .csv data and visualise the hell out of it in my C# app (CLUBASID).
Personally, I'd recommend Sylvan.Data.Csv, but being the author I'm probably a bit biased. Here is some CSV performance analysis that Joel Verhagen did for .NET libraries recently.
NPOI
Posts with mentions or reviews of NPOI.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-04-14.
- Hola, problema con un crud
-
Is it possible to use Microsoft Word features programatically?
NPOI (Open source, MIT)
-
Is MS Word interop dead now on .NET core?
For .NET Core you can use - https://github.com/nissl-lab/npoi - https://github.com/Jetro223/DocXNETCore
-
What's the best way to read an Excel file into a DataGrid in WinUi 3?
I use NPOI https://github.com/nissl-lab/npoi its a popular package for reading Excel. It is both faster than interop and free (open source).
-
Help needed with .xlsb files
Have you tried NPOI?
-
NPOI Alternative Spreadsheet API Performance Test in C# .NET
Competitor#2 (NPOI - v2.5.6)
- Calling Java from C#
-
cannot create an instance of the abstract type or interface. how to solve this ???
If you are trying to *create* Excel files, then you might take a look at [NPOI](https://github.com/nissl-lab/npoi) which is also open source with a permissive license. There is also [ClosedXml](https://github.com/ClosedXML/ClosedXML), which has these capabilities.
-
Read Data from a Column of an Excel File
I'd like to use NPOI to deal with Excel files. It's open source and you don't have to install Microsoft Office.
-
Read uploaded excel file
EPPlus ExcelDataReader NPOI
What are some alternatives?
When comparing Sylvan and NPOI you can also consider the following projects:
Sylvan.Data.Excel - The fastest .NET library for reading Excel data files.
EPPlus
CsvExport - Very simple CSV-export tool for C#
ClosedXML - ClosedXML is a .NET library for reading, manipulating and writing Excel 2007+ (.xlsx, .xlsm) files. It aims to provide an intuitive and user-friendly interface to dealing with the underlying OpenXML API.
Cinchoo ETL - ETL framework for .NET (Parser / Writer for CSV, Flat, Xml, JSON, Key-Value, Parquet, Yaml, Avro formatted files)
Open XML SDK - Open XML SDK by Microsoft
CsvHelper - Library to help reading and writing CSV files
ExcelDataReader - Lightweight and fast library written in C# for reading Microsoft Excel files
Cursively - A CSV reader for .NET. Fast, RFC 4180 compliant, and fault tolerant. UTF-8 only.
DocX - Fast and easy to use .NET library that creates or modifies Microsoft Word files without installing Word.
RecordParser - Zero Allocation Writer/Reader Parser for .NET Core
Report-From-DocX-HTML-To-PDF-Converter - .NET Core library to create custom reports based on Word docx or HTML documents and convert to PDF