using System.Data.OleDb;

二、连接到Excel文件

string strConn = "Provider=Microsoft.Ace.OleDb.12.0;" +
                "data source=" + textFile.Text + ";Extended Properties=‘Excel 12.0; HDR=NO; IMEX=1‘";

OleDbConnection conn = new OleDbConnection(strConn);
conn.Open();

DataSet ds = new DataSet();
OleDbDataAdapter odda = new OleDbDataAdapter("SELECT * FROM [标签规划表$]", conn);
odda.Fill(ds);

int iRowCount = ds.Tables[0].Rows.Count;
for (int i = 2; i < iRowCount; ++i)
{
  string sPTN = ds.Tables[0].Rows[i][7].ToString();
  if (sPTN.Length <= 0)
  {
    continue;
  }
}