Read Excel file with specific header row

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 :slight_smile:

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

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”)

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.