asp.net 读取Excel2007

    技术2026-01-11  6

                   

                    string conn = "Provider=Microsoft.Ace.OleDb.12.0;"                                + " Data Source='文件路径';"                                + "Extended Properties='Excel 12.0;HDR=YES;IMEX=1;'";                OleDbConnection objConnection = new OleDbConnection(conn);                objConnection.Open();                OleDbDataAdapter myCommandd = new OleDbDataAdapter("select * from [sheet1$]", objConnection);                DataSet ds = new DataSet();                myCommandd.Fill(ds, "[sheet1$]");                objConnection.Close();

    最新回复(0)