从大数据文件中抽取满足条件的数据是一个工作强度大、容易出错的工作。以年度学校科研工作业绩数据为基础,介绍如何在Excel文件中采用VBA技术抽取教师组成比较复杂的学院的科研工作业绩。实验表明,该方法可以大大提高工作效率,减小工作人员劳动强度,减少差错的发生,VBA技术可以很好解决用户在使用Microsoft Office办公中所面临某些特定功能或重复性高的操作。%In this paper,a method,which is about how to extract research achievement data of a university's school from the whole university's research achievement data by using Excel VBA,is proposed.The experiment shows that the method can greatly improve the work efficiency,reduce the labor intensity of the staff,and reduce the occurrence of mistakes.
展开▼