Library_Project/demo/xlsx/widget.cpp

#include "widget.h"
#include "./ui_widget.h"

#include <QTimer>
#include <QFileDialog>

#include "spdlog/spdlog.h"

#include "QXlsx/QXlsx/xlsxdocument.h"


Widget::Widget(QWidget *parent)
    : QWidget(parent)
    , ui(new Ui::Widget)
{
    ui->setupUi(this);

    
    SPDLOG_INFO("***** Qt Library *****");
    
}

Widget::~Widget()
{

    delete ui;
}


void Widget::on_pBtn_export_clicked()
{
    SPDLOG_INFO("点击了“导出excel”按钮");

    QXlsx::Document xlsx("test.xlsx");   
    xlsx.addSheet("Sheet1");
    xlsx.addSheet("Sheet2");

    xlsx.write("A1", "Hello Qt!");
    xlsx.write("A2", 12345);
    xlsx.write("A3", "=44+33");
    xlsx.write("A4", true);
    xlsx.write("B1", "2021-01-01 12:00:00");
    xlsx.write("B2", QDate(2021, 1, 1));
    xlsx.write(3, 1, QTime(12, 0, 0));
    xlsx.save();
    SPDLOG_INFO("导出excel成功");

}