asp.net中导入excel表

比较懒惰,就没写
Excel.Workbook workbook = excel.Workbooks.Open(strFilePath,
//     Type.Missing, Type.Missing, Type.Missing, Type.Missing,
//     Type.Missing, Type.Missing, Type.Missing, Type.Missing,
//     Type.Missing, Type.Missing, Type.Missing, Type.Missing,
//     Type.Missing, Type.Missing);
//
//    Excel.Worksheet sheet = workbook.Worksheets[0] as Excel.Worksheet;
//    Response.Write(sheet.get_Range("C1", null).Value2.ToString());
//    Response.Write(sheet.get_Range("C2", null).Value2.ToString());
//    Response.Write(sheet.get_Range("C5", null).Value2.ToString());
//
//    return true;
这种方法,毕竟要更改分布式com配置起来比较繁

不如这样
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;"
     +"Data Source=" + @strFilePath + ";"
     +"Extended Properties='Excel 8.0; HDR=NO;IMEX=1;'";
    OleDbConnection conn = new OleDbConnection(strConn);
    OleDbCommand comm = new OleDbCommand("SELECT * FROM [SystemParameters$]", conn);
    OleDbDataAdapter da = new OleDbDataAdapter(comm);
    DataSet ds = new DataSet();
    da.Fill(ds);
    if (ds.Tables.Count > 0)
    {
     this.DataGrid1.DataSource = ds;
     this.DataGrid1.DataBind();
     return true;
    }
    else
     return false;
(感谢一下http://download.cnblogs.com/zyc2/archive/2005/06/28/182492.html?Pending=true#Post,指点迷津
补充一下,如果还有什么问题,参考一下M$的文档http://support.microsoft.com/kb/194124/)