Make The First Row the Header( Column name)

Help Studio
, ,
1

image
image1902×94 5.68 KB

Hello,
I need to delete the first row and then make the second row as the header- Column names for the datatable
How can I do this

2

Hi @Farah_halawani

If you know the range while reading file set range A2 ie., A2:d10 and select the header check box

Regards
Sunil

3

it says Column1 , Column2… Even after removing the first row

4

hi @Farah_halawani

You can use the Build Datatable and Give the Column Name as you want If the no. of columns are limited. Then you can copy the table to Build Datatable.

5

Hi @Farah_halawani ,

Were you able to solve this issue ? If you were able to do so, Mark the appropriate post as the Solution. If you have used a Different solution other than the ones mentioned, Do post the Steps used and Mark the post as solution.

If you are still looking for a Solution, Maybe Deleting the First row itself from the Excel sheet would be the Solution you require ? If so, maybe the below could help :
image

6

Hello, For this issue I used delete first row activity, write range with no add headers to it and then I read the range again
That is the basic yet easy working solution thank you :slight_smile:

7

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