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
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.