Qt InterView Table View生成表格视图，并将表格保存到本地

1. Qt InterView Table View生成表格视图，QAbstractTableModel保存表格数据，QTableView负责显示。
2. 使用QtXlsx，生成excel到本地。参考：https://blog.csdn.net/qq_40194498/article/details/80817264

main.c

#include "mainwindow.h"
#include <QApplication>
#include "modelex.h"
#include <QTableView>

int main(int argc, char *argv[])
{
    QApplication a(argc, argv);
    ModelEx modelEx;
    QTableView view;
    view.setModel(&modelEx);
    view.setWindowTitle(QObject::tr("modelEx"));
    view.resize(400,400);
    view.show();

    modelEx.generateExcel();
    return a.exec();
}

modelex.cpp

#include "modelex.h"

ModelEx::ModelEx(QObject *parent):QAbstractTableModel(parent)
{
    armyMap[1]=tr("空军");
    armyMap[2]=tr("海军");
    armyMap[3]=tr("陆军");
    armyMap[4]=tr("海军陆战队");
    weaponTypeMap[1]=tr("轰炸机");
    weaponTypeMap[2]=tr("战斗机");
    weaponTypeMap[3]=tr("航空母舰");
    weaponTypeMap[4]=tr("驱逐舰");
    weaponTypeMap[5]=tr("直升机");
    weaponTypeMap[6]=tr("坦克");
    weaponTypeMap[7]=tr("两栖攻击舰");
    weaponTypeMap[8]=tr("两栖战车");
    populateModel();
}
void ModelEx::populateModel()
{
    header<<tr("军种")<<tr("种类")<<tr("武器");
    army<<1<<2<<3<<4<<2<<4<<3<<1;
    weaponType<<1<<3<<5<<7<<4<<8<<6<<2;
    weapon<<tr("B-2")<<tr("尼米兹级")<<tr("阿帕奇")<<tr("黄蜂级")
            <<tr("阿利伯克级")<<tr("AAAV")<<tr("M1A1")<<tr("F-22");
}
int ModelEx::columnCount(const QModelIndex &parent) const
{	 return 3;	   }
int ModelEx::rowCount(const QModelIndex &parent) const
{
    return army.size();
}
QVariant ModelEx::data(const QModelIndex &index, int role) const
{
    if(!index.isValid())
        return QVariant();
    if(role==Qt::DisplayRole)				//(a)
    {
        switch(index.column())
        {
        case 0:
            return armyMap[army[index.row()]];
            break;
        case 1:
            return weaponTypeMap[weaponType[index.row()]];
            break;
        case 2:
            return weapon[index.row()];
        default:
            return QVariant();
        }
    }
    return QVariant();
}
QVariant ModelEx::headerData(int section, Qt::Orientation orientation, int role) const
{
    if(role==Qt::DisplayRole&&orientation==Qt::Horizontal)
           return header[section];
    return QAbstractTableModel::headerData(section,orientation,role);
}
void ModelEx::generateExcel()
{
    int row, column;

    for(row = 1; row <= (rowCount() + 1); row++)
    {
        for(column = 1; column <= columnCount(); column++)
        {
            if(row == 1)
            {
                QString HeaderString = header.at(column - 1);
                mXlxsEngine.write(row, column, HeaderString);
            }
            else
            {
                if(column == 1)
                {
                    QString ArmyString = armyMap[army[row - 2]];
                    mXlxsEngine.write(row, column, ArmyString);
                }
                else if(column == 2)
                {
                    QString weaponTypeString = weaponTypeMap[weaponType[row - 2]];
                    mXlxsEngine.write(row, column, weaponTypeString);

                }
                else
                {
                    QString weaponString = weapon.at(row - 2);
                    mXlxsEngine.write(row, column, weaponString);
                }
            }
        }
    }

    mXlxsEngine.saveAs("Test.xlsx");
}

modelex.h

#ifndef MODELEX_H
#define MODELEX_H

#include <QAbstractTableModel>
#include <QVector>
#include <QMap>
#include <QStringList>
#include <QtXlsx/QtXlsx>

class ModelEx : public QAbstractTableModel
{
public:
    explicit ModelEx(QObject *parent=0);
    //虚函数声明										//(a)
    virtual int rowCount(const QModelIndex &parent=QModelIndex()) const;
    virtual int columnCount(const QModelIndex &parent=QModelIndex()) const;
    QVariant data(const QModelIndex &index, int role) const;
    QVariant headerData(int section, Qt::Orientation orientation, int role) const;
    void generateExcel();
signals:

public slots:
private:
    QVector<short> army;
    QVector<short> weaponType;
    QMap<short,QString> armyMap;	//使用QMap数据结构保存“数值—文字”的映射
    QMap<short,QString> weaponTypeMap;
    QStringList  weapon;
    QStringList  header;
    void populateModel();			//完成表格数据的初始化填充
    QXlsx::Document mXlxsEngine;
};

#endif // MODELEX_H

运行结果：