Please Help
I have an excel file in which there is dynamic data because it is obtained from a CSV file.
Next, I want to always delete the last two rows (in the red circle) and fill in “Total” on the last row because of the total of the columns
is it possible to make a flow like this?
@Kia1 Please share a expected output structure for better understanding.
Regards,
Ajay Mishra
Hey @Kia1
Use below mentioned LinQ:
dt_Input.AsEnumerable.Take(dt_Input.RowCount-2).CopyToDataTable
Regards,
Ajay Mishra
Are you using Excel Process Scope? If yes then just get the last row of the sheet using Get First/Last Row activity.
Use Delete Rows activity to delete last tow rows.
Thanks,
Ashok 
no, I use single excel scope
Okey thankyou I’II Try
@Kia1 Your Welcome 
, if your query is resolved just mark the post as solution!
It will help others to find the correct solution.
Regards,
Ajay Mishra
