7 Libraries for Reading and Writing from/to Excel File in C#

by Ginktage | Wednesday, Feb 20, 2013 | 935 views

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.

If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.
Like it? Share it!

9 Comments so far. Feel free to join this conversation.

  1. Marc February 22, 2013 at 4:08 am - Reply

    Good article, but I’m noticing a lack of details on pricing/licensing.

    An open source solution that is not mentioned here but is freely available and works quite well is http://epplus.codeplex.com/. A recent update includes conditional formatting (which is recent addition).

    Works rather well for generating spreadsheets and also allows you to format the page for those silly users.

    • Senthil Kumar February 22, 2013 at 10:42 pm - Reply

      Thanks for Marc for adding epplus to the list and the feedback …

    • Ronaldo Plovas September 11, 2014 at 10:48 pm - Reply

      Nice tool. It works fine here.

  2. Navin August 30, 2013 at 5:06 pm - Reply

    ClosedXML is also very useful and free
    find it here http://closedxml.codeplex.com/

  3. Celena October 14, 2013 at 2:13 pm - Reply

    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.

  4. Donald Green November 25, 2013 at 10:15 am - Reply

    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

  5. Aron Sinoai February 13, 2014 at 2:44 am - Reply

    You can create nicely formatted excel files base on template excel files with this library: http://officehelper.codeplex.com/

  6. SP March 20, 2014 at 11:35 am - Reply

    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.

Leave A Response