Change Headers of Datatable after Read Range on an Excel

[Sejal_Shrestha]

I have to read excel and store it in Datatable, I dont want the headers of that Excel and I want to give my own headers. i tried build datatable with the column names and un checked the add headers property but it seems to be not working. Can any one help me with this.
Cheers

[Anil_G (Anil Gorthi)]

@Sejal_Shrestha

Welcome to the community

After reading just use a for loop with dt.columns and then inside loop use assign activity with currentItem.Column.ColumnName = "NewName" .if you have in array then in for loop you have index property and you can use …and currentItem.Column.ColumnName = NamesArray(index)

cheers

[rlgandu (Rajyalakshmi Gandu)]

@Sejal_Shrestha

Read Range - WorkbookPath: “YourExcelFilePath”, Range: “YourSheetName”
Output: dtOriginalData

Assign - To: dtOriginalData.Columns(0).ColumnName
Value: “Column1”

Assign - To: dtOriginalData.Columns(1).ColumnName
Value: “Column2”

Assign - To: dtOriginalData.Columns(2).ColumnName
Value: “Column3”

[lrtetala (Lakshman Reddy)]

Hi @Sejal_Shrestha

Welcome to Community!!

How about the following?

Input:

Output:

Cheers!!