C#讀取EXCEL資料

#region set connection

   string strConn = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source= "+this.txtPath.Text+";Extended Properties=Excel 8.0;";

   myDataReader = null;

  craboDbConnection = new OleDbConnection(strConn);

   OleDbCommand myOleDbCommand = new OleDbCommand("SELECT * FROM [Sheet1$]", myOleDbConnection);

   #endregion

   try

   {

    myOleDbConnection.Open();

    myDataReader = myOleDbCommand.ExecuteReader();

    while (myDataReader.Read())

    {

       this.txtSeq.Text=Convert.ToString(myDataReader.GetValue(0));//列1

this.txtName.Text=Convert.ToString(myDataReader.GetValue(1));//列2

       this.txtPIN.Text=Convert.ToString(myDataReader.GetValue(2));//列3

    }

}

   #region Catch

   catch(System.Threading.ThreadAbortException e)

    System.Threading.Thread.ResetAbort();

    this.lblResult.Text = "線程被中斷..."+e.Message;

   }

   catch(Exception ex)

    System.Windows.Forms.MessageBox.Show(ex.ToString());

   finally

    // Always call Close when done reading.

    if (myDataReader != null)

     myDataReader.Close();

    // Close the connection when done with it.

    if (craboDbConnection!=null && craboDbConnection.State == ConnectionState.Open)

     craboDbConnection.Close();

    if(webResponse!=null)

     webResponse.Close();

本文轉自蓬萊仙羽51CTO部落格，原文連結：http://blog.51cto.com/dingxiaowei/1366646，如需轉載請自行聯系原作者