Back

Explore Courses Blog Tutorials Interview Questions
0 votes
1 view
in RPA by (12.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 (29.8k 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.

Related questions

Welcome to Intellipaat Community. Get your technical queries answered by top developers!

28.4k questions

29.7k answers

500 comments

94.1k users

Browse Categories

...