How to extract colored cell value in an excel

Help Studio
, ,
9

@Chandini_Roy It is work well. Its clear color cells. ıf you want you can clear just white cells

The image shows a UiPath workflow that reads data from an Excel sheet into a DataTable ("dt"), logs the row count, and assigns the row count to an integer variable ("RowCount_int"). (Captioned by AI)
The image shows a UiPath workflow that reads data from an Excel sheet into a DataTable ("dt"), logs the row count, and assigns the row count to an integer variable ("RowCount_int"). (Captioned by AI)1212×697 32.8 KB

The image shows a list of variables in a programming interface, including their names, types, and scopes. (Captioned by AI)
The image shows a list of variables in a programming interface, including their names, types, and scopes. (Captioned by AI)847×170 7.27 KB

This is a screenshot of a UiPath workflow that iterates through each row in a data table, logs row details, and retrieves the color of specific cells in an Excel worksheet. (Captioned by AI)
This is a screenshot of a UiPath workflow that iterates through each row in a data table, logs row details, and retrieves the color of specific cells in an Excel worksheet. (Captioned by AI)790×810 31.3 KB

A UiPath workflow for iterating through Excel cells, checking their color, and logging messages based on the results. (Captioned by AI)
A UiPath workflow for iterating through Excel cells, checking their color, and logging messages based on the results. (Captioned by AI)790×810 36.6 KB

The image displays an automation workflow process in UiPath, involving a conditional check for a specific color, logging an error message if not met, and managing data within an Excel file including deleting specific rows. (Captioned by AI)
The image displays an automation workflow process in UiPath, involving a conditional check for a specific color, logging an error message if not met, and managing data within an Excel file including deleting specific rows. (Captioned by AI)790×810 35.4 KB

This image shows a UiPath workflow for processing an Excel file that involves deleting specific rows and updating the row count. (Captioned by AI)
This image shows a UiPath workflow for processing an Excel file that involves deleting specific rows and updating the row count. (Captioned by AI)790×810 30.9 KB

Main.xaml (26.0 KB)
Data.xlsx (9.4 KB)