Method loadFromCSV

examples/tools/TableModel.cpp:128–189

}

bool TableModel::loadFromCSV(const QString &filename)
{
    QFile file(filename);
    if (!file.exists() || !file.open(QIODevice::ReadOnly)) {
        qDebug() << "TableModel::loadFromCSV: file" << filename
                 << "does not exist or could not be opened";
        return false;
    }

    QStringList lines;
    while (!file.atEnd()) {
        lines.append(QString::fromUtf8(file.readLine()));
    }

    setTitleText(QString());
    m_rows.clear();
    m_rows.resize(qMax(0, lines.size() - (m_dataHasHorizontalHeaders ? 1 : 0)));

    for (int row = 0; row < lines.size(); ++row) {
        QStringList cells = splitLine(lines.at(row));

        QVector<QVariant> values(qMax(0, cells.size() - (m_dataHasVerticalHeaders ? 1 : 0)));

        for (int column = 0; column < cells.size(); ++column) {
            QString cell = cells.at(column);

            if (row == 0 && m_dataHasHorizontalHeaders) {
                // interpret the first row as column headers:
                // the first one is an exception: interpret that as title
                if (column == 0 && m_dataHasVerticalHeaders) {
                    setTitleText(cell);
                } else {
                    m_horizontalHeaderData.append(cell);
                }
            } else {
                if (column == 0 && m_dataHasVerticalHeaders) {
                    // interpret first column as row headers:
                    m_verticalHeaderData.append(cell);
                } else {
                    // try to interpret cell values as floating point
                    bool convertedOk = false;
                    qreal numeric = cell.toDouble(&convertedOk);
                    const int destColumn = column - (m_dataHasVerticalHeaders ? 1 : 0);
                    values[destColumn] = convertedOk ? numeric : (cell.isEmpty() ? QVariant() : cell);
                }
            }
        }
        const int destRow = row - (m_dataHasHorizontalHeaders ? 1 : 0);
        if (destRow >= 0) {
            m_rows[destRow] = values;
        }
    }

    beginResetModel();
    endResetModel();

    if (m_rows.isEmpty()) {
        qDebug() << "TableModel::loadFromCSV: table loaded, but no "