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

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

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.

Share:

    12 Comments

  1. February 22, 2013
    Reply

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

  2. Celena
    October 14, 2013
    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.

  3. Donald Green
    November 25, 2013
    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

  4. Aron Sinoai
    February 13, 2014
    Reply

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

  5. SP
    March 20, 2014
    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.

  6. Ronaldo Plovas
    September 11, 2014
    Reply

    Nice tool. It works fine here.

  7. March 27, 2016
    Reply

    Thanks Graham for the info.

  8. Flish
    January 19, 2017
    Reply

    Another component for .NET is EasyXLS:

    The component can be used to read, write, edit or convert Excel files.

  9. Ade Ogun
    September 13, 2018
    Reply

    Hi,
    Can anyone here guide me on how to generate excel file on C#?

  10. User Avatar
    July 23, 2020
    Reply

    Hi Ade ,

    Use the OpenXML libarary for C#.

  11. August 10, 2020
    Reply

    Thanks for share with us. But i try zetexcel.com and i found this useful and easy

  12. User Avatar
    August 10, 2020
    Reply

    Thanks Mark. I will definitely add them to the list 🙂

Leave a Reply

You May Also Like

This C# program calculates and displays an upper triangular matrix based on user input. Problem Statement: The program takes the...
This C# program serves as a demonstration of bitwise operators, which are fundamental operators used for manipulating individual bits in...
This C# program is designed to interchange or swap the columns of a matrix. A matrix is a two-dimensional array...