EPPlus
ImportExcel
EPPlus | ImportExcel | |
---|---|---|
16 | 98 | |
1,692 | 2,361 | |
0.8% | - | |
9.5 | 5.3 | |
4 days ago | 4 days ago | |
C# | PowerShell | |
GNU General Public License v3.0 or later | Apache License 2.0 |
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.
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/
ImportExcel
- Show HN: Query Your Sheets with SheetSQL
-
Is there a function similar to VLOOKUP in Excel?
Examples here that are similar to what you are trying to accomplish - https://github.com/dfinke/ImportExcel
- Automate Excel with only powershell?
-
PS Module "ImportExcel" - Output is faulty
Did you visit the GitHub repo and read the docs & examples? https://github.com/dfinke/ImportExcel
-
ImportExcel and conditional formatting inconsistancies
If you can create a reproducible example with sample data and code that re-creates the issue from nothing, post it to the project's issues on Github. The module's authors have been very quick to resolve the issues I've had, usually fixing the problem in a week or two.
- How do I ingest data from a daily CSV report into a 'main' report?
-
Create multiple tables from a single table based on a column?
If you're using scripting, I have to recommend ImportExcel for Powershell.
-
update csv cell without new export
You might be able to use https://github.com/dfinke/ImportExcel to alter single cells in a csv file but I'm not 100% sure.
-
PowerShell Export-Excel Pivot Table Issue
Have you looked at the examples? Examples
-
Powershell & MSWord: Pulling AD Information and making it look “nice”?
Maybe look at ImportExcel, it allows to put any list of objects right into Excel sheets, with insane customization capabilities.
What are some alternatives?
NPOI - a .NET library that can read/write Office formats without Microsoft Office installed. No COM+, no interop.
PSWriteHTML - PSWriteHTML is PowerShell Module to generate beautiful HTML reports, pages, emails without any knowledge of HTML, CSS or JavaScript. To get started basics PowerShell knowledge is required.
Open XML SDK - Open XML SDK by Microsoft
sqlite-utils - Python CLI utility and library for manipulating SQLite databases
ExcelDataReader - Lightweight and fast library written in C# for reading Microsoft Excel files
WinPython - A free Python-distribution for Windows platform, including prebuilt packages for Scientific Python.
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.
psPAS - PowerShell module for CyberArk Privileged Access Security REST API
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.
PoshBot - Powershell-based bot framework
Dropbox.NET - The Official Dropbox API V2 SDK for .NET
PSScriptAnalyzer - Download ScriptAnalyzer from PowerShellGallery