How do i set first row as header?

folks, im trying to extract a table from a web. but couldn’t find a way to set the first row of the table as header. now im having trouble to continue my flow.

any suggestions how to do that? note that my first column is “Date” type

Hi @n.syifaa ,

Could you let us know what is the current header values that you get after table Extraction ?

column1, column2, etc…

Hi - This question was answered in another post:

  • Loop the first row using For Each activity
  • Then Assign dt.Columns(columnIndex).ColumnName = firstRow(columnIndex) this will rename the header
  • After the loop delete the first row

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