Documentation: http://qtxlsx.debao.me
QtXlsx is a library that can read and write Excel files. It doesn't require Microsoft Excel and can be used in any platform that Qt5 supported.
The library can be used to
* Generate a new .xlsx file from scratch
* Extract data from an existing .xlsx file
* Edit an existing .xlsx file
## Getting Started
> * For linux user, if your Qt is installed through package manager tools such "apt-get", make sure that you have installed the Qt5 develop package *qtbase5-private-dev*
### Usage(1): Use Xlsx as Qt5's addon module
#### Building the module
> **Note**: Perl is needed in this step.
* Download the source code.
* Put the source code in any directory you like
* Go to top directory of the project in a terminal and run
```
qmake
make
make install
```
The library, the header files, and others will be installed to your system.
> ```make html_docs``` can be used to generate documentations of the library, and ```make check``` can be used to run unit tests of the library.
#### Using the module
* Add following line to your qmake's project file:
```
QT += xlsx
```
* Then, using Qt Xlsx in your code
```cpp
#include <QtXlsx>
int main()
{
QXlsx::Document xlsx;
xlsx.write("A1", "Hello Qt!");
xlsx.saveAs("Test.xlsx");
return 0;
}
```
### Usage(2): Use source code directly
The package contains a **qtxlsx.pri** file that allows you to integrate the component into applications that use qmake for the build step.
* Download the source code.
* Put the source code in any directory you like. For example, 3rdparty:
```
|-- project.pro
|-- ....
|-- 3rdparty\
| |-- qtxlsx\
| |
```
* Add following line to your qmake project file:
```
include(3rdparty/qtxlsx/src/xlsx/qtxlsx.pri)
```
> **Note**: If you like, you can copy all files from *src/xlsx* to your application's source path. Then add following line to your project file:
> ```
include(qtxlsx.pri)
```
> **Note**: If you do not use qmake, you need to define the following macro manually
> ```
XLSX_NO_LIB
```
* Then, using Qt Xlsx in your code
```cpp
#include "xlsxdocument.h"
int main()
{
QXlsx::Document xlsx;
xlsx.write("A1", "Hello Qt!");
xlsx.saveAs("Test.xlsx");
return 0;
}
```
## References
* http://www.ecma-international.org/publications/standards/Ecma-376.htm
* http://www.iso.org/iso/catalogue_detail?csnumber=51463
* http://msdn.microsoft.com/en-us/library/ee908652%28v=office.12%29.aspx
* http://www.datypic.com/sc/ooxml/
### General
* https://github.com/jmcnamara/XlsxWriter
* http://openpyxl.readthedocs.org
* http://officeopenxml.com/anatomyofOOXML-xlsx.php
* http://www.libxl.com
* http://closedxml.codeplex.com/
* http://epplus.codeplex.com/
* http://excelpackage.codeplex.com/
* http://spreadsheetlight.com/
### Number formats
* http://msdn.microsoft.com/en-us/library/ff529356%28v=office.12%29.aspx
* http://www.ozgrid.com/Excel/excel-custom-number-formats.htm
* http://stackoverflow.com/questions/894805/excel-number-format-what-is-409
* http://office.microsoft.com/en-001/excel-help/create-a-custom-number-format-HP010342372.aspx
### Formula
* http://msdn.microsoft.com/en-us/library/ff533995%28v=office.12%29.aspx
* http://msdn.microsoft.com/en-us/library/dd906358%28v=office.12%29.aspx
* http://homepages.ecs.vuw.ac.nz/~elvis/db/Excel.shtml
* http://ewbi.blogs.com/develops/2004/12/excel_formula_p.html
没有合适的资源?快使用搜索试试~ 我知道了~
QT excel 类 之 QtXlsxWriter
共189个文件
cpp:67个
h:47个
pro:44个
需积分: 9 17 下载量 103 浏览量
2017-11-03
12:57:07
上传
评论 1
收藏 555KB ZIP 举报
温馨提示
QT第三方类,对excel的操作方法。window下好用。 vs+qt下的使用http://blog.csdn.net/wokaowokaowokao12345/article/details/52135790
资源推荐
资源详情
资源评论
收起资源包目录
QT excel 类 之 QtXlsxWriter (189个子文件)
.qmake.conf 93B
xlsxworksheet.cpp 80KB
xlsxstyles.cpp 62KB
xlsxformat.cpp 32KB
xlsxdocument.cpp 32KB
xlsxconditionalformatting.cpp 30KB
xlsxworkbook.cpp 24KB
xlsxchart.cpp 23KB
xlsxdrawinganchor.cpp 19KB
xlsxdatavalidation.cpp 17KB
xlsxsharedstrings.cpp 15KB
xlsxtheme.cpp 11KB
tst_worksheet.cpp 11KB
tst_documenttest.cpp 11KB
main.cpp 11KB
xlsxutility.cpp 9KB
tst_utilitytest.cpp 9KB
xlsxrichstring.cpp 8KB
xlsxdocpropscore.cpp 7KB
xlsxcontenttypes.cpp 7KB
xlsxcellformula.cpp 7KB
xlsxrelationships.cpp 6KB
xlsxdocpropsapp.cpp 6KB
tst_stylestest.cpp 6KB
main.cpp 6KB
xlsxsheetmodel.cpp 6KB
tst_sharedstringstest.cpp 5KB
xlsxchartsheet.cpp 5KB
xlsxcolor.cpp 5KB
xlsxabstractsheet.cpp 4KB
xlsxcellreference.cpp 4KB
xlsxcell.cpp 4KB
xlsxcellrange.cpp 4KB
tst_conditionalformattingtest.cpp 4KB
xlsxdrawing.cpp 3KB
xlsxnumformatparser.cpp 3KB
xlsxabstractooxmlfile.cpp 3KB
main.cpp 3KB
xlsxmediafile.cpp 3KB
tst_xmlspacetest.cpp 3KB
main.cpp 2KB
xlsxzipreader.cpp 2KB
tst_cellreferencetest.cpp 2KB
xlsxzipwriter.cpp 2KB
tst_zipreadertest.cpp 2KB
main.cpp 2KB
xlsxsimpleooxmlfile.cpp 2KB
main.cpp 1KB
tst_formattest.cpp 1KB
main.cpp 1KB
main.cpp 1KB
tst_relationshipstest.cpp 1KB
main.cpp 1KB
tst_propscoretest.cpp 1KB
main.cpp 1KB
main.cpp 917B
tst_docpropsapptest.cpp 913B
main.cpp 882B
tst_richstringtest.cpp 838B
main.cpp 826B
main.cpp 722B
main.cpp 699B
main.cpp 538B
main.cpp 516B
main.cpp 498B
main.cpp 436B
main.cpp 406B
doc_src_qtxlsx.cpp 70B
xlsx_demo.gif 217KB
.gitignore 357B
xlsxformat.h 8KB
xlsxworksheet_p.h 7KB
xlsxworksheet.h 7KB
xlsxdocument.h 5KB
xlsxstyles_p.h 5KB
xlsxdrawinganchor_p.h 5KB
xlsxconditionalformatting.h 5KB
xlsxworkbook.h 4KB
xlsxformat_p.h 4KB
xlsxdatavalidation.h 4KB
xlsxconditionalformatting_p.h 4KB
xlsxchart_p.h 4KB
xlsxrichstring.h 3KB
xlsxworkbook_p.h 3KB
xlsxcellrange.h 3KB
xlsxsharedstrings_p.h 3KB
xlsxrelationships_p.h 3KB
xlsxcontenttypes_p.h 3KB
xlsxcolor_p.h 3KB
xlsxutility_p.h 3KB
xlsxcellformula.h 3KB
xlsxabstractsheet.h 3KB
xlsxdatavalidation_p.h 3KB
xlsxchart.h 2KB
xlsxmediafile_p.h 2KB
xlsxcellreference.h 2KB
xlsxcell.h 2KB
xlsxdocpropsapp_p.h 2KB
xlsxsheetmodel.h 2KB
xlsxdocument_p.h 2KB
共 189 条
- 1
- 2
资源评论
ewrest
- 粉丝: 12
- 资源: 81
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功