⑴ 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;
}