QT 功能篇- Excel

Qt Xlsx环境安装

1. Qt Xlsx 下载地址 :https://github.com/dbzhang800/QtXlsxWriter

2. 下载QtXlsxWriter-master.zip
   
   

3. 解压QtXlsxWriter-master.zip
   

4. 用QT打开qtxlsx.pro
   

5. 选择MSCV2017来构建
   

6. 报错, 需要安装Perl
   

7. Perl下载地址:https://www.activestate.com/products/perl/downloads/

8. 下载ActivePerl-5.28.msi
   
   

9. 安装Perl
   
   
   
   
   
   

10. 编译Qt xlsx
    qmake
    mingw32-make
    mingw32-make install

    QXlsx::Document xlsx;
    xlsx.write(“A1”, “Hello Qt!”);
    xlsx.saveAs(“Test.xlsx”);