QXmlStream and QTableWidget read and write xml file

behruz montazeri

I want the reverse functionality to read the file and add to QTableWidget i tried but i couln't :

    QFile file( "/home/behruz/Qt/TestPro/my.xml" );
    if( !file.open( QFile::ReadOnly | QFile::Text ) ) {
        // print error cannot open
    }
    QXmlStreamReader reader;
    reader.setDevice( &file );
    reader.readNext();

    if (reader.readNextStartElement()) {
        if (reader.name() == "words"){
            while(reader.readNextStartElement()){
                if(reader.name() == "col1"){
                    QString s = reader.readElementText();
                    qDebug(qPrintable(s));
                }
            }
        }
    }

JonB

@behruz-montazeri
Compare your code here line for line against your code above for outputting the XML.

writer.writeAttribute(QStringLiteral("text"),ui->tableWidget->model()->index(i,j).data().toString());

shows you are storing text as an attribute (text="item1").

That does not pair with your

QString s = reader.readElementText();

which will be the text inside each element, where you store nothing....

behruz montazeri

    QFile file("/home/behruz/Qt/TestPro/my.xml");
    if (file.open(QIODevice::ReadOnly)) {
        QXmlStreamReader reader(file.readAll());
        file.close();
        while(!reader.atEnd()) {
            reader.readNext();
            if (reader.isStartElement()) {
                if (reader.name() == "words") {
                    reader.readNextStartElement();
                    if(reader.name() == "row"){
                        reader.readNextStartElement();

                        foreach(const QXmlStreamAttribute &attr, reader.attributes()) {
                            if (attr.name().toString() == QLatin1String("text")) {
                                QString attribute_value = attr.value().toString();
                                qDebug(qPrintable(attribute_value));
                            }
                        }
                    }
                }
            }
        }
    }

It only shows the item 1 how populate it in QTableWidget ?

JonB

@behruz-montazeri
Again, compare your reader against the writer code you have. That loops round every row, doesn't it? But your reader only has an if (reader.name() == "words"). Plus I don't see anything looping over the <col...> elements at all. And you say it only shows the first item (first row & column). Do you think that could be related to no loops?

I'm not going to write it for you. You need to look up the docs and read the necessary elements in the necessary loops. You're headed in the right direction, just think about where your code needs to loop and read what to get back to what you had for the writing code.

behruz montazeri

@JonB
What's the loop statement ? I know it needs a loop but i can't find where and how.

JonB

@behruz-montazeri
Loop statements are for, while, foreach. The writer used fors because it knew how many rows & columns there were. You'll probably want whiles in the reader, certainly to move through all the <row> elements.

behruz montazeri

@JonB
I already used a loop :

foreach(const QXmlStreamAttribute &attr, reader.attributes()) {
                        if (attr.name().toString() == QLatin1String("text")) {
                            stList.append( attr.value().toString());
                            qDebug() << stList;
                        }

But it seems it only works for one record. Give me the code or a real hint. Thanks.

VRonin

@behruz-montazeri said in QXmlStream and QTableWidget read and write xml file:

QXmlStreamReader reader(file.readAll());

??? This makes no sense, it should be QXmlStreamReader reader(&file); I guess

behruz montazeri

I corrected reading by using two loops.

 QStringList stList;

    QFile file("/home/behruz/Desktop/Temp/QTableWidgetXml/my.xml");
    if( !file.open( QFile::ReadOnly | QFile::Text ) ) {
        // print error cannot open
    }
    QXmlStreamReader reader(&file);

    while(!reader.atEnd()) {
        reader.readNext();
        if (reader.isStartElement()) {
            reader.readNextStartElement();
            for(int i=0;i<ui->tableWidget->rowCount();i++){
                if(reader.name() == "row"){

                    reader.readNextStartElement();
                    for(int i=0;i<2;i++){
                        //                        qDebug() << reader.name();
                        foreach(const QXmlStreamAttribute &attr, reader.attributes()) {

                            if (attr.name().toString() == QLatin1String("text")) {

                                stList.append( attr.value().toString());
                                qDebug() << stList;
                            }


                        }
                        reader.readNextStartElement();
                        reader.readNextStartElement();
                    }
                }
                reader.readNextStartElement();
            }

        }
    }


        for(int i=0, maxRow = ui->tableWidget->rowCount();i<maxRow ;++i){
            for(int j=0, maxCol = ui->tableWidget->columnCount();j<maxCol ;++j){
                QTableWidgetItem *newItem = new QTableWidgetItem(tr("%1").arg( stList[L]));
                qDebug() << stList[i];
                ui->tableWidget->setItem(i, j, newItem);
               L++;
            }
        }

VRonin

maybe the XmlModelSerialiserPrivate::writeXmlElement and XmlModelSerialiserPrivate::readXmlElement methods from https://github.com/VSRonin/QtModelUtilities/blob/master/src/xmlmodelserialiser.cpp might help