ClosedXML/ClosedXML
ClosedXML
ClosedXML est une bibliothèque de tableur .NET open-source et un wrapper utilisé pour lire et écrire des fichiers Excel. Il fournit une interface orientée objet pour manipuler les structures de classeurs et les données de cellules au sein des fichiers .xlsx et .xlsm en utilisant le standard OpenXML.
La bibliothèque abstrait la complexité du SDK OpenXML, permettant aux développeurs de générer et de modifier des feuilles de calcul par programmation sans nécessiter l'installation de Microsoft Office sur le système.
Elle couvre une gamme de capacités de gestion de feuilles de calcul, incluant la génération de classeurs, le chargement de fichiers et l'extraction de données. L'ensemble d'outils prend en charge les mises à jour programmatiques des mises en page de feuilles de calcul et la création de rapports formatés à partir des données d'application.
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.
