ClosedXML/ClosedXML
ClosedXML
ClosedXML هي مكتبة جداول بيانات .NET مفتوحة المصدر وغلاف يُستخدم لقراءة وكتابة ملفات Excel. توفر واجهة موجهة للكائنات لمعالجة هياكل المصنفات وبيانات الخلايا داخل ملفات .xlsx و.xlsm باستخدام معيار OpenXML.
تجرّد المكتبة تعقيد 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.
