ClosedXML/ClosedXML
ClosedXML
ClosedXML 是一个开源的 .NET 电子表格库和包装器，用于读取和写入 Excel 文件。它提供了一个面向对象的接口，用于使用 OpenXML 标准操作 .xlsx 和 .xlsm 文件中的工作簿结构和单元格数据。
该库抽象了 OpenXML SDK 的复杂性，允许开发者以编程方式生成和修改电子表格，而无需在系统上安装 Microsoft Office。
它涵盖了一系列电子表格管理功能，包括工作簿生成、文件加载和数据提取。该工具集支持对电子表格布局进行编程更新，并从应用数据创建格式化的报告。
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.
