CsvHelper
Sylvan
CsvHelper | Sylvan | |
---|---|---|
36 | 10 | |
4,539 | 334 | |
- | - | |
8.7 | 7.5 | |
8 days ago | 11 days ago | |
C# | C# | |
GNU General Public License v3.0 or later | 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.
CsvHelper
- CsvHelper – CSV Library for .NET
-
What’s the quickest way I can log data and write it to a csv file?
I would also say either a logging framework or one of the many NuGet packages. Like CsvHelper.
-
Parsing CSV?
I've been using CsvHelper for a long time and I quite like it. It's flexible and configurable enough to suit all my needs. Though the authors have unpleasant habit of introducing breaking changes (currently they are at major version 30).
-
Best language for manipulating an Excel file.
It's really slow compared to (for example) csvhelper. I tried to use the built in microsoft stuff to handle a data transformation routine using excel files, turning them into csvs and using the csv library sped up the process from 3-4 minutes to about 8 seconds.
-
Introducing: EasyCsv Dotnet
How might it compare to https://www.nuget.org/packages/CsvHelper/?
-
The new type of SQL injection
Let me guess, you replaced a string.Split(',') with CsvHelper?
-
C# . NET alternative for PowerShell Export-CSV
I use CSVHelper https://joshclose.github.io/CsvHelper/ it has a WriteRecords function that will write out your objects
-
Creating a Web App using Excel
I would recommend looking at this popular library for reading / writing to csv files. https://joshclose.github.io/CsvHelper/
-
Struggling with Open Source Documentation - csvhelper
This is probably a bit churlish to complain about, since it's an entirely free tool that has saved me a lot of time and effort, but I'm baffled by the documentation for CsvHelper by Josh Close.
-
Saving datas with more than Excel limit of rows
https://joshclose.github.io/CsvHelper/ is a good library for creating CSVs, but you need to tell us more about who is consumer of this export and may be there is a more direct approach
Sylvan
-
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.
What are some alternatives?
FileHelpers - The FileHelpers are a free and easy to use .NET library to read/write data from fixed length or delimited records in files, strings or streams
Sylvan.Data.Excel - The fastest .NET library for reading Excel data files.
FluentValidation - A popular .NET validation library for building strongly-typed validation rules.
CsvExport - Very simple CSV-export tool for C#
RecordParser - Zero Allocation Writer/Reader Parser for .NET Core
Cinchoo ETL - ETL framework for .NET (Parser / Writer for CSV, Flat, Xml, JSON, Key-Value, Parquet, Yaml, Avro formatted files)
Enums.NET - Enums.NET is a high-performance type-safe .NET enum utility library
Cursively - A CSV reader for .NET. Fast, RFC 4180 compliant, and fault tolerant. UTF-8 only.
FlatMapper - FlatMapper is a library to import and export data from and to plain text files.
NPOI - a .NET library that can read/write Office formats without Microsoft Office installed. No COM+, no interop.
Polly - Polly is a .NET resilience and transient-fault-handling library that allows developers to express policies such as Retry, Circuit Breaker, Timeout, Bulkhead Isolation, and Fallback in a fluent and thread-safe manner. From version 6.0.1, Polly targets .NET Standard 1.1 and 2.0+.