100% Standalone .NET Component - No Microsoft Office Automation
Spire.XLS for .NET is a 100% standalone Excel .NET component that allows developers to create
, manage and manipulate Excel spreadsheets without requiring Microsoft Excel or Microsoft Office to be installed on the system. In addition, Spire.XLS for .NET is a better alternative to Office Automation in terms of security, stability, scalibility, speed, price and features.
Powerful & High Quality Excel File Conversion
Spire.XLS for .NET supports converting files from Excel to PDF, Excel to HTML, Excel to CSV, Excel to Text, Excel to Image, Excel to XML and Excel to XPS. And on the other hand, most of popular files can be transferred to Excel back.
Create Excel Report from Comprehensive Workbook Designer
Spire.XLS for .NET enables developers to generate Excel workbook from scratch, or load a workbook from either folder or file stream. Developers can also save it to file, file stream or web response. Spire.XLS for .NET offers a wide range of security features including Excel encryption/decryption, cell hide/unhide, worksheet lock/unlock.
Freely Operate worksheet
Spire.XLS for .NET enables developers to create, add, delete, rename, edit and move worksheet in either C#, VB.NET or ASP.NET. Developers can also copy, transpose, and consolidate across worksheets with full contents. This professional Excel .NET class library also embeds many flexible options for displaying worksheets, such as page breaks, zoom-setting, freeze panes, headers/footers, Print excel files, print paper size and print area etc.
Easily Manipulate cells & Excel Calculation Engine at run time
Developers can easily manipulate Excel cells and Evaluate formula value in C#, VB.NET or ASP.NET at runtime. super-fast, scalable excel calculation engines available including 97-2003/2007/2010/2013 Excel compatible functions. Cell Styles are supported by this Excel .NET component, such as cell merging/unmerging, text wrapping/unwrapping, text alignment, rotation, interior, borders, lock/unlock and etc. Font formats, like setting font type, size, color, bold, italic, strikeout and underlining etc. is also fully supported. Conditional formatting, text search and replace, filter and data validation can be applied to cells as easily as you expect.
Chart, Data and other Elements
Spire.XLS for .NET provides a wide range of Chart: Pie Chart, Bar Chart, Column Chart, Line Chart, Radar Chart and etc. This Excel .NET component also supports data transportation between database and Excel in C# VB.NET or ASP.NET. Hyperlinks and templates are also supported by Spire.XLS for .NET.
||Create New Workbook
||Edit Existing Workbook
|Save to file
||Save to stream
||Save as web response
|Workbook Properties Setup
||Worksheet Print Setup
||Cells Data Copy
||Cells Styles Copy
|Data Table Import
||Data Table Export
||Formula (all 531 entries supported)
||Chart (all 74 types supported)
||Not supported in Standard Edition