Read Range: A column named '100' already belongs to this DataTable

Help Studio
, , , , , , , , , , , , , ,
1

Hi

when try to read range iam facing this error
Excel

Error100
Error100697×73 5.78 KB

even through there is no column name and i cant use for each row so
How to overcome this error if the column name cant change

RR

2

@jai_kumar2
please unmark Property Headers In read Range Actvity Properties

1 Like
3

@jai_kumar2 Reason is that we can’t create Two Columns with same name in DataTable
and you are using First line as a headers of Columns in DataTable.
Two avoid this read without headers-> Uncheck Headers property in Read Range Activity.

4

Hello @jai_kumar2
Here while reading the datatable as there is no column header it is taking 100 as the header name. So for a datatable it will not allow the same name. So in the read range activity, uncheck the IsHeader property.

Thanks

5

@jai_kumar2 please mark solution and close thread so that others can also get help from it.
Thanks

6

Have a look on the attached workflow, it will help you to read the whole datatable and make the columns unique.
GTM_ChangeColumnNames.xaml (25.6 KB)

Thanks,
Sanjit