How to add custom headers to headerless datatable

Help
1

Hello everyone,

I need to extract data from an Excel range so far it works and I can use the data without problems. now the problem is, that the headers inside the Excelsheet are uselessly formated and I can’t read them in a good manner.
Is it possible to add the headers afterwards to the headerless datatable? so far I couldnt find a good way to do that.

regards :smile:

1 Like
2

Fine we can do one
we can change the column name we want like this
with a simple assign activity
yourdatatablename.Columns(“yourcolumnname”).ColumnName = “new column name”
or
yourdatatablename.Columns(yourcolumnindex).ColumnName = “new column name”

where column index starts from 0 for the first column
hope this would help you
Cheers @Roger.B

2 Likes
3

TableName.Columns.Item(index of column).ColumnName = “your new column Name” . Pop that into an assign activity. If there are many I would store the header names in an array and loop through to assign them.

1 Like
4

thank you :smiley: I totaly din’t think of this option. I only was searching for an activity.
@Palaniyappan, @sjr6728

5

Cheers @Roger.B

1 Like
6

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