Excel数据读取

/*1.连接Excel*/
string fileName = "装备信息";
string connte = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + fileName + ";" + ";Extended Properties=\"Excel 8.0;HDR=YES;IMEX=1\"";
OleDbConnection connection=new OleDbConnection(connte);
connection.Open();//打开连接
/*2.查询数据*/
string sql = "select * from [Sheet1$]";//一个查询命令
OleDbDataAdapter adapter=new OleDbDataAdapter(sql,connection);//数据接受者
DataSet set=new DataSet();//存放数据
adapter.Fill(set);//把数据填充到存放处
connection.Close();
/*3.处理数据*/
DataTableCollection table = set.Tables;//获得Excel数据每一张表格
DataRowCollection rows = table[0].Rows;//获得表格的每一行数据
foreach (DataRow res in rows)
{
    for(int i=0;i<8;i++)
        Console.Write(res[i]+" ");
    Console.WriteLine();
}