Dear community,
What is the process that I must follow so that the RPA reads the last line of an excel sheet with several records and continues to the next process.
In each line of excel I have to look for a text, so you must be working with the same instruction (Search) until you reach the last line of excel.
Thank you very much
@Julian_Soria Read the excel sheet into a data table, store as DT_Excel.
Assign size= DT_Excel.Rows.Count
If DT_Excel.Rows(size).Item(0).ToString = 'text'
Return True
Thank you Kyle for your answer, sorry but I don’t understand the command. =( can you explain more please.
Thank you very much community
Hi
welcome back to uipath community
–hope these steps would help you resolve this
–use EXCEL APPLICATION SCOPE and pass the file path of excel as input
–inside the scope use a READ RANGE activity and get the output with a variable of type datatable named dt
–now use a FOR EACH ROW activity and pass the variable dt as input
–this for each row loop will iterate through all the records till the last line i.e., last record in the excel
–so within this for each row loop we can have any activity to process the records in a particular column like this with a assign activity
row(“yourcolumnname”) = “your value”
where row is the variable from FOR EACH ROW activity which will iterate through row and change the value mentioned in the specified column per row
kindly try this and let know for any queries or clarification
Cheers @Julian_Soria