Datatable scrape in Citrix - headers issue

[jordrowley (Jordan Rowley)]

Hey all

The customer set up means Ui Path studio is in one location and the robot in another location. The robot location is inside Citrix.

We have to convert an Excel file in to a .htm file and then scrape it using data scraping tool in Ui path. This works but produces this result

That is the actual headers are the 2nd row. At the moment I use a multiple assign to change the top row column names in to the correct column name. E.g I change ‘Column-0’ to ‘Payment’ and then when I have done, I delete the whole of 2nd row.

Just checking if this is the best way or is there a different way (e.g delete the top row and change the 2nd row in to headers) to do this?

Thanks in advance

Jordan