QT compilation qtxlsx Library

One 、QtXlsx Library compilation

Provide download package ： Contains compiled Qt5.6.3 edition 、QtXlsx Source code and Perl5 Software installation package .
Download address

1、 download QtXlsx Source code

Address ：QtXlsxWriter Download address
After downloading, unzip it to your own disk , The path should not contain spaces or special characters .

2、 install Perl5

Due to compilation QtXlsx Library needs Perl Script , So we must ensure that there is such an execution environment , Otherwise, an error will be reported , First cmd Enter the command line to check whether you have installed Perl5：

If not installed , Download it yourself perl5 Software installation .

3、 compile QtXlsx library

Use your own installation Qt open qtxlsx.pro, Then compile it .

4、 Usage method

Here, select the corresponding path according to the compilation ：

1. First, the project documents （ route ：QtXlsxWriter-master\src\xlsx） In the file （ See the following picture for details ） Copy to the new QtXlsx In the folder , The final will be QtXlsx Folder copy to Qt Installation directory , For example, my copy to ：D:\Qt\Qt5.7.0\5.7\msvc2013_64\include
2. Next, copy lib Under the folder Qt5Xlsxd.lib、Qt5Xlsx.lib、Qt5Xlsx.prl、Qt5Xlsxd.prl4 A file to your Qt Of lib Next ：D:\Qt\Qt5.7.0\5.7\msvc2013_64\lib
3. Copy lib Under folder Qt5Xlsx.dll、Qt5Xlsxd.dll Library files to your Qt Under the library path D:\Qt\Qt5.7.0\5.7\msvc2013_64\bin
4. Will build the mkspecs\modules-inst\qt_lib_xlsx.pri and qt_lib_xlsx_private.pri To your Qt Under module D:\Qt\Qt5.7.0\5.7\msvc2013_64\mkspecs\modules

Be careful ： Many people on the Internet say they will mkspecs\modules\qt_lib_xlsx.pri copy to msvc2017\mkspecs\modules, But in this way, the result module cannot be loaded into the project , It should be under the build directory mkspecs\modules-inst\qt_lib_xlsx.pri and qt_lib_xlsx_private.pri To msvc2015\mkspecs\modules）

Come down and use Qt Conduct excel Operating the , Just pay attention to ：

• When using, you need to include header files #include
• stay .pro Need to add :QT += xlsx
• After finishing , Better first qmake Reconstruction Engineering , Otherwise, you will be prompted that you cannot connect to the library ;

Then you can run your own QtXlsx Project .