用excel宏程序提取fbd期刊数据的简易编程
发布时间：2019-05-14 20:43
【摘要】：【目的】使用excel宏程序从定版后的方正fbd小样文件提取多刊数据。【方法】使用Input Box语句由用户输入刊物代号、年份、期次,确定并打开fbd文件为excel文件,数据基本都在第一列单元格中,用Ctrl Find语句定位数据,用循环语句和判断语句采集一个或多个单元格数据,最后是对数据的处理和写入。【结果】程序可有效用于提取《河北科技大学学报》、《河北工业科技》两个刊物的中英文题目、作者、单位、摘要、关键词,以及doi、收稿日期、e-mail、参考文献等数据,程序运行过程中只需使用者输入刊物代号、年和期。【结论】单独使用excel宏程序即可实现所有数据的提取,相对简单易行。【局限】此种编程容错能力较差,要求期刊格式固定不变。
[Abstract]:[objective] to use excel macro program to extract multi-publication data from the sample file of Fangzheng fbd after publication. [methods] the Input Box statement is used to input the publication code, year and session by the user, and the fbd file is determined and opened as a excel file. The data is basically in the first column of cells, using Ctrl Find statements to locate the data, using circular statements and judgment statements to collect one or more cell data. Finally, the data processing and writing. [results] the program can be effectively used to extract the Chinese and English titles, authors, units, abstracts, keywords, and doi, of the Journal of Hebei University of Science and Technology and Hebei Industrial Science and Technology. The date of receipt, e / mail, references and other data, the user only needs to enter the publication code, year and period in the process of running the program. [conclusion] all the data can be extracted by using the excel macro program alone. It is relatively simple and easy. [limitation] this kind of programming fault-tolerant ability is poor, which requires the periodical format to be fixed.
【作者单位】： 河北科技大学学报编辑部;河北科技大学信息科学与工程学院;
【分类号】：TP311.11;G230.7
[Abstract]:[objective] to use excel macro program to extract multi-publication data from the sample file of Fangzheng fbd after publication. [methods] the Input Box statement is used to input the publication code, year and session by the user, and the fbd file is determined and opened as a excel file. The data is basically in the first column of cells, using Ctrl Find statements to locate the data, using circular statements and judgment statements to collect one or more cell data. Finally, the data processing and writing. [results] the program can be effectively used to extract the Chinese and English titles, authors, units, abstracts, keywords, and doi, of the Journal of Hebei University of Science and Technology and Hebei Industrial Science and Technology. The date of receipt, e / mail, references and other data, the user only needs to enter the publication code, year and period in the process of running the program. [conclusion] all the data can be extracted by using the excel macro program alone. It is relatively simple and easy. [limitation] this kind of programming fault-tolerant ability is poor, which requires the periodical format to be fixed.
【作者单位】： 河北科技大学学报编辑部;河北科技大学信息科学与工程学院;
【分类号】：TP311.11;G230.7
【参考文献】
相关期刊论文 前6条
1 刘铁英;张小白;叶慧玲;;Word VBA及宏在科技期刊编辑中的应用[J];编辑学报;2007年01期
2 刘昌来;郑琰q，
本文编号：2477035
本文链接：https://www.wllwen.com/shekelunwen/chubanfaxing/2477035.html
