Get data from EXCEL using C# and OLEDB part 3

Published: 19 February 2021
on channel: Ammar Sharshara

1,140

//create ole connection
System.Data.OleDb.OleDbConnection conn
= new System.Data.OleDb.OleDbConnection(@"Provider = Microsoft.ACE.OLEDB.12.0; Data Source = 'd:\1.xlsx'; " +
"Extended Properties = 'Excel 12.0 Xml;HDR=YES'");
//get table name
conn.Open();
System.Data.DataTable dt = conn.GetOleDbSchemaTable(
System.Data.OleDb.OleDbSchemaGuid.Tables, null);
conn.Close();
///get excel data
System.Data.OleDb.OleDbDataAdapter da = new System.Data.OleDb.OleDbDataAdapter
("select * from ["+dt.Rows[0]["Table_Name"]+"]", conn);

System.Data.DataTable dt2 = new System.Data.DataTable();

//fill data table using data adapter

da.Fill(dt2);
//
MessageBox.Show(dt2.Rows[0][0].ToString());
Microsoft Visual Studio Professional 2019
#sql #microsoft #net #visualstudio
#WPF #csharp #android #xamarin

Watch video Get data from EXCEL using C# and OLEDB part 3 online without registration, duration hours minute second in high quality. This video was added by user Ammar Sharshara 19 February 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 1,140 once and liked it 12 people.