I am developing a worfklow where I need to read each row of an Excel cell with a single column and check if that color is Yellow or not. If it is Yellow, I have to save the value from the column into some list (or any other structure of data).
So far, I did this:
1º Inside an ExcelApplicationScope activity, I added an ExcelReadRange activity. With that read range, I got created a new data table.
2º Since the documentation says that the ExcelGetCellColor only exists inside an ExcelApplicationScope, I made a new sequence with a ForEachRow that loops through the previously created data table.
Obs. 1: The idea in mind is looping through each row and get the cell color from each row(0).Item and save it.
Obs. 2: cCell is the name of the variable that I created for the ExcelCellColor activity
So, any tip if the current approach is the best so far? If not, what would be the recommend steps next?