求助~急 [复制链接]

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



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

[pre] query.exec();[/pre][pre] }[/pre][pre]
[/pre][pre]上面代码有误，怎么把一行一行的数据插入形成一条条记录呢，请大家帮帮忙吧，急[/pre]

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();
            }现在可运，可输入但写不进数据库

已解决