...
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
and
Meats.xlsx
After merging:
Script:
| A | |
|---|---|
| 1 | =file(“Fruits.xlsx”).xlsimport@t() |
| 2 | =file(“Meats.xlsx”).xlsimport@t() |
| 3 | =A1|A2 |
| 4 | =file(“Foods.xlsx”).xlsexport@t(A3) |
