Renaming column in Excel

[srinivas_pradeep]

Hi Team,
Hope you are well.
I have excel files with few column . But i would like to rename few of them.

Please find attached the excel file.

I would like to change Invoice to Invoice No.

Can you please share any .xaml?
ask_uipath.xlsx (9.0 KB)

Thanks
Sri

[Rahul_Unnikrishnan]

Hello @srinivas_pradeep ,

You can try the below expression. DT is the datatable variable.

DT.Columns(“old_ColumnName”).ColumnName = “new_ColumnName”

[muhammedyuzuak]

Hi,

I hope that will be useful.

RenameExcelColumn.xaml (5.6 KB)

Regards,
MY

[srinivas_pradeep]

Thank you so much Rahul.

[srinivas_pradeep]

Thank you so much @muhammedyuzuak . Really helpful.