Save QTableWidget

[bareil76]

Now I need to LOAD files!!

[bareil76]

I tried this for loading a .csv file. But I get an exception at line 32. What is the problem?

@void MainWindow::loadFile()
{
//QString filename = QFileDialog::getOpenFileName(this);
//QFile file(filename);
/* if (file.open(QIODevice::ReadOnly|QIODevice::Text)) {
ui->textEdit->setPlainText(QString::fromUtf8(file.readAll()));
mFilePath = filename;
statusBar()->showMessage(tr("File successfully loaded."), 3000);
}/
QString fileName = QFileDialog::getOpenFileName(this, ("Open File"), NULL, ("csv File(.csv)"));
QString data;
QFile importedCSV(fileName);
QStringList rowOfData;
QStringList rowData;
data.clear();
rowOfData.clear();
rowData.clear();

if (importedCSV.open(QFile::ReadOnly))
{
    data = importedCSV.readAll();
    rowOfData = data.split("\n");           //Value on each row
    importedCSV.close();
}

for (int x = 0; x < rowOfData.size(); x++)  //rowOfData.size() gives the number of row
{
    rowData = rowOfData.at(x).split(";");   //Number of collumn
    int r=rowData.size();
    for (int y = 0; y < rowData.size(); y++)
    {
        ui->tableWidget->item(x,y)->setText(rowData[y]);
    }
}
statusBar()->showMessage(tr("File successfully loaded."), 3000);

}@

[bareil76]

I have change line 32 with

@ui->tableWidget->setItem(x-1,y,new QTableWidgetItem(rowData[y]));@

But the table is filling up with '' Text '' how do remove ''??

[bareil76]

Ok I found out how.. thanks. Solved

Note: I had to replace

@"" " + ui->tableWidget->horizontalHeaderItem(c)->data(Qt::DisplayRole).toString() + "" ";@

with

@ui->tableWidget->horizontalHeaderItem(c)->data(Qt::DisplayRole).toString() +
" ";@

[marinamarina]

excuse me, I know it's been a looong while, but could you tell me what ui->textEdit is? I'm having trouble saving my qtablewidget and this isthe only actual solution I can find, but I don't quite understand it

[SGaist]

Hi,

ui implies that this is a Designer based widget. textEdit is likely to be a QTextEdit

Hope it helps

[hannao]

Hi
I use code

for( int r = 0; r < ui->tableWidget->rowCount(); ++r )
    {
        strList.clear();
        for( int c = 0; c < ui->tableWidget->columnCount(); ++c )
        {   QTableWidgetItem* item = ui->tableWidget->item(r,c);     
            if (!item || item->text().isEmpty())                        
            {
                ui->tableWidget->setItem(r,c,new QTableWidgetItem("0"));
            }
            strList << "\" "+ui->tableWidget->item( r, c )->text()+"\" ";

        }
        data << strList.join( ";" )+"\n";
    }

I have problem When I read(Open) file and write(save) file replace again (around 3 round).
But file has empty line.
Please help me .

[mrjj]

@hannao
Hi and welcome
so you save all rows as
col;col;col ?

So what is not working?
There is empty line ?
or nothing at all in file ?

[hannao]

Yes, when I save again agin again. This file is empty

[mrjj]

@hannao
can you show the load code ?

[VRonin]

I implemented something I consider relatively satisfying (even though there's a lot of room for improvement) here: https://github.com/VSRonin/Qt-Model-Serialisation/tree/dev (make sure you use the dev branch)

    CsvModelSerialiser serial; //create the serialiser
    serial->setModel(tableWidget->model()); // set the model to save
    serial->setCsvSeparator(";"); // use ; as separator
    QFile tempFile("TestSave"); // prepare the file to save
    if (!serial->saveModel(&tempFile)) // save the model to file
        Q_ASSERT(false);

to load it:

    CsvModelSerialiser serial; //create the serialiser
    serial->setModel(tableWidget->model()); // set the model to load
    serial->setCsvSeparator(";"); // use ; as separator
    QFile tempFile("TestSave"); // prepare the file to load
    if (!serial->loadModel(&tempFile)) // save the model to file
        Q_ASSERT(false);

[hannao]

Here I use.

void Finalline2::on_openButton_clicked()
{
    QString filename = QFileDialog::getOpenFileName(this,tr("Open Files"),"/home/pi/share/L2/Final Line",tr("Txt Files(*.txt)"));
    QFile file(filename);
    QStringList listA;
    int row=0;
    if(file.open(QIODevice::ReadOnly)){
        while(!file.atEnd()){
            QString line = file.readLine();
            listA = line.split(",");
            ui->tableWidget->setColumnCount(listA.size());
            ui->tableWidget->insertRow(row);
            for(int x = 0; x < listA.size() ; x++)
            {
                QTableWidgetItem *test = new QTableWidgetItem(listA.at(x));
                ui->tableWidget->setItem(row, x, test);
            }
            row++;
        }

    }
    file.close();
}

[VRonin]

@hannao said in [SOLVED] Save QTableWidget:

listA = line.split(",");

@hannao said in [SOLVED] Save QTableWidget:

data << strList.join( ";" )+"\n";

I see something weird going on here

---

@hannao said in [SOLVED] Save QTableWidget:

if(file.open(QIODevice::ReadOnly)){

If the file is text you should use the text flag if(file.open(QIODevice::ReadOnly | QIODevice::Text)){

[hannao]

@VRonin
I'm sorry. Real I use listA = line.split(" , ");

[VRonin]

@hannao said in [SOLVED] Save QTableWidget:

I use listA = line.split(" , ");

It's still different from the save code

Did you try using my code?

You just have to copy everything excluding model_serialisation_global.h into your folder and add DEFINES += QT_MODEL_SERIALISATION_EXPORT to your pro file (I know this is not ideal but if it's still in the dev branch there are reasons)

[hannao]

@VRonin
I use Qt on Rasberry pi3
but normally when I install use
qmake
make
make install
but I don't how to install model_serialisation . please suggestion to me.

[VRonin]

No, do not bother building the library (in fact I don't think it will work as I miss the .pro file altogether). Just copy everything excluding model_serialisation_global.h in your project and add the sources to your project.