Rename cell name in folder of excel

Help StudioX
, , , ,
1

Hi i am trying to rename a cell name for bunch of excel in folder. i have tested with use excel file for a single excel. When i want to use for a folder of files. what is the process or flow. I tried to use For Each file in folder. I am getting errors.
attached with image below.

image
image607×626 20.5 KB

image
image499×600 22.4 KB

2

Hi @vignesh.maruthappan

Try this way:

image
image824×1456 63.1 KB

Regards

1 Like
3

works. But lets say we have different sheet name? How to sort it?

4

Hi @vignesh.maruthappan

Do you have multiple sheets in a single excel file or a single sheet?

Regards

5

Single sheet with different name

6

Hi @vignesh.maruthappan

Try this way:

image
image909×1732 75.7 KB

Regards

7

@vignesh.maruthappan
Or you can do this way too.

image
image824×1613 57.3 KB

Get Workbook Sheet is an Classic activity to get that enable Classic in Filter option of Activities Panel.

Regards

8

Thanks great working.But my excel becomes empty when i try it out in .csv format

9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.