I have been trying to read this excel file and select certain rows/cells based on condition in column A. In this case, if the value in column A (Apple A) is Z67, get all the values in column C (Citrus) and write them into text file. So I should get CA, CB, CC, CD back.
At this point, I am just trying to get all the records that belongs to Z67. However, I get the error saying the object reference not set blahblah with the workflow that I have in the xaml.
Also, is there a way to select only column A and column C even before I start to create the dataTable? Using if else condition? I think it would be faster and more efficient because I don’t need all other information in that excel - only column A and column C.
I am aware of this site - https://www.uipath.com/kb-articles/how-to-filter-a-data-table
In terms of the forloops as indicated on the website above, why do we need 2 forloops? and what should the TypeArgument be for the second for loop?
Please see attachments and check my xaml. Thanks in advance