ClosedXML
NSubstitute
| ClosedXML | NSubstitute | |
|---|---|---|
| 26 | 11 | |
| 4,421 | 2,556 | |
| 2.0% | 0.9% | |
| 9.4 | 7.4 | |
| 6 days ago | 3 days ago | |
| C# | C# | |
| MIT License | GNU General Public License v3.0 or later |
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.
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?
NSubstitute
-
What am I missing about interfaces?
a. you might do so purely out of argo cult, i.e. because someone told you this was the right thing to do™, and that's a silly exercise. b. you could also be doing this for a good reason: to use the interface with a mocking tool like NSubstitute
-
The Moq-gate: You Either Die a Hero...
When comparing it to one of its most well-known alternatives, NSubstitute, which has "only" reached 85.6 million downloads, it is fair to say that Moq is the most widely used mocking library in the .NET ecosystem.
-
Since v4.20, Moq is harvesting email addresses
Maintainer rejected the PR. They have temporarily disabled the integration in https://github.com/moq/moq/pull/1375 but kept the SponsorLink project reference in the source code. It seems like their intent is to re-enable the integration at a later point :(
NSubstitute [0] might be an alternative. Or to fork Moq pre-4.20.
[0] https://nsubstitute.github.io/
-
Setting up a simple testing project with C#
In terms of mocking there are several frameworks you can use, but I've mainly relied on Moq and NSubstitute. Within this demo, I'm going to use NSubstitute as I've found it a little easier to use.
- [AskJS] Can we talk about Stubs, Spies and Mocks in JavaScript and what a mess they are?
-
Coincidence? I think not
it will change the URL from https://github.com/nsubstitute/NSubstitute to https://github.dev/nsubstitute/NSubstitute (or you can just nav there yourself).
-
I need a C# crash course for experienced developers
NSubstitute
-
Moq vs NSubstitute: syntax cheat sheet
🔗 NSubstitute documentation | NSubstitute
-
My Top N Favorite Plugins and Tools for Developers
If you use NSubstitute (the best mocking .NET framework), then you have to install this small yet useful plugin right now. It kindly generates mocks and Arg.Is / Arg.Any.
-
Dot net libraries/tools that are usefull in many projects
Another nice mocking framework is NSubstitute https://nsubstitute.github.io/
What are some alternatives?
Open XML SDK - Open XML SDK by Microsoft
Moq - Repo for managing Moq 4.x [Moved to: https://github.com/moq/moq]
EPPlus
AutoFixture - AutoFixture is an open source library for .NET designed to minimize the 'Arrange' phase of your unit tests in order to maximize maintainability. Its primary goal is to allow developers to focus on what is being tested rather than how to setup the test scenario, by making it easier to create object graphs containing test data.
NPOI - a .NET library that can read/write Office formats without Microsoft Office installed. No COM+, no interop.
FakeItEasy - The easy mocking library for .NET
ExcelDataReader - Lightweight and fast library written in C# for reading Microsoft Excel files
NUnit - NUnit Framework
MiniExcel - Fast, Low-Memory, Easy Excel .NET helper to import/export/template spreadsheet (support Linux, Mac)
Rhino Mocks
DocX - Fast and easy to use .NET library that creates or modifies Microsoft Word files without installing Word.
Bogus - :card_index: A simple fake data generator for C#, F#, and VB.NET. Based on and ported from the famed faker.js.