How to add new Column names at Excel file without Headers?

How to add new Column names at Excel file without Headers?

I have excel to process without any headers. I would like to add column names.

@Nightowl_music

Check below for your reference

Hope this may help you

Thanks

Hi @Nightowl_music
first read the excel using read range activity (untick the add headers in the properties panel)

create a datarow type variable
put the below syntax in assign activity
datarow=YourDatatableVariale.NewRow
datarow(0) = "column name 1"
datarow(1) = "column name 2"
.
.
datarow(5) = "column name 6"
use invoke code activity add two arguments ex(datarow_in,Readrange_DT_in)
inside the invoke code activity
Readrange_DT_in.Rows.InsertAt(0,datarow_in)

Update us whether you got your desired solution or not
thanks,