How to rename a file name with a value in excel?

Help Something Else
, , , , , ,
1

I have downloaded the data then I want to rename it with value PNO in excel like the photo below, hope someone understands and can help me. Thanks
image

2

Hi @Jafar_R

Could you elaborate your query and expected output.

Regards

3

I use the move file
image
the initial name of the file is “Export File.word”, and i wanna rename it to “38106.word” → the number comes from the value in the excel table in “PNO” row as in my previous question

1 Like
4

@Jafar_R

Welcome to the community

Not sure how you would map each value to each file but can try like this

  1. Use a for each row in datatable
  2. Then inside loop do your download steps
  3. Then after that in the same loop use rename file with from value to be the downloaded file and to value can be currentItem(1).ToString + extension

Cheers

1 Like
5

For the extension, what can i fill it with?

6

@Jafar_R

the extension like .docx etc

cheers