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

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

为了方便科研工作者了解本领域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.