DevExpress Excel Spreadsheet API for .NET is a non-visual library for creating, loading, editing, and saving spreadsheet documents in code. It supports formulas, formatting, charts, data import and export, and workbook protection, making it suitable for reporting, data analysis, and automated document processing scenarios.
Spreadsheet Document Creation
This library creates Excel-compatible spreadsheet documents programmatically. It allows developers to generate workbooks and worksheets in code, which is useful for producing reports, structured data outputs, and dynamically generated documents.
Workbook and Worksheet Management
It manages workbook structure, including creating, renaming, copying, and deleting worksheets. Developers can organise spreadsheet content, control sheet visibility, and structure documents.
Cell Data and Formatting Control
The API writes and edits cell values and applies formatting such as fonts, colors, borders, alignment, and number formats.
Formula Calculation Engine
The library evaluates Excel-compatible formulas including mathematical, statistical, logical, text, date and time, and financial functions such as SUM, AVERAGE, IF, VLOOKUP, and CONCAT.
Charts and Visual Elements
The library creates and modifies charts within spreadsheets. Developers can define chart types, data ranges, and visual settings to represent data graphically, supporting reporting and analytical scenarios that require visual summaries.
Data Import and Export
The library imports and exports spreadsheet documents in formats such as XLS, XLSX, CSV, and TXT, and supports exporting to PDF and HTML.
Sorting, Filtering, and Data Analysis
The API applies sorting, filtering, and grouping operations to worksheet data. These capabilities help organize and analyze large datasets programmatically.
Document Protection and Security
It protects workbooks and worksheets with passwords and permissions. Developers can restrict editing, locking specific elements, and control access to spreadsheet content to meet security and compliance requirements.
Printing and Page Setup
It defines print settings such as page layout, margins, headers, and footers. Developers can prepare spreadsheets for printing directly from code, ensuring consistent output for physical or PDF-based distribution.
Product Compatibility
Review the details below to ensure this product is supported within your environment.
Component Type
.NET
.NET Version
.NET 10 LTS
.NET 9 STS
.NET 8 LTS
.NET 4.8 or earlier
.NET Platform
.NET Assembly
.NET Class
.NET MAUI
IDE Support
Rider
Visual Studio
How to Buy
DevExpress Excel Spreadsheet API for .NET is part of DevExpress Office File API. It is also available in the DevExpress Universal subscription.
DevExpress, founded in 1998 and headquartered in Glendale, California, specializes in developer-focused UI components, libraries, and frameworks designed for .NET, Blazor, ASP.NET, WPF, WinForms, JavaScript, VCL (Delphi/C++Builder), and cross-platform environments. Its extensive product portfolio includes popular offerings such as DevExtreme for JavaScript UI, powerful reporting and dashboard solutions, CodeRush productivity extensions, and frameworks like XAF for rapid app development. DevExpress is known for delivering frequent updates, strong accessibility features, and a consistent developer experience, helping IT professionals build responsive, high-performance desktop, web, and mobile applications for a wide range of platforms.