string sql_excel = "select 姓名,身份证号,性别,出生日期,手机,电话,通信地址,邮编,电子邮箱,所在院校,工作单位,批次,认证种类,拟考等级,考试科目 from opendatasource( 'microsoft.jet.oledb.4.0','data source=" + excelpath + ";user id=admin;password=;extended properties=excel 5.0')...[Sheet1$]";
SqlConnection myconn = DB.mysqlconnection();
myconn.Open();
SqlDataAdapter sda = new SqlDataAdapter(sql_excel, myconn);
DataSet ds = new DataSet();
sda.Fill(ds);
if (ds.Tables[0].Rows.Count != 0)
{
int y;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{