C# 从Excel 读数据

引用命名空间
using System.Data.OleDb;
using System.Data;

主体程式

public partial class Test : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        // 定义数据源
        string vExcelSourcePath = "E:\\RERP2010\\Template\\TestData.xls";

        // 连接Excel,並開啓連接
        string vConnecitonStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + vExcelSourcePath + ";
                                             Extended Properties='Excel 8.0;HDR=Yes;IMEX=1';";
        OleDbConnection conn = new OleDbConnection(vConnecitonStr);
        conn.Open();

        // 把Excel資料載入到DataSet
        DataSet ds = new DataSet();
        OleDbDataAdapter oad = new OleDbDataAdapter("select * from [Sheet1$]", conn);
        oad.Fill(ds);
    }
}