Excel Sort Data

RPA Discussions
, , ,
1

image
I have an excel data in UiPath
i want to configure the data ,
i want to delete that row whose cell is empty,
Suppose row 1 have complete data its display all data ,
Row 2 and 3 have empty row it should delete the row

Lastly i want this configure combine the row of 2 and 3
I want this type row 2
image

2

Hi Ammaz_Ahmed,

Please check the project attached with the solution.
Demo.zip (3.5 KB)
I hope helps you!

Cheers

3

Sorry, Its not working

4

@Ammaz_Ahmed

use this code in invoke code activity

'assiging the first column value
Dim previousvalue As String
For Each r As datarow In dt1.AsEnumerable
If r(0).ToString.Trim.Equals("") And Not  r.ItemArray.skip(1).All(Function(a) a.ToString.trim.Equals("")) Then
	r(0)=previousvalue
	Else
		previousvalue=r(0).ToString
	End If
	Next
	'deleting all the empty rows
	Dim finaldt As DataTable
	finaldt=new DataTable()
	finaldt=dt1.AsEnumerable.Where(Function(a) Not a.ItemArray.Any(Function(b) b.tostring.equals(""))).CopyToDataTable
	dt1=finaldt

image
image1197×708 36.9 KB

here dt1 is the output of read range activity