5.11 Split multi-Sheet file into multiple files - unfixed number of Sheets
There is a multi-Sheet file Amount.xlsx as follows:
The number of Sheets is not fixed, now we need to separate each Sheet to form one file, and take the Sheet name as the file name. The results after splitting are shown as below:
Apple.xlsx： 
Bread.xlsx： 
Pork.xlsx：
Script:
| A | B | |
|---|---|---|
| 1 | =file(“Amounts.xlsx”).xlsopen() | |
| 2 | for A1 | =A1.xlsimport@t(;A2.stname) |
| 3 | =T(A2.stname+“.xlsx”,B2) |
https://c.scudata.com/article/1651916536524
https://c.scudata.com/article/1653878486113
https://c.scudata.com/article/1653958231690
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/
