i am trying to extract the invoice details as per the header from this table, there are multiple copies of the bills in the same excel and data is unstructured.
Approach:
I wanted to extract each row value and then match the header, i have start and end header of the table, By that i wanted to extract a particular layout of the table and paste it in other excel.
If you stick to UiPath’s activities, you have Read Row activity under System > File > Workbook. Use it into a DoWhile activity to iterate over your file’s rows and break whenever you find your value.
Assign (String) Searched = "DOC No"
Assign (Int32) RowIdx = 0
Assign (String) ColumnLetter = ""
DoWhileString.isNullOrEmpty(ColumnLetter)
Assign RowIdx = RowIdx + 1
ReadRow StartingCell = "A" & RowIdx.ToString Result = Row