Deleting a row in an Excel table

Help Studio
1

HI, I need some help.
How can i delete the last empty row that is being read?

The output screen displays a list of dates from December 30, 1899 and an error message stating "Assign: StartIndex cannot be less than zero. Parameter name: startIndex". (Captioned by AI)
The output screen displays a list of dates from December 30, 1899 and an error message stating "Assign: StartIndex cannot be less than zero. Parameter name: startIndex". (Captioned by AI)518×275 6.83 KB

2

Error looks different

May i know what exactly is the requirement and need of deleting the last empty row?

For deleting - you can refer below code snippet

This image shows a sequence in a workflow for Excel automation, where an Excel file is opened, the first and last data rows are identified, and specific rows are deleted based on the last empty row's index. (Captioned by AI)
This image shows a sequence in a workflow for Excel automation, where an Excel file is opened, the first and last data rows are identified, and specific rows are deleted based on the last empty row's index. (Captioned by AI)1440×1020 43.7 KB

3

Hi @dvojinovic

The error is something else, but if it is being caused by the last row and you wish to delete it, then use the following code:

dt_Data = dt_Data.Rows.RemoveAt(dt_Data.Rows.Count - 1)
4

Hi @dvojinovic

First use If activity -Check for Empty Last Row

dt.Rows(dt.Rows.Count - 1).ItemArray.All(Function(x) String.IsNullOrWhiteSpace(x.ToString()))

Then Remove Data Row (Inside If Block)
Row Index: dt.Rows.Count - 1

5

@dvojinovic,

If data cleaning is the aim here, you can use this LINQ to get only the non empty rows.

dt = dt.AsEnumerable().Where(Function(row) Not String.IsNullOrEmpty(row("ColumnName").ToString())).CopyToDataTable()