I have an activity that will go into my exchange and save an attachment to a specified folder. the attachment is always an excel.
There are 2 types of excels that it could be. 1 has ‘No Data Available’ in A1 and the other is a table starting in A1 that reads ‘firstname’.
i want to do an if activity that states if the A1 value = No Data Available, end process else insert excel table into SQL database.
i am able to do the insert no issues, i just don’t know how to get the robot to read the excel and determine if A1 says No data available.