NPOI
Sylvan
NPOI | Sylvan | |
---|---|---|
16 | 10 | |
5,519 | 334 | |
0.7% | - | |
9.1 | 7.5 | |
1 day ago | 9 days ago | |
C# | C# | |
Apache License 2.0 | 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.
NPOI
- 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
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?
EPPlus
Sylvan.Data.Excel - The fastest .NET library for reading Excel data files.
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.
CsvExport - Very simple CSV-export tool for C#
Open XML SDK - Open XML SDK by Microsoft
Cinchoo ETL - ETL framework for .NET (Parser / Writer for CSV, Flat, Xml, JSON, Key-Value, Parquet, Yaml, Avro formatted files)
ExcelDataReader - Lightweight and fast library written in C# for reading Microsoft Excel files
CsvHelper - Library to help reading and writing CSV files
DocX - Fast and easy to use .NET library that creates or modifies Microsoft Word files without installing Word.
Cursively - A CSV reader for .NET. Fast, RFC 4180 compliant, and fault tolerant. UTF-8 only.
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
RecordParser - Zero Allocation Writer/Reader Parser for .NET Core