Append text into excel or csv

actually, i would like to add some extra text before the column 2, i am doing web scraping.

also i am writing csv file so ultimately i have to ad that extra text into the csv file, how can i do that?

You can just append the word inside your add row activity like this,

{"test "+ Path.GetFileNameWithoutExtension(file)}

Thanks,
Rammohan B.

2 Likes

actually, i would like to add some extra text before the column 2, i am doing web scraping.

also i am writing csv file so ultimately i have to ad that extra text into the csv file, how can i do that?