Open XML SDK
EPPlus
Our great sponsors
| Open XML SDK | EPPlus | |
|---|---|---|
| 23 | 16 | |
| 3,869 | 1,687 | |
| 1.6% | 2.0% | |
| 9.1 | 9.5 | |
| 6 days ago | 5 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.
Open XML SDK
-
Libcurl
While it doesn't appear to have been updated in many years, Microsoft built a similarly useful tool[1] that lets you browse the structure of a given Office document and see C# code that generates various components of it.
[1] https://github.com/dotnet/Open-XML-SDK/releases/tag/v2.5
-
Is it possible to use Microsoft Word features programatically?
If you use this check out the productivity tool, it will convert a word doc to csharp for you. https://github.com/dotnet/Open-XML-SDK/releases/tag/v2.5
-
Go library that supports extraction and generation of word documents with complex formulae, equations, tables and images.
You’re looking for OpenXML handling. C# probably has the best support, since there’s a Microsoft supported SDK - https://github.com/dotnet/Open-XML-SDK
-
If you had to pick a library from another language (Rust, JS, etc.) that isn’t currently available in Python and have it instantly converted into Python for you to use, what would it be?
https://github.com/dotnet/Open-XML-SDK Yeah, it can be kind of wrapped with pythonnet and stuff. But having it totally pyhtonized would be sooooo great.
- Creating a Web App using Excel
-
Count lines, words, and characters of a MS Word file? ( i.e. Test1.docx )
As an alternative, you could use the Powershell module Open-XML-SDK or PSwriteWord, or PSWriteOffice
-
OpenXml throws a different exception given identical code and similar build configuration for two distinct solutions. Why?
PackageLoader was introduced in https://github.com/OfficeDev/Open-XML-SDK/commit/522200f65b9182f65a112130f830403467f54936
-
Programatically replacing text in docx
In the official GitHub repository you will find similar tools listed, if you have a very particular requirement not fulfilled by OpenXML SDK.
-
Formatting issues from Mac to Windows
Or alternatively you can create a .NET application using the Open XML SDK that does the same thing.
-
Launch HN: Windmill (YC S22) – Turn scripts into internal apps and workflows
This looks amazing and I'd love to try it out for this one thing I have in mind.
I'm not familiar with the Deno part of Typescript. Would it somehow be possible to use a C# library as a dependency?
For example https://github.com/OfficeDev/Open-XML-SDK I need for a way to edit (not create) the openXML content of Microsoft Office files
EPPlus
-
Automate Excel with only powershell?
Like others, I recommend using the ImportExcel module. It uses and wraps EPPlus Software (EPPlus - Create advanced Excel spreadsheets using .NET (GitHub Project Old / New)) which is a DLL that is included with the ImportExcel PowerShell Module.
- Exporting ASPX values to an Excel Template
- Need help reading an excel file with c# epplus :)
-
EPPlus Question
Their documentation looks okay. I doubt you're going to get many people familiar with a specific library here.
-
I need a Data-Grid that I can copy/paste excel data with
If you're copypasting stuff from excel, another approach I used in a different project is this package: https://github.com/EPPlusSoftware/EPPlus - which works in Blazor. You'd just let users drag/drop or upload their excel and import it, instead of copypasting
- adding cell color in Excel file using c#
-
Kinda new to C#, could use some input.
There is one Excel Library that I would recommend using in C# and that EPPlus. Its great and its free for non-commercial use. The API is simple to use and its got great documentation.
- Exporting data to CSV
-
Does Microsoft have an official NuGet package to open and write to existing Excel Spreadsheets? (.Net 5)
There is a Getting Started section in GitHub and complete API documentation on the home page
-
Theres some way that i can make a .xlsx like this exporting data from a database using Windows Form ?
I've personally had a great experience working with EPPlus. It has both commercial and non-commercial/free licenses: https://epplussoftware.com/
What are some alternatives?
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.
NPOI - a .NET library that can read/write Office formats without Microsoft Office installed. No COM+, no interop.
EPPlus
ExcelDataReader - Lightweight and fast library written in C# for reading Microsoft Excel files
BulkPDF - BulkPDF is a free and easy to use open source software, which allows to automatically fill an existing PDF form with differen values. Only a spreadsheet (Microsoft Excel 2007/2010/2013, LibreOffice or OpenOffice Calc) with the desired values is required.
DocX - Fast and easy to use .NET library that creates or modifies Microsoft Word files without installing Word.
Dropbox.NET - The Official Dropbox API V2 SDK for .NET
NetOffice - 🌌 Create add-ins and automation code for Microsoft Office applications.
.NET-Obfuscator - Lists of .NET Obfuscator (Free, Freemium, Paid and Open Source )