4.1 Merge by row - same name and number of columns

 

The simplest and most common operation is to merge several files with the same name, number and order of columns by the row. For example:

Before merging:

Fruits.xlsx
imagepng

and

Meats.xlsx
imagepng

After merging:
imagepng

Script:

A
1 =file(“Fruits.xlsx”).xlsimport@t()
2 =file(“Meats.xlsx”).xlsimport@t()
3 =A1|A2
4 =file(“Foods.xlsx”).xlsexport@t(A3)