摘要
Excel和Word为Office办公软件的两种组件,在文字处理、数据统计分析方面有着强大的功能。在具体工作中,两者的数据交互极为常见。本文主要介绍在大批量数据背景下,通过VBA技术实现从Word文档中提取信息到Excel表格,实现数据的快速、准确、自动转换。
Excel and Word are two components of Office office software.They have powerful functions in word pro?cessing and data statistical analysis.Data interaction between them is very common in work.This paper mainly intro?duced how to extract information from Word document to Excel table by VBA technology under the background of mass data,so as to realize fast,accurate and automatic conversion of data.
作者
郑培寅
曹艳杰
余志远
ZHENG Peiyin;CAO Yanjie;YU Zhiyuan(Resource and Environment Investigation Center of Henan Province Coalfield Geological Bureau,Zhengzhou Henan 450000;Henan Province Coalfield Geological Bureau,Zhengzhou Henan 450000)
出处
《河南科技》
2019年第16期35-36,共2页
Henan Science and Technology