摘要
为了提高用户在使用Web UI类型数据库平台进行信息搜索、数据采集及分析的效率,笔者主要介绍了如何运用Excel的VBA与网页设计相关编程语言,实现数据批量自动化采集,并根据用户需求进行数据分析。自动化数据采集工具能够优化工作流程,提高工作效率,降低劳动成本,并将误操作的可能性降到最低,提高了数据的准确性。经测试证明运行结果准确可靠,改进后的流程能满足高效性和准确性的要求,也为其他同类数据进行自动化采集分析奠定了基础。
In order to improve the efficiency of information search,data collection and analysis using the Web UI database platform,the author mainly introduces how to use the VBA of Excel and the programming language related to web page design to realize the automatic collection of data in batch and data analysis according to the needs of users.The automatic data acquisition tool can optimize the work flow,improve the work efficiency,reduce the labor cost,minimize the possibility of misoperation,and improve the accuracy of data.The test results show that the operation results are accurate and reliable,the improved process can meet the requirements of high efficiency and accuracy,and also lay the foundation for other similar data automatic collection and analysis.
作者
朱怡文
Zhu Yiwen(Ingersoll Rand Engineering Technology Center-Asia Pacific,Taicang Jiangsu 215400,China)
出处
《信息与电脑》
2019年第20期126-130,共5页
Information & Computer
