Few months back , I was making an R&D on the possibilities of reading and writing to/from the Excel file from .NET (C#) . At that point of time , I came across various libraries and SDK’s available for Reading and Writing from Excel File in C# .
In this blog post ,I will list some of the libraries used for reading and writing from/to Excel sheet using C#. Note that some of the libraries are free/open source and few are commercial one’s.
7 Libraries for Reading and Writing from Excel File in C#
1. TMS Flexcel Studio for .NET
TMS Flexcel Studio for .NET is a complete managed engine to manipulate Excel file and lets the developers to generate Excel file from various .NET applications like WinForms , ASP.NET , PocketPC etc.
The TMS Flexcel Studio for .NET also lets the developers to read , create and update Excel file without the need of Microsoft Office being installed on the PC.
Know more about TMS Flexcel Studio for .NET here
2. GemBox Spreadsheet
GemBox.Spreadsheet is a .NET component that allows the developers to read, write, convert and print spreadsheet files (XLSX, XLS, ODS, CSV, HTML, PDF or XPS) from the .NET Application quickly.
The GemBox Spreadsheet comes in 2 versions – Free version and Commercial Version.
Know more about GemBox Spreadsheet here
3. Open XML SDK 2.0 for Microsoft Office
I have been using Open XML SDK 2.0 for Microsoft Office for quite some time 🙂
Open XML SDK 2.0 for Microsoft Office is built on top of System.IO.Packaging API and also includes strongly typed classes for manipulating the Open XML documents.
One of the cool features of the Open XML SDK 2.0 for Microsoft Office is that you can use the LINQ to access the XML content .
Know more about Open XML SDK 2.0 for Microsoft Office and download from Microsoft Download Center
4. Aspose.Total for .NET (Aspose.Cells for .NET)
Aspose.Cells for .NET is a Excel spreadsheet component for .NET developers that allows to manipulate Excel sheet as well as convert it to other formats like Html , PDF , Image etc.
Know more about Aspose.Total for .NET (Aspose.Cells for .NET) here
5. Infragistics Excel
Infragistics Excel is a .NET component from Infragistics for manipulating Excel sheet from .NET Application. It is a 1005 Managed code .
Know more about Infragistics Excel here
6. OfficeWriter API for Word and Excel
The OfficeWriter API is a .NET library that allows the developers to create , read and write from Excel/Word document from the .NET Application.
Know more about OfficeWriter API for Word and Excel here
7. SpreadsheetGear
SpreadsheetGear is a powerful Microsoft Excel compatible spreadsheet component and support the ASP.NET, Windows Forms, WPF and Silverlight where the developers build some cool applications with the functionalities like Excel reporting , dashboards etc.
Know more about SpreadsheetGear here
If you are working on any the libraries which is not listed above and want to be included in the above list ,Feel free to add them in the comments section.
12 Comments
Thanks for Marc for adding epplus to the list and the feedback …
You have picked the best libraries available for developers to use and i use Aspose.Cells for .NET and regularly follow their blog for new updates.
Elerium Excel .NET is another good component with reasonable price which allows to create/edit excel files. Developers can easily add functionality of creating/reading/writing Excel files (XLS, XLSX, CSV) in .NET project without a need to install MS Office on the machine.
More information can be found here
You can create nicely formatted excel files base on template excel files with this library: http://officehelper.codeplex.com/
Can someone please let me know which one among the listed libraries can be used to create excel sheets that opens in different platforms like Android, Windows Phone OS, IOS 6 and 7.
I tried using SpreadsheetLight library for generating excel sheet, but the generated excel sheet did not open in IOS 7. Please help me in this regard.
I’m also looking for library with Free license.
Nice tool. It works fine here.
Thanks Graham for the info.
Another component for .NET is EasyXLS:
The component can be used to read, write, edit or convert Excel files.
Hi,
Can anyone here guide me on how to generate excel file on C#?
Hi Ade ,
Use the OpenXML libarary for C#.
Thanks for share with us. But i try zetexcel.com and i found this useful and easy
Thanks Mark. I will definitely add them to the list 🙂