DataSet ds = new DataSet(); OleDbConnection conn; OleDbCommand cmd = new OleDbCommand(); OleDbDataAdapter adapter; conn = new OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0;" + "Data Source= e:\\claimtable1.xls;" + "Extended Properties=Excel 8.0"); conn.Open(); var zz = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null); DataTable dtSheet = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null); cmd.Connection = conn; foreach (DataRow dr in dtSheet.Rows) { string sheetName = dr["TABLE_NAME"].ToString(); if (!sheetName.EndsWith("$")) continue; cmd.CommandText = "SELECT * FROM [" + sheetName + "]"; DataTable dt = new DataTable(); dt.TableName = sheetName; OleDbDataAdapter da = new OleDbDataAdapter(cmd); da.Fill(dt); ds.Tables.Add(dt); string Number = dt.Columns[1].ToString(); } cmd = null; conn.Close();
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)