?? labview中excel報(bào)告生成功能開發(fā).htm
字號(hào):
<!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報(bào)告生成功能開發(fā)</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'">報(bào)告生成功能開發(fā)</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">江西省電力試驗(yàn)研究院，江西南昌</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">報(bào)告生成工具包生成包含數(shù)據(jù)、文</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">格式報(bào)告的</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">自動(dòng)化技術(shù)</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'">對(duì)報(bào)告生成工具包進(jìn)行二次開發(fā)的過程。</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>關(guān)鍵詞：</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'">；報(bào)告；</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'">自動(dòng)化</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">報(bào)告生成工具包簡介</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">報(bào)告生成工具包通過</SPAN><SPAN
lang=EN-US>ActiveX</SPAN><SPAN
style="mso-ascii-font-family: Times New Roman; mso-hansi-font-family: Times New Roman">技術(shù)將</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">集成開發(fā)環(huán)境</SPAN><SPAN
lang=EN-US><O:P></SPAN><SPAN
style="mso-ascii-font-family: Times New Roman; mso-hansi-font-family: Times New Roman">結(jié)合起來，用于快速生成專業(yè)的報(bào)告，從而高效地表示出各種測(cè)試數(shù)據(jù)和結(jié)果。用戶可以移</SPAN><SPAN
lang=EN-US><O:P></SPAN><SPAN
style="mso-ascii-font-family: Times New Roman; mso-hansi-font-family: Times New Roman">植、修改現(xiàn)有的報(bào)告模板，并使用標(biāo)準(zhǔn)的</SPAN><SPAN
lang=EN-US>LabVIEW</SPAN><SPAN
style="mso-ascii-font-family: Times New Roman; mso-hansi-font-family: Times New Roman">功能，擴(kuò)展該工具包的報(bào)告生成功能；通</SPAN><SPAN
lang=EN-US><O:P></SPAN><SPAN
style="mso-ascii-font-family: Times New Roman; mso-hansi-font-family: Times New Roman">過運(yùn)行由</SPAN><SPAN
lang=EN-US>VBA</SPAN><SPAN
style="mso-ascii-font-family: Times New Roman; mso-hansi-font-family: Times New Roman">編寫的宏代碼還可以進(jìn)一步自定義修改報(bào)告生成過程并自動(dòng)生成報(bào)告。<BR> </SPAN><SPAN
lang=EN-US>LabVIEW</SPAN><SPAN
style="mso-ascii-font-family: Times New Roman; mso-hansi-font-family: Times New Roman">報(bào)告生成工具包包含了</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">類似傳統(tǒng)語言的函數(shù)或過程</SPAN><SPAN
lang=EN-US>)</SPAN><SPAN
style="mso-ascii-font-family: Times New Roman; mso-hansi-font-family: Times New Roman">：①高級(jí)報(bào)告生成</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">，用于新建報(bào)告和進(jìn)行常規(guī)操作。②專門用于生成</SPAN><SPAN
lang=EN-US>Word</SPAN><SPAN
style="mso-ascii-font-family: Times New Roman; mso-hansi-font-family: Times New Roman">格式的報(bào)告</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">代碼自定義各種復(fù)雜的</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">格式的報(bào)告</SPAN><SPAN
lang=EN-US>VIs</SPAN><SPAN
style="mso-ascii-font-family: Times New Roman; mso-hansi-font-family: Times New Roman">，其除了能進(jìn)行常規(guī)的</SPAN><SPAN
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -