鎽� 瑕侊細鍫辫〃鐢熸垚鍔熻兘鏄竴鍊嬪畬鍌欑殑铏涙摤鍎€鍣ㄦ脯瑭︾郴绲�(t菕ng)鐨勯噸瑕佺祫鎴愰儴鍒�銆傛瘮杓冧簡鍏╃óLabVIEW骞宠嚭涓嬪牨琛ㄧ敓鎴愭柟娉曞強鐗归粸銆傞噸榛為棥杩癓abVIEW鑸嘐xcel鐨勬暩(sh霉)鎿�(j霉)閫氫俊锛屽苟娣诲姞浜嗚伈闊冲牨璀︺€佽嚜鍕曟墦鍗板姛鑳�锛屾彁楂樹簡鏁�(sh霉)鎿�(j霉)鐨勫彲闈犳€ц垏瀹夊叏鎬с€� 闂�(gu膩n)閸佃锛�铏涙摤鍎€鍣ㄦ脯瑭︾郴绲�(t菕ng);鍫辫〃鐢熸垚;琛ㄦ牸铏曠悊杌熶欢 [b][align=center]The Development of Complicated Report Generation Technology in LabVIEW ZHANG Pei JIANG Ying XU Wei-ming ZUO Xiao-wu[/align][/b] Abstract The function of report generation is an important part of a complete Virtual Instrument system. Two methods of report generation based on LabVIEW and their characteristics are compared. Described the technology that LabVIEW is programmed jointly with Excel, appended the function of vocal alarming and automatic printing, which improves the data鈥檚 credibility and security. Key words LabVIEW; Report Generation; Excel 1 寮曡█ 銆€銆€鎵撳嵃鍫辫〃鏄脯鎺х郴绲�(t菕ng)鏅亶瑕佹眰鐨勪竴闋呭熀鏈姛鑳�锛屼緥濡傚皪鐢�(ch菐n)鍝侀€茶娓│瑕佹湁娓│鍫卞憡锛岄暦鏈熸娓竴鍊嬬敓鐢�(ch菐n)閬庣▼瑕佹眰鏈夌敓鐢�(ch菐n)鏃ュ牨琛ㄧ瓑锛屽皪鍫辫〃鐨勫鏅傛€ф彁鍑轰簡瑕佹眰銆傜洰鍓嶏紝骞剧ó鐢ㄤ簬鐢熸垚鍫辫〃鐨勮粺浠舵湁Visual Basic銆丮atlab Report Generator绛夈€侺abVIEW鏄疦I鍏徃閫€鍑虹殑涓€绋熀浜嶨瑾炶█鐨勮櫅鎿剙鍣ㄨ粺浠堕枊鐧�(f膩)宸ュ叿銆傚埄鐢↙abVIEW鍙互寰堟柟渚垮湴鐢熸垚涓€鍊嬭櫅鎿剙鍣ㄧ郴绲�(t菕ng)锛屽畬鎴愪俊铏熺殑閲囬泦銆佹暩(sh霉)鎿�(j霉)铏曠悊绛変换鍕欐(g貌u)鎴愪竴鍊嬪畬鏁寸殑娓│绯荤当(t菕ng)銆侺abVIEW鏈韩甯舵湁寮峰ぇ鐨勫牨琛ㄧ敓鎴愬姛鑳�锛岃兘鑸囧绋噳鐢ㄧ▼搴忕殑閫氳▕鎴愮偤鍫辫〃鐢熸垚鎶€琛�(sh霉)涓閬哥殑宸ュ叿銆傜洰鍓嶅凡澶ч噺鐢ㄤ簬娓│绯荤当(t菕ng)鐨勫悗鏈熸暩(sh霉)鎿�(j霉)铏曠悊涓紝绛嗚€呭湪绺界祼(ji茅)鍓嶄汉闁嬬櫦(f膩)鍫辫〃鐢熸垚鍔熻兘鐨勫熀绀�(ch菙)涓�锛屾坊鍔犱簡涓€浜涙柊鍔熻兘锛屼互瀹屽杽鏁村€嬫脯瑭︾郴绲�(t菕ng)銆� 2 鍫辫〃鐢熸垚鍔熻兘鐨勫畬鍠� 銆€銆€鍫辫〃鐢熸垚鏂规硶鍙互閫氶亷閫欎箞骞剧ó鏂规硶[1]锛氱洿鎺ヤ娇鐢∟I鍏徃鐨凴eport Generation Toolkit鐢熸垚鍫辫〃;浣跨敤File I/O椤炲嚱鏁�(sh霉)鐢熸垚鍫辫〃;浣跨敤Report Generation椤炲嚱鏁�(sh霉)鐢熸垚鍫辫〃;鍒╃敤Excel鐢熸垚鍫辫〃銆傜劧鑰岋紝鐢变簬Report Generation Toolkit妯″娌掓湁闆嗘垚鍦↙abVIEW涓�锛岄爤椤嶅璩艰卜锛屾€у児姣斾笉楂�;File I/O椤炲嚱鏁�(sh霉)鐢熸垚鐨勫牨琛ㄥ彲璁€鎬у樊锛屾ǎ寮忕啊鍠紝鍥犳鐩墠鏅亶閲囩敤鍚庡叐绋柟寮�銆� 銆€銆€2.1 浣跨敤Report Generation椤炲嚱鏁�(sh霉)鐢熸垚鍫辫〃 銆€銆€浣跨敤閫欑ó鏂规硶鍙互鎵撳嵃鏍煎紡姣旇純寰╅洔鐨勫牨琛紝鑰屼笖鎿嶄綔绨″柈銆侺abVIEW涓殑Report Generation瀛愭ā鏉夸腑鎻愪緵浜嗚睈瀵岀殑鍑芥暩(sh霉)[2]銆傚緸鐢熸垚涓€鍊嬫柊鐨勫牨琛�锛岃ō(sh猫)缃牨琛ㄩ爜閭婅窛銆佹柟鍚�銆侀爜鐪夋枃鏈�锛屽悜鍫辫〃涓坊鍔犳枃瀛�銆佸湒鐗囧拰琛ㄦ牸绛夊埌鎵撳嵃鍫辫〃閮芥湁鍏ㄧ▼鐨勫公鍔╂枃浠朵緵闁嬬櫦(f膩)鑰呬娇鐢�銆備互鐢�(ch菐n)鍝佹椹楀牨鍛婄偤渚�锛屽牨琛ㄧ敓鎴愮殑绋嬪簭濡傚湒1鎵€绀恒€� [align=center] 鍦�1 浣跨敤Report Generation椤炲嚱鏁�(sh霉)鐢熸垚鍫辫〃妗嗗湒[/align] 銆€銆€鐢卞湒涓�锛屽湪鍫辫〃涓坊鍔犱簡鏇茬窔銆佹暩(sh霉)鎿�(j霉)銆佽〃鏍肩瓑锛屾渶绲傞€氶亷涓€鍊婥ase瑾炲彞鍦↙abVIEW涓荤▼搴忎腑鐩存帴鎵撳嵃鍫辫〃锛屽墠闈㈡澘濡傚湒2鎵€绀恒€傝娉ㄦ剰鐨勬槸锛岀敱浜庢墦鍗板牨琛ㄥ彧鑳芥墦鍗扮灛闁撶殑鏁�(sh霉)鎿�(j霉)鍊�锛屾晠瑕佹眰鎵撳嵃鍦栨鎸夐垥涓嶈兘闀锋湡铏曚簬闁夊悎鐙€鎱�(t脿i)锛屽湪姝よō(sh猫)缃甅echanical Action鐐篖atch when pressed銆� [align=center] 鍦�2浣跨敤ReportGeneration椤炲嚱鏁�(sh霉)鐢熸垚鍫辫〃鍓嶉潰鏉縖/align] 銆€銆€浣跨敤瑭叉柟娉曢洊鐒舵搷浣滅啊鍠�锛屼絾涔熸湁涓€浜涗笉瓒炽€傛瘮濡�锛屽皪浜庡京闆滅殑鏁�(sh霉)鎿�(j霉)灏遍’寰楀姏涓嶅緸蹇�;鍦ㄥ闅涙脯瑭︾郴绲�(t菕ng)涓姹傛脯閲忕殑榛炴暩(sh霉)寰€寰€涓婄櫨鍊�锛屽ぇ鎵圭殑鏁�(sh霉)鎿�(j霉)瑕佸湪LabVIEW瑕佸湪鍓嶉潰鏉夸腑瑷�(sh猫)缃’鐒朵笉鍒囧闅�;闆栫劧瀵︾従(xi脿n)浜嗘墦鍗板姛鑳斤紝浣嗘墦鍗版晥鏋滀笉绗﹀悎鍌崇当(t菕ng)瑙€蹇典腑鐨勫牨琛�锛屾暩(sh霉)鎿�(j霉)鍙Щ妞嶆€т笉楂�銆傞憭浜庢锛屾彁鍑虹敤Excel鐢熸垚鍫辫〃銆� 銆€銆€2.2 鍒╃敤Excel鐢熸垚鍫辫〃 銆€銆€Microsoft Excel鏄挤澶х殑鏁�(sh霉)鎿�(j霉)铏曠悊杌熶欢锛屾噳鐢ㄦサ鐐哄唬娉�锛岄€氶亷鑸嘗abVIEW鐨勭祼(ji茅)鍚�锛屽皣閲囬泦鍒扮殑鏁�(sh霉)鎿�(j霉)鍌抽€佸埌Excel涓�锛屽厖鍒嗗埄鐢ㄤ簡鍏╄€呯殑鍔熻兘銆侲xcel鏈韩鍚湁澶ч噺鐨勬ā鏉�锛岀敤鎴跺彲浠ラ爯鍏堝畾鍒舵ā鏉夸互纰哄畾鍫卞憡鏍煎紡锛岄€氶亷鍏╁ぇ鎳夌敤绋嬪簭涔嬮枔鐨勯€氳▕鍗�(xi茅)璀�锛屽埄鐢―DE鍜孉ctiveX鏂瑰紡鐢熸垚鍫辫〃锛岀劧鍚庡湪绋嬪簭涓坊鍔犺獮闊虫晥鏋�銆佹墦鍗板姛鑳姐€佹暩(sh霉)鎿�(j霉)淇濆瓨绛夊姛鑳�锛岄€蹭竴姝ュ畬鍠勫牨琛ㄧ殑闄勫付鍔熻兘銆備笅闈互閸嬬垚渚涚啽鑷嫊鎺у埗绯荤当(t菕ng)鐨勫牨琛ㄧ▼搴忕偤渚嬶紝浠嬬垂涓€鍊嬪姛鑳介綂鍏ㄧ殑鍫辫〃鐢熸垚绯荤当(t菕ng)銆� [align=center] 鍦�3 鍫辫〃鐢熸垚鍓嶉潰鏉縖/align] 銆€銆€棣栧厛锛屽牨琛ㄧ殑涓荤晫闈㈠鍦�3鎵€绀�锛岀敤鎴跺彲浠ヨō(sh猫)缃牨琛ㄧ敓鎴愬嵆Excel鏂囦欢鐢熸垚鐨勮矾寰�锛屽湪鍫辫〃鍚嶇ū銆佸牨琛ㄧ敓鎴愮殑璧峰鑸囩祩姝㈡檪闁撹檿鍒嗗垾濉叆闇€瑕佺殑鍙冩暩(sh霉)銆傚乏鏂圭偤鍚勯爡娓噺鎸囨鐨勫悕绋�锛岀敤鎴跺彲浠ユ牴鎿�(j霉)闇€瑕佷慨鏀癸紝鑰屼笖瑷�(sh猫)缃簡鍐椾綑闋�锛屽湪鍙充笅瑙掔殑瑕佹脯鐨勬寚妯欎腑閬告搰鏁�(sh霉)鐩�锛屼富鐣岄潰鍙嚜鍕曟摯灞曟寚妯欓爡渚涚敤鎴舵坊鍔�銆� 銆€銆€鍏舵锛屽鐢ㄦ埗闇€瑕佹墦鍗板墠闈㈡澘锛屽彲浠ユ寜鎵撳嵃鍓嶉潰鏉挎寜閳曞鐝�(xi脿n)銆傜晫闈㈢殑鍙充笅瑙掗檮鏈変娇鐢ㄨ鏄�锛屾柟渚块枊鐧�(f膩)鑰呰垏鐢ㄦ埗鐨勬簼閫氥€傞儴鍒嗙▼搴忔鍦栧鍦�4銆�5鎵€绀恒€� [align=center] 鍦�4 瑷�(sh猫)缃矾寰戣垏琛ㄥ悕[/align] [align=center] 鍦�5 鍚慐xcel鍌抽€佹暩(sh霉)鎿�(j霉)[/align] 銆€銆€鐢变簬LabVIEW鎻愪緵浜嗚嚜鍕曟墦鍗扮殑鍔熻兘锛屾晠瑕佹墦鍗板墠闈㈡澘涓殑鏇茬窔锛屽彧闇€瑕佸皣闇€瑕佹墦鍗扮殑灏嶈薄鍋氭垚瀛怴I锛岀暥绋嬪簭瑾�(di脿o)鐢ㄨ┎瀛怴I鏅傚鐝�(xi脿n)鎵撳嵃鍔熻兘[3]銆備富绋嬪簭妗嗗湒濡傚湒6鎵€绀�锛岃┎鏂规硶瀵︾従(xi脿n)鐨勯棞(gu膩n)閸甸粸鍦ㄤ簬锛氫富绋嬪簭闇€瑕佸皣鏇茬窔鍧愭鐨勪笂涓嬮檺鍌崇郸瀛怴I锛岄€氶亷灞€х瘈(ji茅)榛炲鐝�(xi脿n)锛屽鍦栦腑鎵€绀恒€� [align=center] 鍦�6 鑷嫊鎵撳嵃涓荤▼搴忔鍦朳/align] 銆€銆€鏈€鍚�锛屽湪瑭茬郴绲�(t菕ng)涓姞鍏ヨ伈闊冲牨璀﹀姛鑳絒4]銆傚湪绶氭娓郴绲�(t菕ng)涓€鑸兘闇€瑕佸牨璀﹀姛鑳�锛屽鐝�(xi脿n)鐨勬柟娉曠偤鍦ㄧ▼搴忎腑闋愬厛閷勫叆涓€娈佃伈闊�锛岀暥鍫辫〃鐢熸垚閬庣▼涓嚭鐝�(xi脿n)鍫遍尟绛夋剰澶栧嚭閷檪锛屽彲浠ュ強鏅傛彁閱掑伐浣滀汉鍝�锛屼互鍏嶉€犳垚鍥犳暩(sh霉)鎿�(j霉)閷甯朵締鐨勪簨鏁咃紝閫欏湪宸ユキ(y猫)鐩�(ji膩n)鎺ч亷绋嬩腑鏄潪甯稿繀瑕佺殑銆傛垜鍊戦倓鏄埄鐢↙abVIEW涓殑鑱查煶鍑芥暩(sh霉)閷勫埗鑱查煶锛岀▼搴忔鍦栧鍦�7鎵€绀恒€� [align=center] 鍦�7 閷勫埗鑱查煶[/align] 銆€銆€鍦⊿I CONFIG鍑芥暩(sh霉)涓彲浠ラ伕鎿囩珛楂旇伈鎴栬€呭柈閫氶亾銆傜劧鍚庢垜鍊戞妸鐢熸垚鐨勬枃浠朵綔鐐鸿伈闊虫枃浠�锛屼綔鐐哄嚭閷牨璀︽檪鐨勬簮鏂囦欢锛屾鍦栧鍦�8鎵€绀�銆� [align=center] 鍦�8 鎾斁鑱查煶[/align] 3 绲�(ji茅)璜栬垏鎳夌敤 銆€銆€鍒版锛屼竴鍊嬪畬鏁寸殑鍔熻兘榻婂叏鐨勫牨琛ㄧ敓鎴愮郴绲�(t菕ng)宸茬稉(j墨ng)浠嬬垂濂戒簡銆傚苟宸插湪姹借粖鐔卞伐鎬ц兘娓│绯荤当(t菕ng)涓│鐢�锛屽ぇ澶ф笡杓曚簡宸ヤ綔浜哄摗鐨勬暩(sh霉)鎿�(j霉)瑷橀寗鐨勮矤鎿�锛屽悓鏅傛彁楂樹簡瀹夊叏鎬�銆佸彲闈犳€�锛屽湪鏁�(sh霉)鎿�(j霉)鍦栬〃鎵撳嵃鏂归潰鐪熸鍋氬埌浜嗘墍瑕嬪嵆鎵€鍑�銆� 銆€銆€鏈枃浣滆€呭壍(chu脿ng)鏂伴粸锛氶泦鎴愬悇绋姛鑳藉鏁�(sh霉)鎿�(j霉)銆佸湒琛ㄥ鏅傛墦鍗扮瓑锛岄枊鐧�(f膩)鍑轰簡涓€濂楀姛鑳介綂鍏ㄧ殑鍫辫〃鐢熸垚绯荤当(t菕ng)锛屾搷浣滅啊鍠�锛屾暩(sh霉)鎿�(j霉)鍙Щ妞嶆€у挤锛屽劒(y艒u)浜庣洰鍓嶆櫘閬嶄娇鐢ㄧ殑鍫辫〃鐢熸垚绯荤当(t菕ng);鍚屾檪锛屽湪绋嬪簭瑷�(sh猫)瑷堜腑娣诲姞浜嗗牨璀﹀姛鑳�锛岀偤宸ユ硜鐝�(xi脿n)鍫寸殑瀹夊叏鎬у拰鍙潬鎬ф彁渚涗簡淇濋殰銆� 鍙冭€冩枃鐛� 銆€銆€[1] 妤婃▊骞崇瓑.LabVIEW楂樼礆绋嬪簭瑷�(sh猫)瑷�.鍖椾含锛氭竻鑿ぇ瀛稿嚭鐗堢ぞ锛�2003. 銆€銆€[2] 鐭冲崥寮风瓑.LabVIEW绶ㄧ▼鎶€琛�(sh霉)瀵︾敤鏁欑▼.鍖椾含锛氫腑鍦嬮惖閬撳嚭鐗堢ぞ,2002. 銆€銆€[3] 瓒欐捣榫�.绲abVIEW涓殑灏嶈薄娣诲姞鑷嫊鎵撳嵃鍔熻兘[J].寰▓绠楁淇℃伅,2001,17锛�12锛�:32-34. 銆€銆€[4] 闆锋尟灞�.LabVIEW7Express瀵︾敤鎶€琛�(sh霉)鏁欑▼.鍖椾含锛氫腑鍦嬮惖閬撳嚭鐗堢ぞ,2005.