Duplicate column with same name coming after adding a new column

Learning Hub Academy Feedback
, , ,
1

Hello all,
i have added two columns SL,no and Location and performed string operations using for each row activity.but after arranging the columns by using DefaultView.ToTable and writing data into excel i am getting duplicate colmns by same name.Sl.no and Location are coming in A and C columns and also at the end AD and AF columns.i dont want the extra columns coming in the end(also they have same name so cant remove)…pfa the images:
1|690x204

2
21527×468 30 KB
3 4

2

What operations did u performed?

3

row(“Location”)=Split(row(“Work Location”).ToString,“-”)(0)
row(“Sl no”)=(i+1).ToString

location and sl no. are two new columns added and performing string operation on worklocation in order to get a specific part.
also i have added DefaultView.ToTable(True,“Sl no”,“Name”,…)and all other columns which i want to extract

4

Ohk and then u write it in different sheet ryt?

5

yes a new sheet.

6

Can you share your file?