采用数据库连接方式
sProviderStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + EXCEL_FILENAME + ";Extended Properties=Excel 8.0" ;cmdExcel.Parameters.Add("@路由",OleDbType.LongVarChar,0,"路由");
sProviderStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + EXCEL_FILENAME + ";Extended Properties=Excel 8.0" ;cmdExcel.Parameters.Add("@路由",OleDbType.LongVarChar,0,"路由");
oleDbConnection.Open();
DataTable schemaTable = oleDbConnection.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, null); //DataTable schemaTable = oleDbConnection.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, new object[] {null, null, null, "TABLE"});
DataSet ds = new DataSet();
for(int i = 0 ; i < schemaTable.Rows.Count ; i ++){
string sql = "SELECT * FROM [" + schemaTable.Rows[i]["TABLE_NAME"].ToString() +"]";
System.Data.OleDb.OleDbDataAdapter ada = new System.Data.OleDb.OleDbDataAdapter(sql, oleDbConnection);
ada.Fill(ds, "[" + schemaTable.Rows[i]["TABLE_NAME"].ToString() +"]");
}
问题,现在才发现,不知是什么原因
这篇文章,这里有详细的说明,如果是单机版,这中方案可以
http://support.microsoft.com/kb/189897/EN-US/