I want to pass last row as header

[Divya_Sadhasivam]

How to pass last row of excel file as a header row.
In addition to it that last row will be always dynamic one.

i have used add data row to get the header row name but its adding into the last line of the datatable. But i want to add the data as initial row as header
@Palaniyappan @other forum persons as well
Thanking you in anticipation

[jack.chan]

HI @Divya_Sadhasivam

refer to this xaml
Main (1).xaml (9.3 KB)

after you have added datarow…,

1. loop over the columns of datatable, then for each column assign last dataRow value to become the header by doing
   dt.Columns(col.ColumnName).ColumnName = dt.Rows(dt.Rows.Count-1)(col.ColumnName).ToString

2. then delete the last row…
   

Example

After

[Divya_Sadhasivam]

Hai @jack.chan … I referred your code but i didn’t get last row value as header, u assigned last row value as header but didn’t pass the value to data table

kindly let me know how to pass last row value as header in excel file.

[jack.chan]

@Divya_Sadhasivam

used add data row to get the header row name but its adding into the last line of the datatable

didnt you already use add data row to add header row to last row of datatable? my sequence converts last row to the header of datatable… …

if you want to update the excel after that just use write range to update it @Divya_Sadhasivam

[Divya_Sadhasivam]

hai @jack.chan Last row is removed correctly but i didn’t get last row as header in data table, please find the below attached excel

Output.xlsx (8.4 KB)

[jack.chan]

ok, so you want header to be test2,sasas,sad?

[Divya_Sadhasivam]

No, I want header as last row of excel… NewHeader1, NewHeader2,NewHeader3…

[jack.chan]

its working for me
output.xlsx (8.3 KB)
use this…
Main (1).xaml (12.2 KB)
just use write range activity and check “add headers” … . … . . .

before

after

[Divya_Sadhasivam]

Thank u… it is working for me also

[jack.chan]

ok, pls mark my answer as solution. thanks