.Net操作Excel

其实Excel的操作和sql server的操作差不多属于一致的都是用sql 语句来实现。只是会引用不同的操作类。 Excel 操作需要引入：using System.Data.OleDb; 代码： public class ExcelUtils { public static DataTable ReadExcel(string fileName, string eNodeName) { DataSet ExcelTable = new DataSet(); //Excel的连接 OleDbConnection objConn = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + fileName + ";Extended Properties=Excel 12.0;"); objConn.Open(); string strSql = "select * from [" + eNodeName + "]"; OleDbCommand objCmd = new OleDbCommand(strSql, objConn); OleDbDataAdapter myData = new OleDbDataAdapter(strSql, objConn); myData.Fill(ExcelTable, eNodeName);//填充数据 objConn.Close(); var dt = ExcelTable.Tables[0]; return dt; } public static bool InsertExcel(string fileName, string sql) { DataSet ExcelTable = new DataSet(); //Excel的连接 OleDbConnection objConn = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + fileName + ";Extended Properties=Excel 12.0;"); objConn.Open(); string strSql = sql; OleDbCommand objCmd = new OleDbCommand(strSql, objConn); return objCmd.ExecuteNonQuery() > 0; } }