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) |
https://c.scudata.com/article/1651916536524
https://c.scudata.com/article/1652315193899
https://c.scudata.com/article/1652397858674
SPL Official Website 👉 https://www.esproc.com
SPL Feedback and Help 👉 https://www.reddit.com/r/esProc_Desktop/
SPL Learning Material 👉 https://c.esproc.com
Discord 👉 https://discord.gg/2bkGwqTj
Youtube 👉 https://www.youtube.com/@esProcDesktop
Linkedin Group 👉 https://www.linkedin.com/groups/14419406/
