⑴ linux下,如何使用C/C++對EXCEL進行讀寫!
可以輸出到csv(逗號間隔,具體搜索csv格式). csv可以在excel中直接導入。
也可以用system函數調用ssconvert從csv轉xlsx:
system("ssconvert test.csv test.xlsx");
如果沒有ssconvert命令,安裝gnumeric.
或者調用python腳本,通過python的xlwt模塊,對excel進行讀寫。
⑵ QtXlsx在linux下怎樣安裝
Usage(1): Use Xlsx as Qt5』s addon mole
1. Download the source code from github.com.
https://github.com/dbzhang800/QtXlsxWriter/archive/master.zip
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就可以了。
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;
}