Sylvan.Data.Excel
MySqlConnector
Sylvan.Data.Excel | MySqlConnector | |
---|---|---|
12 | 8 | |
168 | 1,355 | |
- | 0.5% | |
7.0 | 9.1 | |
9 days ago | 10 days ago | |
C# | C# | |
MIT License | 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.
Sylvan.Data.Excel
-
Today I learned that Range.Find() in the Excel interop library respects any filters the workbook was saved with and will not return results from filtered rows.
I'm a fan of Sylvan.Data.Excel myself
-
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.
-
What's the best way to read an Excel file into a DataGrid in WinUi 3?
You can give my library a try: Sylvan.Data.Excel. You seem to be concerned about performance, so you can be happy to know it is the fastest Excel reader in the .NET ecosystem, by quite a wide margin. It is open source, MIT licensed, and is easy to use (in my biased opinion).
-
Easiest Way to Read and Import Excel File Data into DataTable C#
The easiest? I'm gonna have to disagree with you on that one. I believe my library, Sylvan.Data.Excel make it even easier (possibly the easiest) to read Excel data in .NET.
-
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.
-
cannot create an instance of the abstract type or interface. how to solve this ???
I would recommend taking a look at [Sylvan.Data.Excel](https://github.com/MarkPflug/Sylvan.Data.Excel) if all you are trying to do is read data out of excel. It is a library that I maintain, and is extremely fast and easy to use.
-
Read .xls, .xlsx files using interop and import to datatable
I maintain a library that you can try: Sylvan.Data.Excel.
-
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:
MySqlConnector
-
Faster MySQL with HTTP/3
MySqlConnector (the most popular .NET library for MySQL, and the one that I authored) has supported protocol compression for many years: https://github.com/mysql-net/MySqlConnector/issues/31.
-
Implementing the MySQL server protocol for fun and profit
> I kept technical notes about the protocol, to serve as a future reference for myself and for other developers.
As someone who's written a MySQL client (in C#: https://github.com/mysql-net/MySqlConnector), I'd be very interested to see your notes. Are they available anywhere, or were they the confidential IP of your client?
> Unsurprisingly, bugs were uncovered every time a new client was added.
I've faced the same thing, from a client perspective. Every time a new server is tested (MySQL, MariaDB, Amazon Aurora, Azure Database for MySQL, etc.), I find slightly different interpretations of the protocol and have to accommodate them.
-
Ask HN: Examples of Top C# Code?
I have had the pleasure of contributing to a couple different networked drivers with very talented maintainers that I like to use as references.
One supports a wide array of Framework versions and has both Sync and Async I/O, as it must to implement the ADO.NET database driver interfaces. Reading the internals really highlight the way that .NET has evolved over the years and what must be done in each target version to maximize performance:
https://github.com/mysql-net/MySqlConnector
The other supports .NET 6 only with Async I/O only. This support policy seems to be the way that "modern" .NET development is headed, as .NET 6 will be the floor for LTS .NET (formerly .NET Core) releases in a few months. Async APIs only greatly simplify development, and make it simpler to remain performant when targeting WASM.
https://github.com/Cysharp/AlterNats
As a library maintainer, one thing I often wonder about is how to indicate .NET version support. One option would be for the major version of the library to track the major version of .NET, so if I were to publish a new library today then start with .NET 6 support and start with version number 6.0.0 instead of 1.0.0. This would limit the library to only making breaking changes when the .NET version changes though.
- Do I need to worry about connection pooling/etc with MySql.Data.MySqlClient?
-
Need some help/direction reading CSV into MySQL without duplication
Use the MySqlConnector to load the data into a temp table using the bulk copy API. Both of my libraries implement the IDataReader (DbDataReader) interface, so they can be directly used with the bulk copy APIs. Then insert into the final table from the temp table filtering out rows that are already in the final table.
- Finding an Authorization Bypass on My Own Website
-
Performance Improvements in .NET 6
I'm the author of what you might call the "new" MySQL ADO.NET library: https://github.com/mysql-net/MySqlConnector
I agree with your impression that developers of the other library don't seem to be "plugged in to" the .NET ecosystem. As an independent developer (not affiliated with Oracle or Microsoft), I've been able to influence GitHub PRs that shape the ADO.NET API for .NET 6.0, just by showing up and contributing; I haven't seen anyone from the Oracle MySQL team participating. Meanwhile, they violate basic principles of the .NET Framework Design Guidelines that have been around for over a decade (https://docs.microsoft.com/en-us/dotnet/standard/design-guid...), which makes their library feel alien to a .NET programmer (regardless of the quality issues it might have).
-
MongoDB C# Driver Vs. MongoDB.Entities Benchmark
e.g. this community effort of a MySQL ADO.NET provider is miles ahead of Oracle's driver.
What are some alternatives?
ExcelDataReader - Lightweight and fast library written in C# for reading Microsoft Excel files
Pomelo.EntityFrameworkCore.MySql - Entity Framework Core provider for MySQL and MariaDB built on top of MySqlConnector
Sylvan - A collection of .NET libraries, including the fastest general-purpose CSV parser for .NET.
Avalonia.FuncUI - Develop cross-plattform GUI Applications using F# and Avalonia!
ExcelMapper - An Excel to object mapper. Maps POCOs to and from Excel. Configuration via convention, attributes, or fluent methods.
openiddict-core - Flexible and versatile OAuth 2.0/OpenID Connect stack for .NET
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.
Hot Chocolate - Welcome to the home of the Hot Chocolate GraphQL server for .NET, the Strawberry Shake GraphQL client for .NET and Banana Cake Pop the awesome Monaco based GraphQL IDE.
ReadExcelUsingSylvanExample - Showing issue with user's data when worksheet column's header's have illegal characters(issue with data, not Sylvan), and Sylvan not reading file if first row is empty.
Marten - .NET Transactional Document DB and Event Store on PostgreSQL
NPOI - a .NET library that can read/write Office formats without Microsoft Office installed. No COM+, no interop.
aqtinstall - aqt: Another (unofficial) Qt CLI Installer on multi-platforms