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) |
esProc Desktop and Excel Processing
3.4 Multiple source data areas
4.2 Merge by column - same name and number of rows
SPL Official Website 👉 https://www.scudata.com
SPL Feedback and Help 👉 https://www.reddit.com/r/esProc_Desktop/
SPL Learning Material 👉 https://c.scudata.com
Discord 👉 https://discord.gg/cFTcUNs7
Youtube 👉 https://www.youtube.com/@esProcDesktop
Linkedin Group 👉 https://www.linkedin.com/groups/14419406/
