ClosedXML/ClosedXML
ClosedXML
ClosedXML este o bibliotecă .NET open-source pentru tabele (spreadsheets) și un wrapper utilizat pentru citirea și scrierea fișierelor Excel. Oferă o interfață orientată pe obiecte pentru manipularea structurilor de workbook și a datelor din celule în fișiere .xlsx și .xlsm, folosind standardul OpenXML.
Biblioteca abstractizează complexitatea SDK-ului OpenXML, permițând dezvoltatorilor să genereze și să modifice tabele programatic, fără a necesita instalarea Microsoft Office pe sistem.
Acoperă o gamă de capabilități de gestionare a tabelelor, inclusiv generarea de workbook-uri, încărcarea fișierelor și extragerea datelor. Setul de instrumente suportă actualizări programatice ale layout-urilor tabelelor și crearea de rapoarte formatate din datele aplicației.
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.
