C# 操作EXCEL

连接Excel，connection是通用的

string filename = @"E:\新建 Microsoft Excel 工作表.xlsx";
string connetion="Provider=Microsoft.Jet.OLEDB.4.0;"+"Data Source="+filename+";"+";Extended Properties=\"Excel 8.0;HDR=YES;IMEX=1\"";

OleDbConnection OleConnetion = new OleDbConnection(connetion);//OleDbConnection也可以连接数据库,使用的是sql语句
OleConnetion.Open();//连接EXCEL

完整代码，查询

static void Main(string[] args)
        {
            try
            {
                string filename = @"E:\新建 Microsoft Excel 工作表.xlsx";
                string connetion="Provider=Microsoft.Jet.OLEDB.4.0;"+"Data Source="+filename+";"+";Extended Properties=\"Excel 8.0;HDR=YES;IMEX=1\"";

                OleDbConnection OleConnetion = new OleDbConnection(connetion);//OleDbConnection也可以连接数据库,使用的是sql语句
                OleConnetion.Open();//连接EXCEL

                string sql = "select * from [Sheet1$]";

                OleDbDataAdapter oleDbData = new OleDbDataAdapter(sql,OleConnetion);//查询数据

                DataSet excelData = new DataSet();//数据结合
                oleDbData.Fill(excelData);

                OleConnetion.Close();//关闭
            }
            catch (Exception e)
            {
                Console.WriteLine(e);
            }

        }