Open Source .NET Library for Handling Excel Spreadsheets
Free .NET Library that enables software developers to Read, Write & Manipulate Excel XLSX Spreadsheets with ease.
Simplexcel is an Open source .NET library that provides functionality for working with Excel XLSX spreadsheet via .NET. The library mainly focuses on the most common features and tasks that can help the developer to create a spreadsheet. The library has provided complete support for ASP.NET and Windows Services.
The open source Simplexcel library gives software to generate Excel 2007+ workbooks in their native XLSX format without relying on COM interop. The library has included support for several important features relate to Excel XLSX creation and manipulation, such as creating Excel workbook, Add sheets to a workbook, reading Excel documents, create new cells, add cell ranges, format cells, add and manage rows, create Hyperlinks for a cell, specify compression level, save the file to a Stream and many more.
At A Glance
An overview of Simplexcel features.
- Read XLSX
- Write XLSX
- Add images
- Add comments
- Cell ranges
- Add rows
- Manage tables
- Excel encryption
- Formula calculation
Simplexcel only requires .NET Framework 4.5 or higher and .NET Core 2.0.
Getting Started with Simplexcel
The recommended way to install Simplexcel is from Nuget. Please use the following command for a smooth installation.
Install Simplexcel from NuGet
Create Excel Workbook via .NET API
The Simplexcel library enables C# .NET programmers to generate an Excel spreadsheet inside their own .NET apps. You can easily create a workbook and add worksheets, assign a name to it with a couple of lines of .NET code. You can also populate its cells, and add them to a new Workbook with ease. It also supports setting font type and text size for a created sheet.
Create Hyperlinks to an Excel Cell
The open source Simplexcel library has provided the capability to create hyperlinks inside an Excel worksheet cell with ease using C# .NET commands. You can easily set your desired format for the hyperlinks. Developers can easily set formatting like bold or font size or border for their worksheet cells.
Add Page Setup Properties for a Worksheet
The open source Simplexcel library enables software developers to set and apply page setup properties for a Worksheet inside their own .NET applications. Page set-up settings affect the way the users see a worksheet. It controls the worksheet features like paper size, page orientation, page headers and margins, and gridlines.
Freeze Panes in a worksheet
The open source Simplexcel library has provided the capability for freezing panes in a worksheet using couple C# .NET commands. Freeze panes is a very useful feature while working on multiple worksheets, You can keep an area of a worksheet visible while you scroll to another area of the worksheet. At the moment, it is being kept simple; you can either freeze the first row or the leftmost column (A) of a worksheet.