ClosedXML

ClosedXML 0.104.2

Create and edit Excel files from .NET code

ClosedXML is an open-source .NET library for creating, reading, and editing Excel workbooks without installing Microsoft Excel. Its API lets developers populate cells, apply formatting, add formulas, and work with charts, tables, and pivot tables. It is useful for report generation, data exports, and automating spreadsheet tasks in .NET applications.

ClosedXML 0.104.2 details

Author:
License: Open Source
Price: FREE
Released:
File size: 1.20 MB
Downloads: 514
Keywords: edit excel workbook in .net, x64 software, Manuel De Leon, generate excel reports, Creator, read excel files with .net, Windows 10, create excel files with .net, Spreadsheet manipulation, OpenXML Creator, closedxml library, XML Creator, Create, GitHub, Create OpenXML, OpenXML, ClosedXML, open source excel library
Author URL: https://github.com/ClosedXML/ClosedXML
ClosedXML screenshot
ClosedXMLComponents & LibrariesWindows 11, Windows 10 32/64 bit, Windows 8 32/64 bit, Windows 7 32/64 bit

User Rating: 3.1 (7 votes)

ClosedXML Awards

Windows 10 download editor's pick

ClosedXML for Windows 10 - Full description

ClosedXML is an open-source .NET library for developers who need to create, read, or update Excel workbooks from code. It works with Excel files without requiring Microsoft Excel to be installed, making it useful in desktop applications, web services, reporting tools, and automated data-processing tasks. Instead of building spreadsheet files by assembling low-level XML parts, a developer can work with workbook, worksheet, row, column, and cell objects through a more approachable API.

The library can create workbooks and populate cells with data, or open existing files so an application can inspect and change their contents. Code can apply cell formatting, such as number formats and visual styles, to make generated reports easier to read. Formulas can be added to cells, while charts and tables provide ways to present and organize data within the workbook. Pivot-table support is also available for working with summarized spreadsheet data. These features let applications produce structured documents rather than plain exports of values.

ClosedXML also helps automate repeatable workbook tasks. An application can generate a report from database or service data, update selected cells in a user-provided workbook, or extract spreadsheet values for further processing. Because the library operates from .NET code, those operations can form part of a larger application workflow instead of relying on a person to open Excel and perform each step. The same approach suits scheduled jobs and tools that create spreadsheets on demand.

Typical uses include exporting business data, preparing formatted reports, processing existing workbooks, and adding spreadsheet output to a .NET application. Developers can use the library to handle common workbook elements through its API while keeping the surrounding application logic in their own code. Documentation and examples help with learning the object model and implementing workbook operations; familiarity with .NET development is useful for integrating it into a project.

ClosedXML is distributed as open-source software and is intended for use by .NET developers. Microsoft Excel does not need to be installed on the machine performing the file operations. The resulting workbooks are Excel files and can be opened in compatible spreadsheet applications. The provided Windows download supports Windows 10 and Windows 11, as well as older Windows releases; project requirements should be checked when selecting a .NET environment for a particular application.

ClosedXML for Windows 10 - Post your review