I’d like to read multiple sheets in multiple files with “sheet names” also shown on the columns. I tried to below loop and nodes to complete but it could only show “file names” instead of “sheet names”. Appreciate if anyone can help with this problem!
Example of the input/ expected output files are attached.
My files are like
File #1- 2018 data in one file with 12 sheets going from Jan to Dec.
File #2- 2019 data in one file with 12 sheets going from Jan to Dec
Expected output.xlsx (10.8 KB)
2018.xlsx (13.4 KB)
2019.xlsx (13.4 KB)