摘要
为提高金融行业中常使用的基于Excel的行业数据库更新网页数据的效率,定义一个常用的数据库结构,并基于VBA语言实现了对数据库内公司的定位、目标网址的生成以及目标数据的获取,并在实现数据更新的同时实现了图表的自动更新。另外还对更新后的数据进行了统计分析以获取有用信息。通过对数据库的自动更新和手动更新耗时的对比,证明了数据自动更新极大地提高了数据库的更新效率,具有很高的商用价值。
In order to improve the efficiency of updating the webpage data of Excel-based industry database which is frequently used in financial industry,a common database structure is defined.The localisation of company＇s position in database,the generation of target website and the acquisition of the targeted data are implemented based on VBA.The chart update is achieved at the same time while the data is updating.Furthermore,the data updated has been statistically analysed for pick up useful information.Comparing the time consumption of the automatic database update with that of the manual database updated,it shows that automatic data updating greatly improves the efficiency of updating rate of the database and has very high commercial value.
出处
《计算机应用与软件》
CSCD
北大核心
2012年第11期220-221,251,共3页
Computer Applications and Software
