Read Excel file with specific header row

[mateo.drouillard]

Hey !

I want read excel file (.xlsx). And my header start of row number 3.
And for each row i want merge my column “Name” and “Surname” in “Pseudo” but “Pseudo” is not created before.

Help me plz

[ppr (Peter)]

@mateo.drouillard

And my header start of row number 3.

give a try on read range with a range offset e.g. A3 when first col is A

@mateo.drouillard

And for each row i want merge my column “Name” and “Surname” in “Pseudo” but “Pseudo” is not created before.

Add a data column with the Add DataColumn Activity
feel free to reposition it with invokecode and SetOrdinal method
Within For each block
Row(“Pseudo”) = row(“Name”) & " " & row(“Surname”)