C# read excel file into datatable

string sSheetName = null;
string sConnection = null;
DataTable dtTablesList = default(DataTable);
OleDbCommand oleExcelCommand = default(OleDbCommand);
OleDbDataReader oleExcelReader = default(OleDbDataReader);
OleDbConnection oleExcelConnection = default(OleDbConnection);

sConnection = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Test.xls;Extended Properties=\"Excel 12.0;HDR=No;IMEX=1\"";

oleExcelConnection = new OleDbConnection(sConnection);
oleExcelConnection.Open();

dtTablesList = oleExcelConnection.GetSchema("Tables");

if (dtTablesList.Rows.Count > 0) 
{
    sSheetName = dtTablesList.Rows[0]["TABLE_NAME"].ToString();
}

dtTablesList.Clear();
dtTablesList.Dispose();


if (!string.IsNullOrEmpty(sSheetName)) {
    oleExcelCommand = oleExcelConnection.CreateCommand();
    oleExcelCommand.CommandText = "Select * From [" + sSheetName + "]";
    oleExcelCommand.CommandType = CommandType.Text;
    oleExcelReader = oleExcelCommand.ExecuteReader();
    nOutputRow = 0;

    while (oleExcelReader.Read())
    {
    }
    oleExcelReader.Close();
}
oleExcelConnection.Close();

Source: stackoverflow.com

Similar codes

0 vote155 views1 answer
Get web api relative path
C#
0 vote144 views2 answers
While coding c# i get the error : "Duplicate 'global::System.Runtime.Versioning.TargetFrameworkAttribute' attribute [first_better_project]"
C#
0 vote139 views1 answer
Async method out parameter c#
C#
0 vote140 views2 answers
How to use K2 games Games parallax background
C#
1 vote109 views1 answer
C# conditional if
C#
3 votes144 views1 answer
Ontriggerenter
C#
17 votes105 views1 answer
Check if dictionary contains value c#
C#
2 votes224 views1 answer
Unity run void from another script
C#Unity
0 vote154 views1 answer
Join where order by .net framework
C#
1 vote191 views1 answer
How to make an object appear and disappear in unity
C#Unity