How to rename a column name generate from read range?

Help Activities
, , , ,
1

I used read range to read excel file and the sample generate columns are OrderDate , Region, Rep and ETC.

dddd

And then I used for each to get each column

image

Now I wanted to rename column Region to “Test Region” and when I loop through the columns again the output should be , since I renamed it . Any idea guys .? Thanks

OrderDate , Test Region, Rep and ETC.

2

Thank you for any answers and idea.

3

Read Range output = Dt
Then For Renaming use
DT.Columns(0).ColumnName = “newColumnName”

Here I am renaming 0th Column i.e. First Column u can use old column name instead of index

2 Likes
4

But I wanted to rename it inside the for each , how would I do that ?

5

Then store the Rename Columns name in a list or array
Then use

In for each ----Assign Index
DT.Columns(Index).ColumnName=Array(Index)

6

Can you please provide a sample workflow Sir ?

7

Cant we rename the column in this process ? inside for each ?
image

8

Yes You can

9

Can you please provide an example using or renaming it inside the for earch .

10

Exl.xlsx (8.8 KB) Main.xaml (9.2 KB)

11

cant open the activity has error , either missing or could not load properly Sir

12

can you add the files again include the json

13

I dont wanna rename all columns I just wanna rename specific column name

14

Then use conditions

15

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