Spire.XLS for .Net is a C#/VB.NET Excel component enables .NET applications to read, modify and write Excel documents without Microsoft Excel® to be installed on the Server. Spire.XLS without requiring Microsoft Excel Automation to be installed on the system. It is totally independent and not affiliated with, nor authorized, sponsored, approved by Microsoft Corporation. Quickly and easily read/write Excel files of difference formats(Excel97 ~ Excel 2010). Support chart, graphics, auto filters,data validation, VBA, Add-Ins, Macros,comment,rich text, hyperlinks, formulas, freeze, pane,group, page setup, protection, data markers, data management,etc.
Rich functions :
1) Support excel document properties
2) Saving and opening Excel files or streams
3) Creating and importing images and charts
4) Importing images and charts
5) Importing and exporting data from a designer spreadsheet
6) Data validation and data sorting
7) Freezing / unfreezing panes
8) Exporting workbooks and worksheets to HTML, CSV, Image
More details,
http://www.e-iceblue.com/Introduce/excel-for-net-introduce.html