摘要
在视听新媒体监管工作中,根据监测数据撰写监看报告是重要的一环,需要做到数据统计准确、格式标准,在公文流转中有着重要的地位。提出一种基于VBA语言的报告自动生成方法,并基于RibbonX标准实现其用户界面,使代码插件化、可视化,提高监看工作的整体效率。
In the supervision work of audiovisual new media,it is an important step to write the report based on the monitoring data. It is essential to ensure the accuracy of the data statistics and the standard of format,which has an important position in the circulation of public documents. This article puts forward a method of automatic report generation based on VBA language,and implements its user interface based on RibbonX standard to make code a plug-in and visualized,and improves the overall efficiency of monitoring work.
引文
[1]王革田. VBA For Microsoft Excel在机械设计中的应用[J].机械制造,2003,41(10):57-59.
[2] J Green,S Bullen,R Bovey,M Alexander. Excel2007 VBA Programmer's Reference[J]. Wrox Press Ltd.,2007,4(2):293.