0 votes
1 view
in RPA by (11.8k points)

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

What am i missing ?

1 Answer

0 votes
by (27.7k points)
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.
Welcome to Intellipaat Community. Get your technical queries answered by top developers !


Categories

...