Spire.XLS is a professional Excel component which enables developers/programmers to 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 for .NET supports Excel 97-2003, Excel 2007 and Excel 2010. New Version fixed bugs of reading and writing pivot and some bugs of Formatting,Cacluating engine, formula, alignment,etc.

New Features:
1) Support powerful sorting features: sort data in both horizontal and vertical directions which allows developers to sort data from top to bottom or left to right.
2)Improved charts data preservation and pivot table for Excel 2003/2007/2010.
3)Enable to Load PageBreaks and WorksheeOptions.ShowPageBreakZoom in Excel 2003 XML file4)Enable to Write PageBreaks and ShowPageBreakZoom into Excel 2003 XML file
5)Added ZoomScaleNormal, ZoomScalePageBreakView and ZoomScalePageLayoutView in Worksheet
6)Support loading/writing ZoomScaleNormal and ZoomScalePageBreakView in Excel 2003 and Excel 2003 XML file
7)Support loading/writing ZoomScaleNormal, ZoomScalePageBreakView and ZoomScalePageLayoutView in Excel 2007/2010
8)Enable to load and write viewMode in Excel 2003

Fixed:
1)When save a Workbook with Charts as Excel 2007 or Excel 2010, the charts will be lost when open the Workbook.

Main Functions:
1) Directly Operate Excel Document
2) Import/Export data from/to Excel
3) Format Cells
4) Insert Content to Excel Document
5) Conversion. Excel to HTML, Excel to CSV, Excel to Text, Excel to Image and Excel to XML. And HTML to Excel, XML to Excel, CSV to Excel, Text to Excel.
6) Marker Designer

More details,
http://www.e-iceblue.com/Introduce/excel-for-net-introduce.html