Qt之数据写入CSV文件

 

.pro

QT       += core gui

greaterThan(QT_MAJOR_VERSION, 4): QT += widgets

CONFIG += c++11

# The following define makes your compiler emit warnings if you use
# any Qt feature that has been marked deprecated (the exact warnings
# depend on your compiler). Please consult the documentation of the
# deprecated API in order to know how to port your code away from it.
DEFINES += QT_DEPRECATED_WARNINGS

# You can also make your code fail to compile if it uses deprecated APIs.
# In order to do so, uncomment the following line.
# You can also select to disable deprecated APIs only up to a certain version of Qt.
#DEFINES += QT_DISABLE_DEPRECATED_BEFORE=0x060000    # disables all the APIs deprecated before Qt 6.0.0

SOURCES += \
    ZWriteToCSV.cpp \
    main.cpp \
    mainwindow.cpp

HEADERS += \
    ZWriteToCSV.h \
    mainwindow.h

FORMS += \
    mainwindow.ui

# Default rules for deployment.
qnx: target.path = /tmp/$${TARGET}/bin
else: unix:!android: target.path = /opt/$${TARGET}/bin
!isEmpty(target.path): INSTALLS += target

 

main.cpp

#include "mainwindow.h"

#include <QApplication>

int main(int argc, char *argv[])
{
    QApplication a(argc, argv);
    MainWindow w;
    w.show();
    return a.exec();
}

 

mainwindow.h

#ifndef MAINWINDOW_H
#define MAINWINDOW_H

#include <QMainWindow>

#include "ZWriteToCSV.h"

QT_BEGIN_NAMESPACE
namespace Ui { class MainWindow; }
QT_END_NAMESPACE

class MainWindow : public QMainWindow
{
    Q_OBJECT

public:
    MainWindow(QWidget *parent = nullptr);
    ~MainWindow();

private slots:
    void on_pushButton_clicked();

    void on_pushButton_2_clicked();

    void on_pushButton_3_clicked();

private:
    Ui::MainWindow *ui;
    //
    ZWriteToCSV *mZWriteToCSV = nullptr;
};
#endif // MAINWINDOW_H

 

mainwindow.cpp

#include "mainwindow.h"
#include "ui_mainwindow.h"

MainWindow::MainWindow(QWidget *parent)
    : QMainWindow(parent)
    , ui(new Ui::MainWindow)
{
    ui->setupUi(this);
    this->setWindowTitle(QStringLiteral("Qt之数据写入CSV文件"));
}

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


void MainWindow::on_pushButton_clicked()
{
    mZWriteToCSV = new ZWriteToCSV("c:/zhujq/123.csv");
}

void MainWindow::on_pushButton_2_clicked()
{
    QList<QStringList> oList;
    for(int i = 0; i < 100; ++i)
    {
        QStringList oSList;
        oSList.push_back("a");
        oSList.push_back(QString::number(i));
        oSList.push_back(QStringLiteral("中"));
        oList.push_back(oSList);
    }
    mZWriteToCSV->write(oList);
}

void MainWindow::on_pushButton_3_clicked()
{
    mZWriteToCSV->write(QStringLiteral("新,的,一,行！"));
}

 

ZWiteToCSV.h

#ifndef ZWRITETOCSV_H
#define ZWRITETOCSV_H

#include <QObject>
#include <QFile>
#include <QTextStream>
#include <QDebug>

class ZWriteToCSV : public QObject
{
public:
    ZWriteToCSV(const QString fileName, QObject *parent = nullptr);

    void write(const QList<QStringList>& data);
    void write(const QString aData);
private:
    QString mFileName = "";
    QFile *mFile = nullptr;
};



#endif // ZWRITETOCSV_H

 

ZWriteToCSV.cpp

#include "ZWriteToCSV.h"

ZWriteToCSV::ZWriteToCSV(const QString fileName, QObject *parent)
    : QObject(parent)
    , mFileName(fileName)
{
    //
    mFile = new QFile(mFileName);
}

void ZWriteToCSV::write(const QList<QStringList> &data)
{
    if(mFile)
    {
        if (!mFile->open(QIODevice::WriteOnly | QIODevice::Truncate | QIODevice::Text))
        {
            qDebug() << "Failed to open file for writing:" << mFile->errorString();
            return;
        }

        QTextStream stream(mFile);
        stream.setCodec("UTF-8"); //

        for (const QStringList& row : data)
        {
            for (int i = 0; i < row.size(); ++i)
            {
                stream << row.at(i);
                if (i != row.size() - 1)
                {
                    stream << ",";
                }
            }
            stream << endl;
        }

        mFile->close();
    }
}

void ZWriteToCSV::write(const QString aData)
{
    if(mFile)
    {
        if (!mFile->open(QIODevice::ReadWrite | QIODevice::Text | QIODevice::Append))
        {
            qDebug() << "Failed to open file for writing:" << mFile->errorString();
            return;
        }

        QTextStream stream(mFile);
        stream.setCodec("UTF-8"); //
        stream << aData;
        stream << endl;
        mFile->close();
    }
}

 mainwindow.ui

<?xml version="1.0" encoding="UTF-8"?>
<ui version="4.0">
 <class>MainWindow</class>
 <widget class="QMainWindow" name="MainWindow">
  <property name="geometry">
   <rect>
    <x>0</x>
    <y>0</y>
    <width>359</width>
    <height>216</height>
   </rect>
  </property>
  <property name="windowTitle">
   <string>MainWindow</string>
  </property>
  <widget class="QWidget" name="centralwidget">
   <widget class="QPushButton" name="pushButton">
    <property name="geometry">
     <rect>
      <x>80</x>
      <y>30</y>
      <width>200</width>
      <height>30</height>
     </rect>
    </property>
    <property name="text">
     <string>联接文件</string>
    </property>
   </widget>
   <widget class="QPushButton" name="pushButton_2">
    <property name="geometry">
     <rect>
      <x>80</x>
      <y>90</y>
      <width>200</width>
      <height>30</height>
     </rect>
    </property>
    <property name="text">
     <string>写入全部内容</string>
    </property>
   </widget>
   <widget class="QPushButton" name="pushButton_3">
    <property name="geometry">
     <rect>
      <x>80</x>
      <y>150</y>
      <width>200</width>
      <height>30</height>
     </rect>
    </property>
    <property name="text">
     <string>写入一行内容</string>
    </property>
   </widget>
  </widget>
 </widget>
 <resources/>
 <connections/>
</ui>