ClosedXML/ClosedXML
ClosedXML
ClosedXML es una biblioteca de hojas de cálculo .NET de código abierto utilizada para leer y escribir archivos de Excel. Proporciona una interfaz orientada a objetos para manipular estructuras de libros de trabajo y datos de celdas dentro de archivos .xlsx y .xlsm utilizando el estándar OpenXML.
La biblioteca abstrae la complejidad del SDK de OpenXML, permitiendo a los desarrolladores generar y modificar hojas de cálculo programáticamente sin requerir que Microsoft Office esté instalado en el sistema.
Cubre una gama de capacidades de gestión de hojas de cálculo, incluyendo la generación de libros de trabajo, carga de archivos y extracción de datos. El conjunto de herramientas admite actualizaciones programáticas de diseños de hojas de cálculo y la creación de informes formateados a partir de datos de la aplicación.
Features
- Excel Automation - Provides comprehensive tools for programmatically generating and modifying Excel spreadsheet files without requiring Microsoft Office.
- OpenXML Spreadsheet Writers - Uses the official Microsoft OpenXML SDK as the underlying engine to read and write Excel files.
- Automated Spreadsheet Report Generators - Enables the programmatic generation of formatted Excel reports from application data.
- Excel Spreadsheet Management - Offers a simplified interface for modifying spreadsheet content, layouts, and cell structures.
- Workbook Lifecycle Management - Enables the creation of new workbooks and the definition of their structural organization.
- Spreadsheet Data Extractors - Provides utilities for reading and extracting data from specific cell ranges and worksheets.
- XLSX Read and Write Support - Provides full lifecycle support for reading from and writing to XLSX spreadsheet files.
- Excel File Parsers - Provides a set of tools for reading and writing to modify workbook structures and cell data.
- Excel Processing Libraries - Serves as a dedicated .NET library for the programmatic reading and writing of Excel files.
- OOXML Specifications - Implements mappings between C# objects and the Open XML spreadsheet standard to ensure file compatibility.
- Cell State Tracking - Tracks changes to cells and styles in memory to ensure consistency when updating the compressed XML package.
- Object-Oriented API Wrappers - Provides an object-oriented wrapper around the complex OpenXML SDK for a more intuitive developer experience.
- Spreadsheet Abstractions - Acts as an abstraction layer that decouples high-level spreadsheet operations from the underlying OpenXML SDK.
- Spreadsheet Document Models - Provides an in-memory structured representation of spreadsheet workbooks, sheets, and cells for programmatic manipulation.
- Office Automation - Library for creating and editing Excel 2007/2010 files.
