基于VB的SCI期刊Excel数据检索及影响因子提取  

Retrieval of Excel Data and Impact Factor From SCI Journals Based on VB

作　　者：马超[1] 张显库[1] 杨光平[1] 张志恒[1] 冯永孝 

机构地区：[1]大连海事大学航海动态仿真和控制实验室,大连116026

出　　处：《计算机系统应用》2017年第6期267-270,共4页Computer Systems & Applications

基　　金：国家自然科学基金(51109020;51409033);国家高技术研究发展计划(863)(2015AA016404);中央高校基本科研业务费专项资金(3132014302)

摘　　要：为了方便科研工作者了解本领域SCI(Science Citation Index)期刊的影响因子,编程实现了针对每年公布的11000余种SCI期刊某一领域数据的筛选,以得到与本学科相关期刊的影响因子情况.SCI收录的期刊涉及近百个研究领域,而每个研究者只关心其中的一个或两个研究领域.目前,科研工作者多利用Excel工具,人工手动处理这些期刊数据,其工作量巨大且准确性不能得到保障.用VB 6.0(Visual Basic6.0)编程实现对SCI期刊数据库工作簿的批量数据处理,其过程快速、便捷、准确率高且适用范围广.In order to facilitate the scientific research workers to know the impact factor of SCI （Science Citation Index） journal in their own field, the program realizes a filter of more than 11,000 kinds of SCI journals in a certain field that are published annually to get impact factors of the journal that are related to their own subject. SCI journal involves nearly 100 research fields, but each researcher only cares about one or two research areas. At present, the scientific research workers mostly use Excel tool to handle the journal data by hand. Thus it needs a huge workload and the accuracy cannot be guaranteed. The batch data of workbook in SCI journal dataset can be fast processed by VB6.0 （Visual Basic6.0） program, and the procession has the characteristics of high accuracy and high-speed has a wide range of application.

关 键 词：VB 批量处理数据 EXCEL工作簿 SCI数据库 正选反删 

分 类 号：TP311.1[自动化与计算机技术—计算机软件与理论] TP391.13[自动化与计算机技术—计算机科学与技术]