C操作EXCEL全解代码.docVIP

C#操作EXCEL全解（代码） 提示：运行之前必须先引用Interop.Excel.dll模块 using System; using System.Collections.Generic; using System.Text; using System.Data; using System.Data.OleDb; using System.Windows.Forms; using System.Reflection; using Excel; namespace AnalysisSystem.DB { public class ExcelOperation { private string _fileName;//保存路径名 public ExcelOperation(string fileName) { _fileName = fileName; } private OleDbConnection GetConnection() { string connectString = string.Format(Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties=Excel 8.0,_fileName); OleDbConnection myConn = new OleDbConnection(connectString);//建立链接 return myConn; } public System.Data.DataTable ExecuteTableResult(string strSql) { System.Data.DataTable dt = new System.Data.DataTable(); try { OleDbConnection conn = this.GetConnection(); OleDbDataAdapter da = new OleDbDataAdapter(strSql, conn);//执行相关SQL语句 da.Fill(dt); } catch (System.Exception ex) { //do nothing } return dt; } public DataSet ExecuteSetResult(string strSql,string table_name) { DataSet ds = new DataSet(); string temp_name = [ + table_name + $]; try { OleDbConnection conn = this.GetConnection(); OleDbDataAdapter da = new OleDbDataAdapter(strSql, conn); da.Fill(ds,temp_name); } catch (System.Exception ex) { //do nothing } return ds; } public string ExecuteOneResult(string strSql) { string result = ; System.Data.DataTable dt = new System.Data.DataTable(); try { OleDbConnection conn =