1、判断是否安装的是Excel2000:
RegistryKey regk = Registry.LocalMachine;
RegistryKey akey =regk .OpenSubKey(@"SOFTWARE\\Microsoft\\Office\\9.0\\Word\\InstallRoot\\"); //检查本机是否安装Office2000if(
akey !=null) { string file00 =akey .GetValue("Path").ToString(); if (File.Exists(file00 +"Excel.exe")) { ifused =true; } }
2、判断是否安装的是Excel2003:
RegistryKey regk = Registry.LocalMachine;
RegistryKey bkey =regk.OpenSubKey(@"SOFTWARE\\Microsoft\\Office\\11.0\\Word\\InstallRoot\\");
//检查本机是否安装Office2003
if (bkey !=null) { string file00 =bkey.GetValue("Path").ToString();
if (File.Exists(file03 +"Excel.exe"))
{ifused=true;} }
3、判断是否安装的是Excel2007:
RegistryKey regk = Registry.LocalMachine;
RegistryKey ckey = rk.OpenSubKey(@"SOFTWARE\\Microsoft\\Office\\12.0\\Word\\InstallRoot\\");
if (akeytwo !=null) { string file07 =ckey.GetValue("Path").ToString(); if (File.Exists(file07 +"Excel.exe")) { ifused =true; } }
4、2003或者2007下的动态拼接连接字符串:
DataSet ds =new DataSet();
string strConn=""; if(ExistsRegedit03()) { strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + strpath + ";" + "Extended Properties=Excel 8.0;"; }else if(ExistsRegedit07()) { strConn = "Provider=Microsoft.Ace.OLEDB.12.0;" + "Data Source=" + strpath + ";" + "Extended Properties=Excel 12.0;"; } OleDbConnection conn = new OleDbConnection(strConn); OleDbDataAdapter myCommand = new OleDbDataAdapter("SELECT * FROM [RelationerTable$]", strConn); myCommand.Fill(ds); DataTable dt = ds.Tables[0];