Spire.XLS is a professional Excel component which enables developers/programmers fast generate, read, write and modify Excel document for .NET and Silverlight. Spire.XLS doesn't need Microsoft Office Excel Automation. It allows user to operate Excel document directly such as save to stream, save as web response, copy, lock/unlock worksheet, set up workbook properties, etc. As a professional .NET Excel component, it owns the ability of inserting content into Excel document, formatting cells and converting Excel documents to popular office file formats. Spire.XLS supports Excel 97-2003, Excel 2007 and Excel 2010.
Directly Operate Excel Document - for both .NET and Silverlight
Without Microsoft Excel installed on system, users can use Spire.XLS to create new workbook, edit exist worksheet, save to stream/web response, set up properties, worksheet print set up, cells merge, copy, etc. Furthermore, Spire.XLS also enables users to lock or unlock worksheet.
Import/Export - for both .NET and Silverlight
Spire.XLS supports importing data from datatable to spreadsheet and exporting data from spreadsheet to datatable.
Format Cells - for both .NET and Silverlight
Spire.XLS has powerful functions on cells formatting. It allows you to Format number, Text Alignment, Font, Cell Border, Cell Fill, Cell Protection, Interior, etc.
Insert Content to Excel Document - - for both .NET and Silverlight
Besides formatting cells, Spire.XLS can help you insert content to Excel document. You can insert Formula (all 531 entries supported), Chart (all 74 types supported), insert Image, Insert Pivot Table, insert RichText, insert Hyperlink, insert Comments, and insert VBA.
Conversion - for any .NET
Spire.XLS supports converting files from Excel to HTML, Excel to CSV, Excel to Text, Excel to Image and Excel to XML. And on the other hand, most of popular files can be transferred to Excel. Spire.XLS for .NET can transfer HTML to Excel, XML to Excel, CSV to Excel, Text to Excel and insert images into Excel.
Marker Designer - for both .NET and Silverlight
Marker designer including Template, Auto Populate, Style Copy and Variables are also available for Spire.XLS