Options - Add Headers within Read Range adding excel column headers while unselected and not adding column headers while selected

Help
1

New to UiPath. I am trying to read a .xls file and write the contents within a .xlsx file. It seems:

  • When Options - Add Headers within Read Range is unselected headers are copied from .xls file to .xlsx file.

  • When Options - Add Headers within Read Range is selected headers are not copied from .xls file to .xlsx file.

Snapshot of the control:

AddHeaders
AddHeaders887×446 15.7 KB

Am I missing something here?

2

You will also need the AddHeaders checked in the Write Range.

If it is unchecked when you write the data table, it will be missing the headers.

Hope that helps.

3

The addheaders options just tells UiPath that the headers is in the first line and it will not read them to the table.
If you uncheck the options your suposed header are a row in the table.