This is Excel Data I want to replace last row data in first row

Gaurav_Gore · May 30, 2023, 5:02pm

replace last row data in first row

Anil_G · May 30, 2023, 6:08pm

Please try this

Dt.Columns("A-abc") = dt.AsEnumerable.Last(function(x) Not String.IsNullOrEmpty(x("A-abc").ToString.Trim))("A-abc").ToString

Change the column name for other

Cheers

postwick · May 30, 2023, 8:51pm

Read CSV into a datatable. Update the data in the datatable as needed. Write CSV back to the file.

Yoichi · May 30, 2023, 11:29pm

Hi,

Can you try the following sample?

Regards,