代码错误···急 [复制链接]

for (int i = intRowStart+1; i < intRowStart + intRows; i++)
        {
            QAxObject * range1 = worksheet->querySubObject("Cells (int,int)",i,1);
            QAxObject * range2 = worksheet->querySubObject("Cells (int,int)",i,2);
            QAxObject * range3 = worksheet->querySubObject("Cells (int,int)",i,3);
            QAxObject * range4 = worksheet->querySubObject("Cells (int,int)",i,4);
            QString cell1 = range1->property("Value");
            QString cell2 = range2->property("Value");
            QString cell3 = range3->property("Value");
            QString cell4 = range4->property("Value");

            query.exec("insert into "+sheetname+"(num,student_num,name,dorm)"
                       "values ("+cell1+","+cell2+","+cell3+","+cell4+")");

            query.exec();
            }
要把一行的excel表格内容插入数据库生成一条记录，该怎么写？上面代码有误
请大家帮帮忙~~~

for (int i = intRowStart+1; i < intRowStart + intRows; i++)
        {
            QAxObject * range1 = worksheet->querySubObject("Cells (int,int)",i,1);
            QAxObject * range2 = worksheet->querySubObject("Cells (int,int)",i,2);
            QAxObject * range3 = worksheet->querySubObject("Cells (int,int)",i,3);
            QAxObject * range4 = worksheet->querySubObject("Cells (int,int)",i,4);
            QString cell1 = range1->property("Value").toString();
            QString cell2 = range2->property("Value").toString();
            QString cell3 = range3->property("Value").toString();
            QString cell4 = range4->property("Value").toString();



            qDebug() << cell1 << cell2 << cell3 << cell4 ;
            query.exec("insert into "+sheetname+" values ("+cell1+","+cell2+","+cell3+","+cell4+")");



            query.exec();
            }现在可运，可输入但写不进数据库