I have an excel document I am looking through and want to find the position (row, column) in where the data is wrong. I only accept numbers in the Excel document, however, some cells have text. I have correctly detected which cells are wrong and which are right. Now comes the last part, where I need to format the cells which are wrong and then write them into another cell.
You may assume that the formating style is not important, however, for ease, let’s just say I want to change the “Fill” to “Red”.
You may also assume that both i and j are variables that change according to which cell we currently are in. I am using a for loop inside a for loop to determine i and j.
When I write to a cell I do the following…
This let’s me correctly write to a specific cell. For formatting I want to do something specific, so if the cell that is wrong is, for example, D7, then I want D7 to be formatted with a “Red” “Fill”.
My initial idea was to just paste the above argument into the Format Cells activity, however, I get this following error when doing it…
Hope this makes sense, else do ask questions for ellaborations.
Translation of the error code: If Option Strict On is being used, then it is not possible to convert from ‘UiPath.Excel.ExcelValue’ to ‘UiPath.Excel.IReadRangeRef’.
Thanks and have a great day forward.