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
ActivePerl5.28版本下载、ActivePerl下载
需积分: 5 77 浏览量
2023-08-20
03:05:52
上传
评论
收藏 34.56MB 7Z 举报
ActivePerl5.28版本下载、ActivePerl下载 （375个子文件） 
_clang-format 654B _clang-format 654B .qmake.conf 93B .qmake.conf 93B xlsxworksheet.cpp 82KB xlsxworksheet.cpp 82KB xlsxstyles.cpp 65KB xlsxstyles.cpp 65KB xlsxformat.cpp 32KB xlsxformat.cpp 32KB xlsxdocument.cpp 32KB xlsxdocument.cpp 32KB xlsxconditionalformatting.cpp 31KB xlsxconditionalformatting.cpp 31KB xlsxworkbook.cpp 24KB xlsxworkbook.cpp 24KB xlsxchart.cpp 24KB xlsxchart.cpp 24KB xlsxdrawinganchor.cpp 19KB xlsxdrawinganchor.cpp 19KB xlsxdatavalidation.cpp 17KB xlsxdatavalidation.cpp 17KB xlsxsharedstrings.cpp 16KB xlsxsharedstrings.cpp 16KB tst_worksheet.cpp 11KB tst_worksheet.cpp 11KB tst_documenttest.cpp 11KB tst_documenttest.cpp 11KB main.cpp 11KB main.cpp 11KB xlsxtheme.cpp 11KB xlsxtheme.cpp 11KB xlsxutility.cpp 9KB xlsxutility.cpp 9KB tst_utilitytest.cpp 9KB tst_utilitytest.cpp 9KB xlsxdocpropscore.cpp 8KB xlsxdocpropscore.cpp 8KB xlsxrichstring.cpp 8KB xlsxrichstring.cpp 8KB xlsxcontenttypes.cpp 7KB xlsxcontenttypes.cpp 7KB xlsxcellformula.cpp 7KB xlsxcellformula.cpp 7KB xlsxrelationships.cpp 7KB xlsxrelationships.cpp 7KB xlsxdocpropsapp.cpp 6KB xlsxdocpropsapp.cpp 6KB main.cpp 6KB main.cpp 6KB tst_stylestest.cpp 6KB tst_stylestest.cpp 6KB xlsxsheetmodel.cpp 6KB xlsxsheetmodel.cpp 6KB tst_sharedstringstest.cpp 5KB tst_sharedstringstest.cpp 5KB xlsxchartsheet.cpp 5KB xlsxchartsheet.cpp 5KB xlsxcolor.cpp 5KB xlsxcolor.cpp 5KB xlsxabstractsheet.cpp 4KB xlsxabstractsheet.cpp 4KB xlsxcellreference.cpp 4KB xlsxcellreference.cpp 4KB xlsxcell.cpp 4KB xlsxcell.cpp 4KB xlsxcellrange.cpp 4KB xlsxcellrange.cpp 4KB tst_conditionalformattingtest.cpp 4KB tst_conditionalformattingtest.cpp 4KB xlsxdrawing.cpp 3KB xlsxdrawing.cpp 3KB xlsxnumformatparser.cpp 3KB xlsxnumformatparser.cpp 3KB main.cpp 3KB main.cpp 3KB xlsxabstractooxmlfile.cpp 3KB xlsxabstractooxmlfile.cpp 3KB xlsxmediafile.cpp 3KB xlsxmediafile.cpp 3KB tst_xmlspacetest.cpp 3KB tst_xmlspacetest.cpp 3KB main.cpp 2KB main.cpp 2KB tst_cellreferencetest.cpp 2KB tst_cellreferencetest.cpp 2KB xlsxzipwriter.cpp 2KB xlsxzipwriter.cpp 2KB xlsxzipreader.cpp 2KB xlsxzipreader.cpp 2KB tst_zipreadertest.cpp 2KB tst_zipreadertest.cpp 2KB main.cpp 2KB main.cpp 2KB xlsxsimpleooxmlfile.cpp 2KB xlsxsimpleooxmlfile.cpp 2KB main.cpp 1KB main.cpp 1KB main.cpp 1KB main.cpp 1KB共 375 条
- 1
- 2
- 3
- 4
资源评论
