Hi Everyone,
Is anyone know how to validate the cell background color of the uploaded excel file
For example, I have an excel file with the red background color of the cell C2
after clicking the upload button the server action will validate the cell if the background is red then true if not false.
Take note: I used an advanced excel extension.
I'm not sure if I am using the correct server action.
Thank you in advance
Hi Ruzzel
The action you used will give you the conditional format rules and not the evaluated result (whether the cell is red or green). If you refer to the description of that action, it says "Get a list of all the conditional formatting rules in a worksheet. "
I don't believe there is a way to achieve what you want with the current implementation.
Hanno
Hi Hanno
Yes, I think what I want is not achievable in advance excel.
Thank you
Hi Ruzzel,
I'm not sure if it is possible to check a cell background color through the Service Studio.
Perhaps you can implement a action with the Integration Studio.
This cell contains dates like in the image you posted?
The red background means that is a overdue date?
If yes, can't you check the value of the cell instead its background?
The date is the work schedule of the employee
The red background means that the specific schedule is a peak day.
So once I upload a work schedule with red background cell color.
The value will be:Employee Number: 0-101Employee Name: JohnDownWork Schedule: 2022-09-01IsPeakDay?: True