Shulou(Shulou.com)06/01 Report--

Today, I will talk to you about how to merge a number of EXCEL files into one file, which may not be well understood by many people. In order to make you understand better, the editor has summarized the following contents for you. I hope you can get something according to this article.

There are multiple EXCEL files with the same format in the same folder. What should I do if I need to merge them into one EXCEL file?

Write your own program to achieve it? Although some program languages provide API for reading EXCEL files, you still need to write programs to open each file, read each cell data in a loop, save each file data to the same dataset object in memory, and finally write a new EXCEL file. The workload of writing code is often large. And because the format of each batch of EXCEL files is different, the program written is not universal, so you need to rewrite the program next time.

Using the aggregator SPL for merging is simple and requires only a few lines of code.

Write the SPL script as follows:

ABC1 > dir= "E:/work/excel/" = file (dir+ "merged.xlsx")

2=directory (dir+ "* .xlsx")

3for A2=file (dir+A3) .xlsimport@t ()

four

If # A3==1=B1.xlsexport@t (B3) 5

Else=B1.xlsexport (B3)

In addition, there are merging different Sheet in the same EXCEL file into one Sheet, and grouping and summarizing after merging. Please refer to EXCEL merge Summary.

SPL can also easily handle the following EXCEL requirements:

1. Read EXCEL files in free format, crosstab, master and child tables, etc.

2. Export and append the data to the EXCEL file, and output the EXCEL file in a preset exquisite format.

3. Read and write EXCEL files with a large amount of data

4. Merge and split EXCEL files

The aggregator is a professional tool for file data source processing, which can easily carry out mixed calculation, storage and export of all kinds of file data, such as TXT, Excel, Xml, Json, CSV, ini and so on. Desktop-level computing tools, ready-to-use, simple configuration, perfect debugging functions, can set breakpoints, single-step execution, and the results of each step can be viewed. The syntax is simple, in line with people's natural thinking, and is simpler than other high-level development languages.

After reading the above, do you have any further understanding of how multiple EXCEL files are merged into one file? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.