資源簡介
QtXlsx是一個可以讀寫excel的跨平臺庫，他不需要你安裝ms excel，支持Qt5支持的任何平臺。
你可以：
創(chuàng)建一個新的Xlsx文件，
讀取Xlsx文件，
編輯Xlsx文件。
注意：此庫好像不支持xls文件。
示例代碼：
#include <QtXlsx>
int main()
{
QXlsx::Document xlsx;
xlsx.write("A1", "Hello Qt!");
xlsx.saveAs("Test.xlsx");
return 0;
}
代碼片段和文件信息
#include?
#include?“xlsxdocument.h“
#include?“xlsxformat.h“
#include?“xlsxcellrange.h“
#include?“xlsxworksheet.h“
QTXLSX_USE_NAMESPACE
int?main（int?argc?char?**argv）
{
????QCoreApplication?app（argc?argv）;
????//Select?a?proper?locale
????//QLocale::setDefault（QLocale（QLocale::English））;
????Document?xlsx;
????QDate?today（QDate::currentDate（））;
????for?（int?month=1;?month<=12;?++month）?{
????????xlsx.addSheet（QLocale（）.monthName（month））;
????????xlsx.currentWorksheet（）->setGridLinesVisible（false）;
????????//the?header?row
????????Format?headerstyle;
????????headerstyle.setFontSize（48）;
????????headerstyle.setFontColor（Qt::darkBlue）;
????????headerstyle.setHorizontalAlignment（Format::AlignHCenter）;
????????headerstyle.setVerticalAlignment（Format::AlignVCenter）;
????????xlsx.se ?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2014-04-30?14:23??QtXlsxWriter-master\
?????文件?????????357??2014-04-30?14:23??QtXlsxWriter-master\.gitignore
?????文件??????????46??2014-04-30?14:23??QtXlsxWriter-master\.qmake.conf
?????文件????????3171??2014-04-30?14:23??QtXlsxWriter-master\README.md
?????目錄???????????0??2014-04-30?14:23??QtXlsxWriter-master\examples\
?????文件??????????35??2014-04-30?14:23??QtXlsxWriter-master\examples\examples.pro
?????目錄???????????0??2014-04-30?14:23??QtXlsxWriter-master\examples\xlsx\
?????目錄???????????0??2014-04-30?14:23??QtXlsxWriter-master\examples\xlsx\calendar\
?????文件?????????132??2014-04-30?14:23??QtXlsxWriter-master\examples\xlsx\calendar\calendar.pro
?????文件????????5913??2014-04-30?14:23??QtXlsxWriter-master\examples\xlsx\calendar\main.cpp
?????目錄???????????0??2014-04-30?14:23??QtXlsxWriter-master\examples\xlsx\chart\
?????文件?????????129??2014-04-30?14:23??QtXlsxWriter-master\examples\xlsx\chart\chart.pro
?????文件????????2005??2014-04-30?14:23??QtXlsxWriter-master\examples\xlsx\chart\main.cpp
?????目錄???????????0??2014-04-30?14:23??QtXlsxWriter-master\examples\xlsx\chartsheet\
?????文件?????????134??2014-04-30?14:23??QtXlsxWriter-master\examples\xlsx\chartsheet\chartsheet.pro
?????文件?????????699??2014-04-30?14:23??QtXlsxWriter-master\examples\xlsx\chartsheet\main.cpp
?????目錄???????????0??2014-04-30?14:23??QtXlsxWriter-master\examples\xlsx\conditionalformatting\
?????文件?????????129??2014-04-30?14:23??QtXlsxWriter-master\examples\xlsx\conditionalformatting\conditionalformatting.pro
?????目錄???????????0??2014-04-30?14:23??QtXlsxWriter-master\examples\xlsx\conditionalformatting\doc\
?????目錄???????????0??2014-04-30?14:23??QtXlsxWriter-master\examples\xlsx\conditionalformatting\doc\src\
?????文件?????????326??2014-04-30?14:23??QtXlsxWriter-master\examples\xlsx\conditionalformatting\doc\src\conditionalformatting.qdoc
?????文件????????1931??2014-04-30?14:23??QtXlsxWriter-master\examples\xlsx\conditionalformatting\main.cpp
?????目錄???????????0??2014-04-30?14:23??QtXlsxWriter-master\examples\xlsx\datavalidation\
?????文件?????????138??2014-04-30?14:23??QtXlsxWriter-master\examples\xlsx\datavalidation\datavalidation.pro
?????文件?????????538??2014-04-30?14:23??QtXlsxWriter-master\examples\xlsx\datavalidation\main.cpp
?????目錄???????????0??2014-04-30?14:23??QtXlsxWriter-master\examples\xlsx\definename\
?????文件?????????134??2014-04-30?14:23??QtXlsxWriter-master\examples\xlsx\definename\definename.pro
?????文件?????????826??2014-04-30?14:23??QtXlsxWriter-master\examples\xlsx\definename\main.cpp
?????目錄???????????0??2014-04-30?14:23??QtXlsxWriter-master\examples\xlsx\demo\
?????文件?????????128??2014-04-30?14:23??QtXlsxWriter-master\examples\xlsx\demo\demo.pro
?????目錄???????????0??2014-04-30?14:23??QtXlsxWriter-master\examples\xlsx\demo\doc\
............此處省略218個文件信息
- 上一篇：MSP430驅動AD9851DDS
- 下一篇：eng轉nc軟件art
評論
共有 條評論