labview中excel报告生成功能开发.htm

LabVIEW报告生成工具包通过ActiveX技术将Microsoft Word和Excel与LabVIEW集成开发环境结合起来

      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>&nbsp;</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">