JanKallman/EPPlusArchived
EPPlus
EPPlus is a .NET library designed for programmatically creating, manipulating, and styling Excel files using the Open XML format. It functions as an office file manipulator and spreadsheet processor that allows for the generation and modification of workbooks without requiring the local installation of office productivity software.
The library enables the creation of complex workbooks featuring charts, pivot tables, and conditional formatting for automated reporting. It includes an internal calculation engine to execute embedded formulas and spreadsheet logic, and provides security features such as workbook encryption and access restrictions.
The toolkit covers a broad range of spreadsheet management capabilities, including cell-level styling, data validation rules, and the insertion of visual elements like pictures and shapes. It also manages structural organization through the manipulation of tables and comments.
Features
- Excel Spreadsheet Management - Provides full lifecycle management for programmatically creating and editing Excel spreadsheet files.
- Spreadsheet Manipulation Libraries - Provides a comprehensive library for programmatically creating, reading, and manipulating Excel spreadsheet files.
- Office Document Manipulation - Allows for the programmatic modification of the internal structure of existing office spreadsheet files.
- Office-Independent File Processing - Provides the ability to read and write Excel files without needing Microsoft Office installed on the machine.
- Open XML Libraries - Provides programmatic interfaces for creating and manipulating documents using the Open XML standard.
- In-Memory Object Models - Maintains a complete representation of the workbook structure in memory for fast programmatic modification.
- Excel Processing Libraries - Serves as a .NET library for the programmatic reading and writing of XLSX and CSV files.
- Spreadsheet Formula Engines - Includes an internal engine for evaluating mathematical and logical expressions within spreadsheet cells.
- Financial Report Generators - Generates data-driven financial reports utilizing pivot tables, charts, and conditional formatting.
- Stream-Based Serialization - Uses stream-based serialization to minimize memory overhead when saving large spreadsheets.
- Spreadsheet Visualizations - Enables the embedding of charts, pictures, and shapes directly into spreadsheet documents for data visualization.
- Structured Spreadsheet Tables - Provides capabilities to create and manipulate named tables with typed columns and ranges within spreadsheets.
- Excel Automation - Automates the creation of complex workbooks featuring native charts, pivot tables, and formatting.
- Spreadsheet Data Validation - Defines input rules and restrictions to ensure data integrity from end users in spreadsheet cells.
- Spreadsheet Cell Styling - Applies visual attributes like borders, colors, and fonts to specific cell ranges via XML definitions.
- Conditional Formatting - Changes the visual appearance of cells based on predefined rules or data values.
