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

Question

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:

What am i missing ?

Answer 1

The Read Range activity reads data into a DataTable object. Checking AddHeaders makes sure that columns are present in said object.

in other words

When Options - Add Headers within Read Range is selected, Column Headers are identified and are not read as a part of the data to be read from the .xls file.

When Options - Add Headers within Read Range is unselected, Column Headers are considered as a part of the data to be read from the .xls file.