Ubuntu16.04使用Qt Xlsx

Usage(1): Use Xlsx as Qt5’s addon module
1. Download the source code from github.com.
https://github.com/dbzhang800/QtXlsxWriter/archive/master.zip

1. Put the source code in any directory you like. At the toplevel directory run

Note: Perl is needed in this step.

qmake
make
make install
The library, the header files, and others will be installed to your system.
注：编译时会出现如下错误：
xlsxzipreader.cpp: In member function ‘void QXlsx::ZipReader::init()’:
xlsxzipreader.cpp:51:66: error: conversion from ‘QVector’ to non-scalar type ‘QList’ requested
QList allFiles = m_reader->fileInfoList();
解决方法：
1.打开出错的源文件
vim src/xlsx/xlsxzipreader.cpp
2.添加头文件#include ，然后把出错的地方的”QList” 用”QVector” 替换掉重新make就可以了。

1. Add following line to your qmake’s project file:

QT += xlsx
4. Then, using Qt Xlsx in your code

include “xlsxdocument.h”

int main()
{
QXlsx::Document xlsx;
xlsx.write(“A1”, “Hello Qt!”);
xlsx.saveAs(“Test.xlsx”);
return 0;
}