Qt实例：利用QTableWidget编辑xls,txt文件

一 效果图

二 代码

2.1 头文件 mainwindow.h

#ifndef MAINWINDOW_H
#define MAINWINDOW_H
#include <QMainWindow>

namespace Ui {
class MainWindow;
}
class MainWindow : public QMainWindow
{
    Q_OBJECT
public:
    explicit MainWindow(QWidget *parent = 0);
    ~MainWindow();
private slots:
    void on_pushButton_clicked();//增加行数
    void on_pushButton_2_clicked();//导出
    void on_pushButton_3_clicked();//导入
private:
    Ui::MainWindow *ui;
};

#endif // MAINWINDOW_H

2.2 核心代码 mainwindow.cpp

#include "mainwindow.h"
#include "ui_mainwindow.h"
#include <QFile>
#include <QFileDialog>
#include <QMessageBox>
#include <QTextStream>
#include <QDebug>
#include <QTextEdit>

MainWindow::MainWindow(QWidget *parent) :
    QMainWindow(parent),
    ui(new Ui::MainWindow)
{
    ui->setupUi(this);
    ui->tableWidget->clear();

    ui->tableWidget->setColumnCount(8);//只设置列数，行数动态中增加
    ui->tableWidget->setHorizontalHeaderLabels(QStringList()<<"城市"<<"总云量"<<"降水量"<<"能见度"<<"温度"<<"湿度"<<"风向"<<"风速");
    ui->tableWidget->setSelectionBehavior(QAbstractItemView::SelectItems);//设置表格选中单个单元格的方式
    //ui->tableWidget->setEditTriggers(QAbstractItemView::NoEditTriggers);//禁止修改
    ui->tableWidget->setSelectionMode(QAbstractItemView::SingleSelection);//单个选中和多个选中的设置
    ui->tableWidget->verticalHeader()->setVisible(false); //隐藏列表头
    ui->tableWidget->horizontalHeader()->setDefaultSectionSize(70); //设置列宽

    QFont font = ui->tableWidget->horizontalHeader()->font(); //先获取字体
    font.setBold(true); //字体设置为粗体
    ui->tableWidget->horizontalHeader()->setFont(font); //设置每一列的标题字体为粗体
}

MainWindow::~MainWindow()
{
    delete ui;
}

void MainWindow::on_pushButton_clicked()
{
    int RowCont;
    RowCont=ui->tableWidget->rowCount();
    ui->tableWidget->insertRow(RowCont);//增加一行
}


void MainWindow::on_pushButton_2_clicked()
{
        //QString filepath = QFileDialog::getSaveFileName(this, tr("保存文件"),QString(), tr("EXCEL files (*.xls);;HTML-Files (*.txt);;"));
        QString filepath = "F:/1.xls";

        if (!filepath.isEmpty())
        {
            int row = ui->tableWidget->rowCount();
            int col = ui->tableWidget->columnCount();

            QList<QString> list;
            //添加列标题
            QString HeaderRow;
            for (int i = 0; i < col; i++)
            {
                HeaderRow.append(ui->tableWidget->horizontalHeaderItem(i)->text() + "\t");
            }
            list.push_back(HeaderRow);

            for (int i = 0; i < row; i++)
            {
                QString rowStr = "";
                for (int j = 0; j < col; j++){
                    if(ui->tableWidget->item(i,j)!=0)
                    {
                         rowStr += ui->tableWidget->item(i, j)->text() + "\t";
                    }
                    else
                    {
                          QMessageBox::information(0,tr("提示"),tr("增加的当前行数据为空!"));
                          break;
                    }
                }
                list.push_back(rowStr);
            }
            QTextEdit textEdit;
            for (int i = 0; i < list.size(); i++)
            {
                textEdit.append(list.at(i));
            }
            QFile file(filepath);
            if (file.open(QFile::WriteOnly | QIODevice::Text))
            {
                QTextStream ts(&file);
                ts.setCodec("GB2312");//这个地方大家自己判断是否用“utf-8”
                ts << textEdit.document()->toPlainText();
                file.close();
            }
            //导出后将表格情况，这一步大家自己选择要不要
            //ui->tableWidget->clearContents();
            //ui->tableWidget->setRowCount(0);
        }
}

void MainWindow::on_pushButton_3_clicked()
{
    //QString fileName = QFileDialog::getOpenFileName(0, tr("导入文件"),QString(), tr("EXCEL files (*.xls);;HTML-Files (*.txt);;"));
    QString fileName = "F:/1.xls";

        if(!fileName.isEmpty())
        {
            QFile file;
            file.setFileName(fileName);
            //打开文件
            if(!file.open(QIODevice::ReadOnly | QIODevice::Text))
            {
                QMessageBox msg;
                msg.setText("打开文件失败!");
                msg.exec();
            }
            else
            {
                if(!file.size())
                {
                    QMessageBox::warning(0,tr("警告"),tr("文件大小为空!"),QMessageBox::Ok);
                }
                else
                {
                    //将文件数据导入表格
                    int r_count = 0;        //统计文件的行数
                    QStringList textList;   //记录文件中每一行的数据
                    QTextStream in(&file);
                    while (!in.atEnd())
                    {
                        QString line = in.readLine();
                        textList.append(line);          //保存文件的数据
                        r_count++;                      //记录文件的行数 前两行为表头
                    }

                    file.close();
                    if(!textList.isEmpty() && r_count>1)
                    {
                        QStringList listColHeader = textList.at(1).split("\t");
                        QStringList listRowHeader = textList.at(0).split("\t");
                        int c_count = listRowHeader.count();
                        ui->tableWidget->clear();
                        ui->tableWidget->setRowCount(r_count-1);      //前1行是行表头
                        ui->tableWidget->setColumnCount(c_count-1);   //最后一行是“\t"
                        ui->tableWidget->setHorizontalHeaderLabels(listRowHeader);
                        ui->tableWidget->setVerticalHeaderLabels(listColHeader);
                        qDebug()<<"start importTable row count:::"<<r_count<<"col count:::"<<c_count;

                        for(int row = 0; row < r_count; row++)
                        {
                            QStringList tmpList;
                            tmpList = textList.at(row).split("\t");

                            for(int col = 0; col < c_count; col++)
                            {
                                QTableWidgetItem *item = new QTableWidgetItem(tmpList.at(col));

                                ui->tableWidget->setItem(row-1, col, item);
                            }
                        }
                        QMessageBox::information(0,tr("提示"),tr("导入成功!"));
                    }
                    else
                    {
                      QMessageBox::information(0,tr("提示"),tr("文件数据为空!"));
                    }
                }
            }
        }
        else
        {
            QMessageBox::warning(0,tr("警告"),tr("文件名未指定!"),QMessageBox::Ok);
        }
}

参考文章：https://blog.csdn.net/sinat_30440627/article/details/53978580
                  https://blog.csdn.net/graceland525/article/details/45150489
                  https://blog.csdn.net/cwj066/article/details/83344705
                  https://blog.csdn.net/polokang/article/details/6696982