How to work on this excel

hi ,

I am appending data there is column name STAR in excel after appending i need to add S in the STAR COLUMN how to do that

1 Like

If we want to edit the column name then once after reading it with read range use a assign activity like this
dt.Columns(“yourcolumnname”).ColumnName = “yournew name”

Cheers @manoj2500

1 Like

no i don’t have to rename the column name instead i need to add S below that if data exist under other column names

eg : star - name - class- unit (all are headers )

if data exist under either of column name then add S under star

Can I have an example on excel itself
If possible share a image please
Cheers @manoj2500

under action i need to add S if data is available in that particular row the other excel on which the data is to be updated will only have headers that it