Hello, When I read an Excel file that I can only download in CSV format using the “read csv” activity, I cannot convert it to a datatable due to duplicate columns. How can I solve this issue?

Hi @erimbetul Unselect the add headers option in read CSV activity properties. Then make the first row of datatable as columns. Check the below thread to make first row as columns of a datatable, [image] First row to be column in Datatable Studio @mkankatala Use a for l…

Csv to datatable problem

Help Studio

Parvathy (PS Parvathy) February 21, 2025, 7:43am 2

Hi @erimbetul

You can read the CSV file by unchecking the Add Headers option in Read CSV activity.

Regards

Topic		Replies	Views
How to make 2nd row as header in datatable Activities excel , activities , question	13	1029	June 14, 2023
Help! Can anyone help me convert the csv file to excel Studio studio , question , tools	7	1138	September 27, 2021
CSV cannot read because of wrong header row Help activities	3	1416	October 22, 2020
Read csv and then change it into an excel file Studio studio , question , tools	3	1404	August 14, 2021
CSV File to DataTable problem Studio uiautomation	8	1149	April 13, 2022

Csv to datatable problem

Related topics