?? 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 + -