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
refer to this xaml
Main (1).xaml (9.3 KB)
after you have added datarow…,
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
then delete the last row…
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.
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
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)
ok, so you want header to be test2,sasas,sad?
No, I want header as last row of excel… NewHeader1, NewHeader2,NewHeader3…
its working for me
output.xlsx (8.3 KB)
Main (1).xaml (12.2 KB)
just use write range activity and check “add headers” … . … . . .
Thank u… it is working for me also
ok, pls mark my answer as solution. thanks
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.