It's not who you are underneath, it's what you do that defines you

C#判断不同版本的Excel(转)

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];

posted @ 2012-06-25 11:45  金铭杰  阅读(3858)  评论(0编辑  收藏  举报

Brick walls are there for a reason :they let us prove how badly we want things