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 xlsx 指定6版本，可顺利在qt的debug或者release构建成功！ （187个子文件） 
_clang-format 654B .qmake.conf 93B xlsxworksheet.cpp 82KB xlsxstyles.cpp 65KB xlsxformat.cpp 32KB xlsxdocument.cpp 32KB xlsxconditionalformatting.cpp 31KB xlsxworkbook.cpp 24KB xlsxchart.cpp 24KB xlsxdrawinganchor.cpp 19KB xlsxdatavalidation.cpp 17KB xlsxsharedstrings.cpp 16KB tst_worksheet.cpp 11KB tst_documenttest.cpp 11KB main.cpp 11KB xlsxtheme.cpp 11KB xlsxutility.cpp 9KB tst_utilitytest.cpp 9KB xlsxdocpropscore.cpp 8KB xlsxrichstring.cpp 8KB xlsxcontenttypes.cpp 7KB xlsxcellformula.cpp 7KB xlsxrelationships.cpp 7KB xlsxdocpropsapp.cpp 6KB main.cpp 6KB tst_stylestest.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 main.cpp 3KB xlsxabstractooxmlfile.cpp 3KB xlsxmediafile.cpp 3KB tst_xmlspacetest.cpp 3KB main.cpp 2KB tst_cellreferencetest.cpp 2KB xlsxzipwriter.cpp 2KB xlsxzipreader.cpp 2KB tst_zipreadertest.cpp 2KB main.cpp 2KB xlsxsimpleooxmlfile.cpp 2KB main.cpp 1KB main.cpp 1KB tst_formattest.cpp 1KB main.cpp 1KB tst_relationshipstest.cpp 1KB main.cpp 1KB tst_propscoretest.cpp 1KB main.cpp 1KB main.cpp 945B main.cpp 917B tst_docpropsapptest.cpp 913B tst_richstringtest.cpp 838B main.cpp 836B main.cpp 722B main.cpp 706B main.cpp 538B main.cpp 515B main.cpp 498B main.cpp 436B main.cpp 412B doc_src_qtxlsx.cpp 70B
xlsx_demo.gif 217KB .gitignore 357B xlsxformat.h 8KB xlsxworksheet.h 7KB xlsxworksheet_p.h 7KB xlsxdocument.h 5KB xlsxstyles_p.h 5KB xlsxconditionalformatting.h 5KB xlsxdrawinganchor_p.h 5KB xlsxworkbook.h 4KB xlsxformat_p.h 4KB xlsxdatavalidation.h 4KB xlsxconditionalformatting_p.h 4KB xlsxchart_p.h 3KB xlsxrichstring.h 3KB xlsxworkbook_p.h 3KB xlsxsharedstrings_p.h 3KB xlsxcellrange.h 3KB xlsxrelationships_p.h 3KB xlsxcontenttypes_p.h 3KB xlsxcolor_p.h 3KB xlsxutility_p.h 3KB xlsxcellformula.h 3KB xlsxdatavalidation_p.h 3KB xlsxchart.h 3KB xlsxabstractsheet.h 2KB xlsxcellreference.h 2KB xlsxmediafile_p.h 2KB xlsxcell.h 2KB xlsxdocpropsapp_p.h 2KB xlsxsheetmodel.h 2KB共 187 条
- 1
- 2
资源评论
愚者悠世
- 粉丝: 3
- 资源: 2
最新资源
- Qt实现的包含图片显示功能、自适应缩放、背景图片、画roi工具 不依赖其他库纯Qt实现 在图片上可以画矩形、矩形旋转、圆形、
- 基于Springboot+Vue前后端分离技术的课程精品网站设计源码
- 基于SpringBoot和Vue的民宿在线预定平台设计源码
- 正余弦优化(SCA)算法+任务分配的多智能体路径规划算法 matlab代码 显示方式为动态显示 新型群智能算法 多智能体
- 基于Java语言的广东海洋大学体育管理系统后端设计源码
- 基于Java实现的boardRoom会议室控制设计源码
- 基于Java语言实现的经典飞机大战设计源码
- 基于Java技术的黑马商城在线商品选购与下单功能设计源码
- 基于Java、CSS、JavaScript的KTV娱乐系统设计源码
- 基于Java的AE管理器中文修改版设计源码
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
