using (OleDbConnection conn = new OleDbConnection(oledbConn)) { if (conn.State != Data.ConnectionState.Open) conn.Open(); OleDbCommand cmd = new OleDbCommand(); cmd.Connection = conn; // Get all Sheets in Excel File Data.DataTable dtSheet = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,null); // Loop through all Sheets to get data foreach (Data.DataRow dr in dtSheet.Rows) { sheetName = dr["TABLE_NAME"].ToString(); if (!sheetName.EndsWith("$") || sheetName.StartsWith("VSTS_Validation")) continue; // Get all rows from the Sheet cmd.CommandText = "SELECT * FROM [" + sheetName + "]"; Data.DataTable dt = new Data.DataTable(); dt.TableName = sheetName; OleDbDataAdapter da = new OleDbDataAdapter(cmd); da.Fill(dt); dsWorkitems.Tables.Add(dt); }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)