Filtering by Font Colour (Text Colour)

[Ogunleye_Solomon]

I have an excel workbook, Please note it’s a Read Only file. I want to filter by two columns.

1 Column E contains CL and Column A font color is black.

please see sample file below and expected output.

Thanks

[Jithesh_R (Jithesh Karkera)]

@Ogunleye_Solomon ,
Hey Please check out tis thread .This might help you

How To Filter Excel Column By Cell Color?

How to filter Excel column by cell color ? Approach 1: Filter table activity will filter the column based on the input values only and not based on the color. The workaround to achieve the desired behavior is: Insert a Column in Excel named color (Manually) Get the datatable using a read range activity. Then iterate over the datatable using foreach row. Within the loop, find the index of each row. (index of the row) + 2 will give the excel row number.Using this, the row reference can be obt…

Regards,

[mkankatala (Mahesh Kankatala)]

Hi @Ogunleye_Solomon

1. Drag and drop a Read Range activity onto your workflow. Configure it to read the desired range from the Excel file and store the data in a DataTable variable called inputDataTable.

2. Add a For Each Row activity and set the inputDataTable as the source.

3. Inside the For Each Row loop, add a Get Row Item activity. Specify the column index or column name, depending on your requirement, to retrieve the cell value and color information.

4. To retrieve the cell value, assign the item property of the Get Row Item activity to a variable.

5. To retrieve the cell color, use the following steps:

   a. Add an Excel Application Scope activity.

   b. Within the Excel Application Scope, use the Read Cell Color activity to read the color of the desired cell. Provide the workbook path, sheet name, and cell reference as inputs, and assign the output to a variable.

6. Use conditional logic to check the color value and perform the desired actions based on the color.

Hope it helps!!

[supriya117 (Supriya Allada)]

Hi @Ogunleye_Solomon

Please refer this

How to find the text color in excel cell using UiPath - RPA Learners

Rergards,

[Ogunleye_Solomon]

It confusing.

Kindly assist show a sample out put with the input provided.

Our consideration here is Text colour (font colour) and not the Cell Back colour (Fill colour)

[lrtetala (Lakshman Reddy)]

Hi @Ogunleye_Solomon

1. Use Excel App scope to read the data,then loop through each row of the datatable and get the color of the cell of column RRN lets say “A”(col in excel) using Get Cell color activity. …
2. Use if condition to check the color: …
3. Write this datatable in a new sheet using write range.
   or
   The following thread might helps you
   Excel FILTER By Colour

I hope it helps!!