EPPlus
Create advanced Excel 2007/2010 spreadsheets on the server
EPPlus is a .net library that reads and writes Excel 2007/2010 files using the Open Office Xml format (xlsx).
Home Page:
http://epplus.codeplex.com/
NPOI
This project is the .NET version of POI Java project at http://poi.apache.org/. POI is an open source project which can help you read/write xls, doc, ppt files. It has a wide application.
For example, you can use it to
a. generate a Excel report without Microsoft Office suite installed on your server and more efficient than call Microsoft Excel ActiveX at background;
b. extract text from Office documents to help you implement full-text indexing feature (most of time this feature is used to create search engines).
c. extract images from Office documents
d. generate Excel sheets that contains formulas
Home Page:
http://npoi.codeplex.com/
ExcelLite
ExcelLite is a C#/Silverlight library for Silverlight applications that can read and write MS Excel ( Excel 97-2003) files without COM interaction. You can manipulate MS Excel files totally on client side as this library is using Binary excel format to read and write data.
So you don’t need to force your client to install Silverlight application “out of browser”, also COM interaction is not required with office DDLS.
Home Page:
http://excellite.codeplex.com/
Excel Library
The aim of this project is provide a native .NET solution to create, read and modify Excel files without using COM interop or OLEDB connection.
Currently .xls (BIFF8) format is implemented. In future .xlsx (Excel 2007) may also be supported.
Home Page:
http://code.google.com/p/excellibrary/http://nuget.org/packages/ExcelLibrary
ClosedXML – The easy way to OpenXML
ClosedXML makes it easier for developers to create Excel 2007/2010 files. It provides a nice object oriented way to manipulate the files (similar to VBA) without dealing with the hassles of XML Documents. It can be used by any .NET language like C# and Visual Basic (VB).
Home Page:
http://closedxml.codeplex.com/
ExcelPackage: Office Open XML Format file creation
ExcelPackage provides server-side generation of Excel 2007 spreadsheets.
It is a set of classes and wrappers around the .NET 3.0 System.IO.Packaging API and the new Office Open XML file format. It extracts away the complexity of dealing with the individual XML components making it real easy to create sophisticated spreadsheets on the server.
Home Page:
http://excelpackage.codeplex.com/
Excel Jetcell .NET
Excel Jetcell .NET is a professional, scalable & feature rich .NET component that allows developers to add the ability to create, generate, read and write Excel Spreadsheet files ( XLSX , XLS , CSV ) into ASP.NET applications or website projects (C#, VB.NET).
Home Page:
http://www.devtriogroup.com/exceljetcell/default.aspx
TMS Flexcel Studio for .NET
100% managed code Excel file manipulation engine & Excel & PDF report generation for .NET & .NET Compact Framework
Functions:
Generates Excel files from WinForms, WebForms ASP.NET, PocketPC applications, webservices on the fly and fast with FlexCel Studio for .NET
Native .NET components (no additional OLE/dlls required) allowing to read, create and modify native Excel .XLS and .XLSX files without needing to have Excel installed.
Supported Excel 95 .XLS file format and Excel 2007/2010 .XLSX format
Native PDF file export
Exceptionally fast and solid hand tuned .XLS & .XLSX engine capable of generating thousands files per minute.
Able to modify .XLS files and keep almost everything existing on the original file, from macros to activex objects.
Recalculation of more than 200 Excel functions.
Ability to read and write encrypted .XLS files.
Completely written in C# 100% managed code, with NO interop and NO p/invokes!
Runs on .NET 2.0, .NET 3.0, .NET 3.5, .NET 4.0, Mono and the .NET Compact Framework (xlsx support requires .NET 3.5).
Templates can be stored inside your executable file, in a database or in any place from where you can access it as a stream.
Extensive API is available with which you can programmatically write and read files, with formatting info, images comments, etc.
Export to HTML in HTML 4.01 strict or XTHML 1.1 and fully standards compliant
Report Engine that allows to create complex reports using Excel as your report designer, so your final users can modify them. You can use images/comments/conditional formats/merged cells/pivot tables/charts and almost anything you can think of on those reports.
Home Page:
http://www.tmssoftware.com/site/flexcelnet.asp
================================================
Exploring the World 