基于vb的sci期刊excel数据检索及影响因子提取资料.pdfVIP

2017 年 第 26 卷 第 6 期 计 算 机 系 统 应 用 ① 基于VB 的SCI 期刊Excel 数据检索及影响因子提取 马 超, 张显库, 杨光平, 张志恒, 冯永孝 (大连海事大学 航海动态仿真和控制实验室, 大连 116026) 摘 要: 为了方便科研工作者了解本领域 SCI(Science Citation Index)期刊的影响因子, 编程实现了针对每年公布 的 11000 余种 SCI 期刊某一领域数据的筛选, 以得到与本学科相关期刊的影响因子情况. SCI 收录的期刊涉及近 百个研究领域, 而每个研究者只关心其中的一个或两个研究领域. 目前, 科研工作者多利用 Excel 工具, 人工手 动处理这些期刊数据, 其工作量巨大且准确性不能得到保障. 用 VB 6.0(Visual Basic6.0)编程实现对 SCI 期刊数据 库工作簿的批量数据处理, 其过程快速、便捷、准确率高且适用范围广. 关键词: VB; 批量处理数据; Excel 工作簿; SCI 数据库; 正选反删 Retrieval of Excel Data and Impact Factor From SCI Journals Based on VB MA Chao, ZHANG Xian-Ku, YANG Guang-Ping, ZHANG Zhi-Heng, FENG Yong-Xiao (Key Laboratory of Marine Simulation and Control, Dalian Maritime University, Dalian 116026, China) Abstract : 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. Key words: Visual Basic(VB); batch processing d