1建立测试excel假定它第一排是标头,且含有价格/名称/编号字段假定工作表名为sheet1内容如下:名称价格编号A1221B2.412C583
2使用ado.net连接并读取excelusing System;using System.Collections.Generic;using System.Data.OleDb;
public class MyClass{public static void Main(){try{OleDbConnection conn=new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d://readxls.xls;Extended Properties=/"Excel 8.0;HDR=YES;/"");OleDbCommand comm=new OleDbCommand();comm.Connection=conn;conn.Open();comm.CommandText="select * from [sheet1$]";OleDbDataReader oddr=comm.ExecuteReader();while(oddr.Read()){ Console.WriteLine("名称:{0}/t编号:{1}/t价格:{2}",oddr["名称"],oddr["编号"],oddr["价格"]);}conn.Close();}catch(Exception e){Console.WriteLine(e.ToString());}finally{Console.WriteLine("end of test");Console.Read();}
}
}
运行结果:名称:A 编号:1 价格:122名称:B 编号:12 价格:2.4名称:C 编号:3 价格:58end of test
