📄 labview中excel报告生成功能开发.htm
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<!-- saved from url=(0049)http://www.bjx.com.cn/files/wx/ybjs/2005-3/22.htm -->
<HTML><HEAD><TITLE>LabVIEW中Excel报告生成功能开发</TITLE>
<META http-equiv=Content-Type content="text/html; charset=gb2312">
<META content="MSHTML 6.00.2900.3086" name=GENERATOR>
<META content=FrontPage.Editor.Document name=ProgId></HEAD>
<BODY>
<DIV align=center>
<CENTER>
<TABLE cellSpacing=0 cellPadding=0 width="90%" border=0>
<TBODY>
<TR>
<TD width="100%">
<P class=MsoNormal align=center><B><FONT face=宋体 size=5><SPAN
lang=EN-US>LabVIEW</SPAN><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">中</SPAN><SPAN
lang=EN-US>Excel</SPAN><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">报告生成功能开发</SPAN><SPAN
lang=EN-US><O:P> </SPAN></FONT></B></P>
<P class=MsoNormal align=center><FONT face=宋体 size=3><B><SPAN
style="mso-ascii-font-family: Times New Roman; mso-hansi-font-family: Times New Roman">汪翠英，裴 锋</SPAN><SPAN
lang=EN-US><O:P></O:P> </SPAN></B></FONT></P>
<P class=MsoNormal align=center><SPAN lang=EN-US><B><FONT face=宋体
size=3>(</FONT></B></SPAN><FONT face=宋体 size=3><B><SPAN
style="mso-ascii-font-family: Times New Roman; mso-hansi-font-family: Times New Roman">江西省电力试验研究院，江西南昌</SPAN></B><SPAN
lang=EN-US> <B>330006)</B><O:P></O:P> </SPAN></FONT></P>
<P class=MsoNormal><FONT face=宋体 size=3><SPAN
style="mso-ascii-font-family: Times New Roman; mso-hansi-font-family: Times New Roman"> <B>摘 要：</B>介绍利用</SPAN><SPAN
lang=EN-US>LabVIEW</SPAN><SPAN
style="mso-ascii-font-family: Times New Roman; mso-hansi-font-family: Times New Roman">报告生成工具包生成包含数据、文</SPAN><SPAN
lang=EN-US><O:P></SPAN><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">本、表格、图表、图片以及</SPAN><SPAN
lang=EN-US>VBA</SPAN><SPAN
style="mso-ascii-font-family: Times New Roman; mso-hansi-font-family: Times New Roman">宏的</SPAN><SPAN
lang=EN-US>Excel</SPAN><SPAN
style="mso-ascii-font-family: Times New Roman; mso-hansi-font-family: Times New Roman">格式报告的</SPAN><SPAN
lang=EN-US>3</SPAN><SPAN
style="mso-ascii-font-family: Times New Roman; mso-hansi-font-family: Times New Roman">种方法，及通过</SPAN><SPAN
lang=EN-US>ActiveX</SPAN><SPAN
style="mso-ascii-font-family: Times New Roman; mso-hansi-font-family: Times New Roman">自动化技术</SPAN><SPAN
lang=EN-US><O:P></SPAN><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">对报告生成工具包进行二次开发的过程。</SPAN><SPAN
lang=EN-US><O:P><BR> </SPAN><SPAN
style="mso-ascii-font-family: Times New Roman; mso-hansi-font-family: Times New Roman"><B>关键词：</B></SPAN><SPAN
lang=EN-US>LabVIEW</SPAN><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">；</SPAN><SPAN
lang=EN-US>Excel</SPAN><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">；报告；</SPAN><SPAN
lang=EN-US>ActiveX</SPAN><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">自动化</SPAN></FONT></P>
<P class=MsoNormal align=center><SPAN lang=EN-US><B><FONT face=宋体
size=2>Development of Excel Report Generation Function Based on
LabVIEW<O:P> </FONT></B></SPAN></P>
<P class=MsoNormal align=center><SPAN lang=EN-US><FONT face=宋体 size=2>WANG
Cuiying, PEI Feng</FONT></SPAN></P>
<P class=MsoNormal align=center><SPAN lang=EN-US><FONT face=宋体
size=2>(Jiangxi Electrical Power Testing and Research Institute, Nanchang
33<O:P> 0006, China)</FONT></SPAN></P>
<P class=MsoNormal><FONT size=2><SPAN lang=EN-US><FONT
face=宋体> <B>Abstract: </B>Three approaches were introduced to
automatically crea<O:P> te reports in Microsoft Excel, including data,
text, table, graph, picture and V<O:P> BA micro codes. It was also
presented the process of secondary development for t<O:P> he toolkit
through ActiveX automation
technology.<BR></FONT></SPAN> <B> </B></FONT><SPAN lang=EN-US><FONT
face=宋体 size=2><B>Key words:</B> LabVIEW; Excel; report; ActiveX
automation</FONT><FONT face=宋体 size=3><O:P></FONT></SPAN></P>
<P class=MsoNormal><BR><FONT face=宋体 size=4><B><SPAN
lang=EN-US>1LabVIEW</SPAN><SPAN
style="mso-ascii-font-family: Times New Roman; mso-hansi-font-family: Times New Roman">报告生成工具包简介</SPAN></B></FONT><SPAN
lang=EN-US><FONT face=宋体 size=4><B><O:P><BR></B></FONT><FONT face=宋体
size=3> LabVIEW</FONT></SPAN><FONT face=宋体 size=3><SPAN
style="mso-ascii-font-family: Times New Roman; mso-hansi-font-family: Times New Roman">报告生成工具包通过</SPAN><SPAN
lang=EN-US>ActiveX</SPAN><SPAN
style="mso-ascii-font-family: Times New Roman; mso-hansi-font-family: Times New Roman">技术将</SPAN><SPAN
lang=EN-US>Microsoft Word</SPAN><SPAN
style="mso-ascii-font-family: Times New Roman; mso-hansi-font-family: Times New Roman">和</SPAN><SPAN
lang=EN-US>Excel</SPAN><SPAN
style="mso-ascii-font-family: Times New Roman; mso-hansi-font-family: Times New Roman">与</SPAN><SPAN
lang=EN-US>LabVIEW</SPAN><SPAN
style="mso-ascii-font-family: Times New Roman; mso-hansi-font-family: Times New Roman">集成开发环境</SPAN><SPAN
lang=EN-US><O:P></SPAN><SPAN
style="mso-ascii-font-family: Times New Roman; mso-hansi-font-family: Times New Roman">结合起来，用于快速生成专业的报告，从而高效地表示出各种测试数据和结果。用户可以移</SPAN><SPAN
lang=EN-US><O:P></SPAN><SPAN
style="mso-ascii-font-family: Times New Roman; mso-hansi-font-family: Times New Roman">植、修改现有的报告模板，并使用标准的</SPAN><SPAN
lang=EN-US>LabVIEW</SPAN><SPAN
style="mso-ascii-font-family: Times New Roman; mso-hansi-font-family: Times New Roman">功能，扩展该工具包的报告生成功能；通</SPAN><SPAN
lang=EN-US><O:P></SPAN><SPAN
style="mso-ascii-font-family: Times New Roman; mso-hansi-font-family: Times New Roman">过运行由</SPAN><SPAN
lang=EN-US>VBA</SPAN><SPAN
style="mso-ascii-font-family: Times New Roman; mso-hansi-font-family: Times New Roman">编写的宏代码还可以进一步自定义修改报告生成过程并自动生成报告。<BR> </SPAN><SPAN
lang=EN-US>LabVIEW</SPAN><SPAN
style="mso-ascii-font-family: Times New Roman; mso-hansi-font-family: Times New Roman">报告生成工具包包含了</SPAN><SPAN
lang=EN-US>3</SPAN><SPAN
style="mso-ascii-font-family: Times New Roman; mso-hansi-font-family: Times New Roman">类</SPAN><SPAN
lang=EN-US>VIs(</SPAN><SPAN
style="mso-ascii-font-family: Times New Roman; mso-hansi-font-family: Times New Roman">类似传统语言的函数或过程</SPAN><SPAN
lang=EN-US>)</SPAN><SPAN
style="mso-ascii-font-family: Times New Roman; mso-hansi-font-family: Times New Roman">：①高级报告生成</SPAN><SPAN
lang=EN-US>VIs<O:P></SPAN><SPAN
style="mso-ascii-font-family: Times New Roman; mso-hansi-font-family: Times New Roman">，用于新建报告和进行常规操作。②专门用于生成</SPAN><SPAN
lang=EN-US>Word</SPAN><SPAN
style="mso-ascii-font-family: Times New Roman; mso-hansi-font-family: Times New Roman">格式的报告</SPAN><SPAN
lang=EN-US>VIs</SPAN><SPAN
style="mso-ascii-font-family: Times New Roman; mso-hansi-font-family: Times New Roman">，其中包括了文档管</SPAN><SPAN
lang=EN-US><O:P></SPAN><SPAN
style="mso-ascii-font-family: Times New Roman; mso-hansi-font-family: Times New Roman">理、查找、替换、编辑和格式化</SPAN><SPAN
lang=EN-US>Word</SPAN><SPAN
style="mso-ascii-font-family: Times New Roman; mso-hansi-font-family: Times New Roman">中的图表、图片，通过编写</SPAN><SPAN
lang=EN-US>VBA</SPAN><SPAN
style="mso-ascii-font-family: Times New Roman; mso-hansi-font-family: Times New Roman">代码自定义各种复杂的</SPAN><SPAN
lang=EN-US><O:P></SPAN><SPAN
style="mso-ascii-font-family: Times New Roman; mso-hansi-font-family: Times New Roman">操作。③专门用于生成</SPAN><SPAN
lang=EN-US>Excel</SPAN><SPAN
style="mso-ascii-font-family: Times New Roman; mso-hansi-font-family: Times New Roman">格式的报告</SPAN><SPAN
lang=EN-US>VIs</SPAN><SPAN
style="mso-ascii-font-family: Times New Roman; mso-hansi-font-family: Times New Roman">，其除了能进行常规的</SPAN><SPAN
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -