?? labview中excel報告生成功能開發.htm
字號:
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><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></FONT></P>
<P class=MsoNormal><B><FONT face=宋體 size=4><SPAN
lang=EN-US>2Excel</SPAN><SPAN
style="mso-ascii-font-family: Times New Roman; mso-hansi-font-family: Times New Roman">格式報告功能開發</SPAN></FONT></B><BR> <FONT
face=宋體 size=3><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>Functions</SPAN><IMG height=12
src="LabVIEW中Excel報告生成功能開發.files/60-2.jpg" width=15 border=0><SPAN
lang=EN-US>Report Generation</SPAN><IMG height=12
src="LabVIEW中Excel報告生成功能開發.files/60-2.jpg" width=15 border=0><SPAN
lang=EN-US>Excel Specific VI<O:P>s</SPAN><SPAN
style="mso-ascii-font-family: Times New Roman; mso-hansi-font-family: Times New Roman">函數模板中的</SPAN><SPAN
lang=EN-US>Excel Easy Title.vi</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 Easy Text.vi</SPAN><SPAN
style="mso-ascii-font-family: Times New Roman; mso-hansi-font-family: Times New Roman">、</SPAN><SPAN
lang=EN-US>Excel Easy Table.vi</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<O:P></SPAN></FONT><SPAN lang=EN-US><FONT face=宋體
size=3>Easy Graph.vi 4</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>VIs</SPAN><SPAN
style="mso-ascii-font-family: Times New Roman; mso-hansi-font-family: Times New Roman">和</SPAN><SPAN
lang=EN-US>General</SPAN><SPAN
style="FONT-FAMILY: 宋體; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">、</SPAN><SPAN
lang=EN-US>Format</SPAN><SPAN
style="FONT-FAMILY: 宋體; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">、</SPAN><SPAN
lang=EN-US>Graphs and Pictures</SPAN><SPAN
style="mso-ascii-font-family: Times New Roman; mso-hansi-font-family: Times New Roman">、</SPAN><SPAN
lang=EN-US>Advanced 4</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></FONT><BR><FONT
face=宋體 size=3><B><SPAN lang=EN-US>2.1</SPAN><SPAN
style="mso-ascii-font-family: Times New Roman; mso-hansi-font-family: Times New Roman">直接輸出</SPAN><SPAN
lang=EN-US>Excel</SPAN></B><SPAN
style="mso-ascii-font-family: Times New Roman; mso-hansi-font-family: Times New Roman"><B>格式報告</B><BR> </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>Excel</SPAN><SPAN
style="mso-ascii-font-family: Times New Roman; mso-hansi-font-family: Times New Roman">文檔報告的過程,框圖程序見圖</SPAN><SPAN
lang=EN-US>1</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">成包含文本、表格、圖表的報告。<BR></SPAN></FONT> <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>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>Functions</SPAN><IMG height=12
src="LabVIEW中Excel報告生成功能開發.files/60-2.jpg" width=15 border=0><SPAN
lang=EN-US>Report Generation</SPAN><SPAN
style="mso-ascii-font-family: Times New Roman; mso-hansi-font-family: Times New Roman">模板中選擇</SPAN><SPAN
lang=EN-US>New <O:P>Report.vi</SPAN><SPAN
style="mso-ascii-font-family: Times New Roman; mso-hansi-font-family: Times New Roman">,將其放置在框圖程序中,設置</SPAN><SPAN
lang=EN-US>report type</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>LabV<O:P>lEW</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>Microsoft Excel</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><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>minimized</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 <O:P>Easy Title.vi</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>Title</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 Easy<O:P></SPAN></FONT><SPAN lang=EN-US><SPAN
style="mso-spacerun: yes"><FONT face=宋體 size=3> </FONT></SPAN><FONT
face=宋體 size=3>Text.vi</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>start</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>end</SPAN><SPAN
style="mso-ascii-font-family: Times New Roman; mso-hansi-font-family: Times New Roman">為右下腳單元格,</SPAN><SPAN
lang=EN-US>border</SPAN><SPAN
style="mso-ascii-font-family: Times New Roman; mso-hansi-font-family: Times New Roman">值為</SPAN><SPAN
lang=EN-US>Ture</SPAN><SPAN
style="mso-ascii-font-family: Times New Roman; mso-hansi-font-family: Times New Roman">,即顯示文本框。</SPAN><SPAN
lang=EN-US>Excel Easy Table.vi</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>Test Table</SPAN><SPAN
style="mso-ascii-font-family: Times New Roman; mso-hansi-font-family: Times New Roman">賦值給</SPAN><SPAN
lang=EN-US>Excel Easy Table.vi</SPAN><SPAN
style="mso-ascii-font-family: Times New Roman; mso-hansi-font-family: Times New Roman">,并顯示表頭。</SPAN></FONT></P>
<P class=MsoNormal align=center><IMG height=148
src="LabVIEW中Excel報告生成功能開發.files/60-1.jpg" width=479 border=0><FONT
face=宋體 size=3><SPAN
style="mso-ascii-font-family: Times New Roman; mso-hansi-font-family: Times New Roman">
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -