How to read data from excel file using c# [duplicate]

by

There is the option to use OleDB and use the Excel sheets like datatables in a database…

Just an example…..

string con =
  @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\temp\test.xls;" + 
  @"Extended Properties="Excel 8.0;HDR=Yes;"";    
using(OleDbConnection connection = new OleDbConnection(con))
{
    connection.Open();
    OleDbCommand command = new OleDbCommand("select * from [Sheet1$]", connection); 
    using(OleDbDataReader dr = command.ExecuteReader())
    {
         while(dr.Read())
         {
             var row1Col0 = dr[0];
             Console.WriteLine(row1Col0);
         }
    }
}

This example use the Microsoft.Jet.OleDb.4.0 provider to open and read the Excel file. However, if the file is of type xlsx (from Excel 2007 and later), then you need to download the Microsoft Access Database Engine components and install it on the target machine.

The provider is called Microsoft.ACE.OLEDB.12.0;. Pay attention to the fact that there are two versions of this component, one for 32bit and one for 64bit. Choose the appropriate one for the bitness of your application and what Office version is installed (if any). There are a lot of quirks to have that driver correctly working for your application. See this question for example.

Of course you don’t need Office installed on the target machine.

While this approach has some merits, I think you should pay particular attention to the link signaled by a comment in your question Reading excel files from C#. There are some problems regarding the correct interpretation of the data types and when the length of data, present in a single excel cell, is longer than 255 characters

More Related Contents:

  1. Reading Excel files from C#
  2. How do I create an Excel (.XLS and .XLSX) file in C# without installing Microsoft Office?
  3. How to detect installed version of MS-Office?
  4. Reading excel file using OLEDB Data Provider
  5. How to read an excel file in C# without using Microsoft.Office.Interop.Excel libraries
  6. Cell color changing in Excel using C#
  7. How to read file using NPOI
  8. How to open an Excel file in C#?
  9. EPPlus number format
  10. BUG: Can’t choose dates on a DatePicker that fall outside a floating VSTO Add-In
  11. How to make correct date format when writing data to Excel
  12. Importing Excel into a DataTable Quickly
  13. How to save workbook without showing save dialog with Excel interop?
  14. Set data type like number, text and date in excel column using Microsoft.Office.Interop.Excel in c#
  15. Query excel sheet in c#
  16. Why appending AutoFilter corrupts my excel file in this example?
  17. How to import all the Excel sheets to DataSet in C#
  18. Scientific notation when importing from Excel in .Net
  19. EPPlus – LoadFromCollection – Text converted to number
  20. Accessing an open Excel Workbook in C#
  21. As of today, what is the right way to work with COM objects? [duplicate]
  22. .Net Excel Interop Deleting a worksheet
  23. Question about terminating a thread cleanly in .NET
  24. How do I concatenate two arrays in C#?
  25. How to get IntPtr from byte[] in C#
  26. How to fast get Hardware-ID in C#?
  27. TabControl with Close and Add Button
  28. One class per file rule in .NET? [closed]
  29. Task chaining (wait for the previous task to completed)
  30. Get Length of Data Available in NetworkStream

Leave a Comment