Hello everyone i am facing a problem which is a excel file there are a same column name but not fix which will be same and i want to get a specific column name but i am not able to get i have used a code str= read_dt.rows(0).item(“ABC”).tostring i have got the value but in same sheet has two same…

[image] When i open the my input file using excel application scope Its open the blanks workbooks and file name is right as a input file and got the error

How to rename if Same column name in excel

Help Studio

Yoichi (Yoichi) December 15, 2022, 1:38pm 9

Hi,

What do you mean?

The following is a sample to rename column name of datatable which is addheaders option off from contents of the first row. This might helps you.

Regards,

Topic		Replies	Views
Rename Duplicate Column in Data Table Studio studio , question , find_references	5	2400	August 10, 2021
Rename duplicate column names Studio studio , question , activities_panel	9	135	April 23, 2024
How can I rename multiple excel columns to a same name? Studio uiautomation	7	820	December 16, 2022
Check column name if found header same Activities excel , activities , question	5	1431	March 7, 2022
Rename column in datatable Studio uiautomation , studio , question	12	9002	February 20, 2024

Most Active Users - Yesterday
ashokkarale
Yoichi
postwick
Anil_G
kishan.savaliya
Laura_Hubbard
Tselisehang_Molebatsi
Byrnecut
Lahiru.Fernando
wahyumrizqi
More details...

How to rename if Same column name in excel

Related Topics