I have excel files with many sheets. I would like to add a column in a sheet showing the current sheet name. How to do it in bulk?
Example as attached, I want to add a column that shows the sheet name e.g. "01 country"
Thank you.
Hi @Ringo_Wu,
I downloaded your new Excel file, renamed and it worked as intended. See below.
(I think there is a little typo in your text, because your table shows my table, but your text says '6 rows' for file 2)
I think I know what caused the error. I forgot to use the relative path in the Input Tool, and only used it in the Dynamic Input. I'll attach the changed workflow.
If you aren't familiar with relative paths: This path indicates that the input file is in the same folder as the workflow file.
Feel free to change the path in both tools as needed.
Happy weekend!
Alex
Hey @Ringo_Wu,
here is a solution to your problem:
The result looks like this:
I have attached the sample workflow.
If this solved you problem, please consider to accept it as a solution or drop another question if it doesn't.
Thanks, @grossal for your reply. Actually there is still a problem. The two different sheets contain different values. i.e. in sheet "02 Country ", there is a value of BC and DC, these values are not included in the output. It seems only the value from sheet "01 country" is included and attached to the 2 sheet names accordingly.
In fact, I wish to have output as these in one sheet:
Ohh sorry. I had a typo in the example.
This is the new result.
As an Excel User myself, I'd find it pretty odd to have another "header row" in the middle of the data. Usually you want to use Filters or Pivot Tables across the whole data and not only on the first N rows.
Can you explain why you want the additional header row?
Workflow attached. I also fixed the blank space in the end of the second work sheet because this was causing some trouble too.
