Using qlst excel file

One 、 Introductory example

Code from QtXlsx Sample file project provided F:\QtProject\QtXlsxWriter-master\examples\xlsx\hello

1、 Generate a excel file

2、 The code is as follows

QtXlsxTest1.pro

QT += core
QT -= gui
QT += xlsx

CONFIG += c++11

TARGET = QtXlsxTest1
CONFIG += console
CONFIG -= app_bundle

TEMPLATE = app

SOURCES += main.cpp

main.cpp

#include <QCoreApplication>
#include <QtCore>
#include "xlsxdocument.h"

int main()
{
    
    QXlsx::Document xlsx("excel01.xlsx");

    //![1]
    xlsx.write("A1", "Hello Qt!");
    xlsx.write("A2", 12345);
    xlsx.write("A3", "=44+33");
    xlsx.write("A4", true);
    xlsx.write("A5", "http://qt-project.org");
    xlsx.write("A6", QDate(2013, 12, 27));
    xlsx.write("A7", QTime(6, 30));
    xlsx.save();

    return 0;
}

Two 、excel File read and write

1、 write in excel file

#include <QCoreApplication>
#include <QtCore>
#include "xlsxdocument.h"
#include <QDebug>

void WriteExcel()
{
    
    QXlsx::Document xlsx;

    for(int i = 1; i < 11; i++)
    {
    
        for(int j = 1; j < 11; j++)
        {
    
            QString sValue = QString("%1_%2").arg(i).arg(j);
            xlsx.write(i,j,sValue);
        }
    }

    xlsx.saveAs("WriteExcel.xlsx");
}

2、 Read excel file

void ReadExcel()
{
    
    QXlsx::Document xlsx("WriteExcel.xlsx");

    for(int i = 1; i < 11; i++)
    {
    
        for(int j = 1; j < 11; j++)
        {
    
            QVariant sValue = xlsx.read(i,j);
            if(sValue.type() == QVariant::Int)
            {
    
                qDebug()<<sValue.toInt();
            }
            else if(sValue.type() == QVariant::Double)
            {
    
                qDebug()<<sValue.toDouble();
            }
            else if(sValue.type() == QVariant::String)
            {
    
                qDebug() << sValue.toString();
            }
        }
    }
}