First of all, you need to add a plug-in in excel-data analysis library, and then you can automatically generate data, which is a "random number generator" in technical terms. Click: excel Options-Add-ins-You can also use VBA to batch populate templates to generate new tables according to data sources. A simple example: the code in the example: Sub is filled in batches according to the data source.

The function of this macro is to copy each line (***8 lines) of each excel file in the current folder to each sheet worksheet of the summary table, that is, to copy and convert 8 lines of 1 table in one file to 8 lines in another file, which is mainly used for summary work.

The solution to how to extract data from excel tables into word documents is as follows:

1, copy method.

That is, copy and paste the original data directly into word, so that the data can be directly imported into word documents.

2. Mail merge method.

Enable mail merge in word, insert requirements, data sources and corresponding relationships according to the process of the wizard, and finally perform the merge.

3. Procedural law.

Insert the merge field in word (if it is an ordinary table, this step is not needed), then write vba program, read data from excel file, and then write it to the specified location in word.

Of the above three methods, method 1 is simple and quick, but it needs to be operated every time. If the data is not a continuous block, it needs to be copied and pasted many times, which is more troublesome.

Method 2: One setting can be used many times, but it is not flexible enough.

Method 3 can be used repeatedly, but it needs a certain programming foundation, and the most suitable one can be selected according to the actual working situation.