URGENT PLEASE HELP HOW TO DELETE DYNAMIC EXCEL LAST ROW DATA?

[Kia1 (Ana)]

i have a UiPath flow
read the CSV file, then write all the CSV data into Excel.

When it is finished it becomes data in Excel, because the data dynamically follows the data in CSV

after that, I want to delete the last two rows in dynamic excel data

How to delete dynamic Excel last row data?

[Steven_McKeering]

Hello

@Kia1

How to delete dynamic Excel last row data?

Try these options:
Option1:

How to remove last row from Datatable

I’ll assume your datatable is a variable called dt1. Use the remove data row activity with the following as inputs in the properties window: DataTable: dt1 Row: (leave this blank) RowIndex: dt1.rows.count - 1 This will remove the last row of dt1. The reason why you include the minus 1 after rows.count is because the index of the datatable starts at 0, but counting the rows will start at 1 (e.g. row #1 will be index 0, but the count would start at 1)

Option2:
dt.AsEnumerable().SkipLast(2).CopyToDataTable()

Note: this may not work depending on your version of the REF - as it only works in “Windows-Legacy” method only.

Hopefully this helps,

Cheers

Steve

[Vinit_Mhatre (BotBuilder)]

@Kia1

i have a UiPath flow
read the CSV file, then write all the CSV data into Excel.

When it is finished it becomes data in Excel, because the data dynamically follows the data in CSV

after that, I want to delete the last two rows in dynamic excel data

How to delete dynamic Excel last row data?

Hi @Kia1 ,

You can do this as below,

Final_DT.AsEnumerable().Take(Final_DT.Rows.Count - 2).CopyToDataTable

selects all the rows from the DataTable Final_DT except the last two rows and creates a new DataTable containing those rows.

Regards,
Vinit Mhatre

[lrtetala (Lakshman Reddy)]

Hi @Kia1

Try this

(Excel.Sheet("Sheet1").DataTableValue.RowCount-1).ToString+"-"+(Excel.Sheet("Sheet1").DataTableValue.RowCount).ToString

Input:

Output:

Note: If you want to remove only last row use the below

(Excel.Sheet("Sheet1").DataTableValue.RowCount).ToString

Regards,