Spire.XLS is a standalone software library that enables developers to create, read, write, convert, and print Excel files in any .NET-based application (C#, VB.NET, ASP.NET, .NET Core, Xamarin.iOS, MonoAndroid) without requiring Microsoft Office. It supports both legacy (.xls) and modern (.xlsx, .xlsb, .xlsm, .ods) Excel formats and provides a comprehensive object model for spreadsheet manipulation, including data import/export, advanced formatting, charting, formula calculation, pivot tables, and file conversion. The library is available in several editions, with varying feature sets and licensing options.

Key Features

Standalone .NET API Does not require Microsoft Office Excel to be installed.

• 100% managed .NET assembly
• Compatible with .NET Framework, .NET Core, .NET 5/6, MonoAndroid, Xamarin.iOS

Comprehensive Excel Format Support Supports a wide range of Excel and related formats.

• Excel 97-2003 (.xls)
• Excel 2007–2019 (.xlsx, .xlsb, .xlsm)
• OpenOffice (.ods)
• CSV, HTML, XML, images, PDF, XPS, SVG

Excel File Manipulation Full programmatic control over Excel files.

• Create, load, edit, and save workbooks
• Add, rename, delete, move worksheets
• Merge, split, and group worksheets
• Import/export data from DataTable, DataView, Array, DataGrid

Advanced Data Handling Robust tools for working with data and formulas.

• Insert, evaluate, and calculate complex formulas (including 500+ Excel functions)
• Data validation, sorting, filtering, and conditional formatting
• Find and replace, text search

Charting and Visualization Create and manipulate Excel charts and visual elements.

• Supports 70+ chart types (pie, bar, line, radar, etc.)
• Insert images, shapes, hyperlinks, and comments
• Create and manage pivot tables and slicers

Conversion and Export Convert Excel files to multiple formats with high fidelity.

• Excel to PDF, HTML, CSV, XML, text, image (PNG, JPEG, BMP, TIFF, EMF), XPS, SVG
• Print Excel files programmatically

Security and Protection Comprehensive security features for Excel documents.

• Encrypt/decrypt files, add digital signatures
• Lock/unlock worksheets, track changes, hide/unhide cells

Formatting and Layout Detailed access to all formatting options.

• Font, color, border, fill, shading, alignment, number formats
• Page setup: orientation, scaling, margins, headers/footers, print area

Performance and Scalability Optimized for speed and reliability in enterprise scenarios.

• Fast processing for large files
• No dependency on Office interop or automation

Benefits

Accelerated Development Reduces time and complexity for Excel file operations in .NET.

• Eliminates need for Microsoft Office installation
• Provides high-level APIs for common and advanced tasks

Cross-Platform Compatibility Supports a wide range of .NET environments and platforms.

• Works with ASP.NET, WinForms, WPF, .NET Core, Xamarin, Mono

Enterprise-Grade Features Suitable for business-critical and high-volume applications.

• Reliable conversion and processing
• Security and compliance features for sensitive data

Flexible Licensing and Editions Multiple editions to match project needs and budgets.

• Free edition for small-scale use (limited sheets/rows)
• Standard and Pro editions for full features and commercial deployment