Remove data from last row of an excel/datatable

[Janani_T2 (Janani T)]

Hi all,

I needed an expression to get the data of last row of an excel

[nikhil.girish]

Hi @Janani_T2

Check this expression out

dt.AsEnumerable.Take(dt.Rows.Count-1).CopyToDataTable

This expression would remove the last row data

If you just want to get it

{dt.AsEnumerable.Last}.CopyToDataTable

[Janani_T2 (Janani T)]

This is a linq expression right ?

[nikhil.girish]

Yes @Janani_T2 correct

[Yoichi]

Hi,

What type is your expected result?

DataTable

{dt.AsEnumerable.Last}.CopyToDataTable

Object array

dt.AsEnumerable.Last.ItemArray

Comma separated string

String.Join(",",dt.AsEnumerable.Last.ItemArray)

Regards,

[Janani_T2 (Janani T)]

I just want to get last out of my datatable basically remove

[Janani_T2 (Janani T)]

Get as in I want to remove/delete it

[Yoichi]

Sorry, I had misunderstanding. @nikhil.girish 's expression will work.

[Suraj_B_Shetty (Suraj)]

Hi @Janani_T2

Try this

Hope this helps