jinyuttt

导航

07 2011 档案

判断本机安装的excel版本
摘要:public List<string> ExcelVsion() { List<string> list=new List<string>(); List<string> lisemp = new List<string>(); List<string> listvison = new List<string>(); RegistryKey rk = Registry.LocalMachine; RegistryKey akey = rk.OpenSubKey(@"SOFTWARE\\Microsof 阅读全文

posted @ 2011-07-12 14:18 代码苦行僧 阅读(339) 评论(0) 推荐(0)

查看excel文件和导出
摘要:public System.Data.DataTable dsmdata()//查看 { public static string strCon = " Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source =d:\\csd.xls;Extended Properties=Excel 8.0"; OleDbConnection conn = new OleDbConnection(strCon); string sql = "select * from [Sheet1$]"; conn.Open(); OleD 阅读全文

posted @ 2011-07-11 20:08 代码苦行僧 阅读(715) 评论(0) 推荐(0)

查看csv文件导出csv文件c#
摘要:public DataTable ReadCSV(string pathcsv,string FileName) { OleDbConnection OleCon = new OleDbConnection(); OleDbCommand OleCmd = new OleDbCommand(); OleDbDataAdapter OleDa = new OleDbDataAdapter(); DataSet dsCsvData = new DataSet(); OleCon.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Da 阅读全文

posted @ 2011-07-11 20:02 代码苦行僧 阅读(2198) 评论(0) 推荐(0)