Excel file e.g operation , row remove, replace, prefix, profix,underscore and task textfile question

[nikhil.patil]

question task text file

text file to be one by one task and how to perform excel file data ,filter delete prefix profix underscore how to solve excel file data

[nikhil.patil]

NoteToExcel.xlsx (9.5 KB)

excel file upload

[raja.arslankhan (Raja Muhammad Arslan khan)]

@nikhil.patil
are you want to manipulate operations in excel according your question file?

[nikhil.patil]

excel file perorming task using uipath

[raja.arslankhan (Raja Muhammad Arslan khan)]

@nikhil.patil so please follow these common task first.

1-use read range activity to get Data from file.
2- put loop on dataTable
3-perform each questions step inside loop

[Aakash_Singh_Rawat]

Hi,

To remove options you can use filter datatable and add all columns with exact match with their values given in above table, set remove option on in keep or remove matching rows.

After this assign finalDT=newDT.clone(newDT is your filtered dt after removing rows).
Use for each row in dt(original dt),
if condition for amending rows condition given in above table and add data row only if current row not matched.