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.
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"
yourdatatablename.Columns(yourcolumnindex).ColumnName = "new column name"
where column index starts from 0 for the first column
hope this would help you
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.
thank you I totaly din’t think of this option. I only was searching for an activity.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.