[Tips] How to read Excel file in C#

If you want to read an Excel file in C#, you have several options to choose from. One of them is to use a third-party library, such as Linq-to-Excel, Bytescout.Spreadsheet or IronXL.Excel. These libraries allow you to access the data in an Excel file without using Interop or installing the Access Database Engine.

On this topic I will use very very basic to help you can do it, not need us any third party library, Let's start

Read Excel File in C# is easily do it. Here I have one function ReadExcelFile with two params:
- Path (string)
- SheetName (string)
Using OleDbConnection , OleDbCommand for read it
This function return Datatable contains row and columns values in excel

Source code

Explore My Other Channel for More Cool and Valuable Insights

👉 Youtube Learn Tech Tips

👉 Tiktok

👉 Facebook:

    
    /******************************************************
 * Author: ViLH / Zidane (huuvi168@gmail.com)
 * Last Modified: 2015-10-15
 * ***************************************************/
public static DataTable_ReadExcelFile(string path, string strSheetName)
{
    string connectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;";
    connectionString += "Data Source=" + path + ";";
    connectionString += "Extended Properties=" + "\"Excel 12.0;HDR=YES;\"";

    // string connectionString = "provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + "
    //                     ;Extended Properties=Excel 8.0;HDR=NO;"; cannot!!!
    // YES: dont read header
    // NO: read header
    // if you don't want to show the header row (first row)
    // use 'HDR=NO' in the string

    // string strSQL = "SELECT * FROM [Sheet1$]";
    string strSQL = "SELECT * FROM [" + strSheetName + "$]";

    OleDbConnection excelConnection = new OleDbConnection(connectionString);
    excelConnection.Open();             // This code will open excel file.

    OleDbCommand dbCommand = new OleDbCommand(strSQL, excelConnection);
    OleDbDataAdapter dataAdapter = new OleDbDataAdapter(dbCommand);

    // create data table
    DataTable dTable = new DataTable();
    dataAdapter.Fill(dTable);

    dTable.Dispose();
    dataAdapter.Dispose();
    dbCommand.Dispose();

    excelConnection.Close();
    excelConnection.Dispose();

    return dTable;
}

Are you interested in topic How to read Excel file in CSharp from Webzone Tech Tips? If you have any thoughts or questions, please share them in the comment section below. I would love to hear from you and chat about it

Webzone Tech Tips Zidane