本篇文章讲述了如何在windows环境下为Qt5安装Qxlsx模块,以及Qxlsx模块的简单使用。
Perl+QtXlsx下载:https://download.csdn.net/download/u014779536/12543960
示例工程下载:https://download.csdn.net/download/u014779536/12543987
1. 未安装Qxlsx的程序效果
- 新建一个程序,在
pro
文件中加入:
QT += xlsx
- 在界面中添加一个按钮,设置以下槽函数:
/*
* @brief 点击自动生成按钮
*/
void Widget::on_Btn_clicked()
{
//![0]
QXlsx::Document xlsx("EXCEL模板.xlsx");
//![0]
<span class="token comment">//![1]</span>
xlsx<span class="token punctuation">.</span><span class="token function">write</span><span class="token punctuation">(</span><span class="token string">"A1"</span><span class="token punctuation">,</span> <span class="token string">"Hello Qt!"</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
<span class="token comment">//![1]</span>
<span class="token comment">//![2]</span>
xlsx<span class="token punctuation">.</span><span class="token function">saveAs</span><span class="token punctuation">(</span><span class="token string">"生成的Qxlsx表格.xlsx"</span><span class="token punctuation">)</span><span class="token punctuation">;</span>
<span class="token comment">//xlsx.save();</span>
<span class="token comment">//![2]</span>
}
}
成功生成:
预览:
5.3 Qt xlsx官方教程
教程地址:http://qtxlsx.debao.me/
6. 教程相关文件下载:
Perl+QtXlsx下载:https://download.csdn.net/download/u014779536/12543960
示例工程下载:https://download.csdn.net/download/u014779536/12543987
</div><div><div></div></div>
<link href="https://csdnimg.cn/release/phoenix/mdeditor/markdown_views-60ecaf1f42.css" rel="stylesheet">
</div>