Update the sheet with weekend condition

[sarvesh.b]

Hello! I want to update this sheet on daily basis, the bot will run at 6pm daily and will fill the highlighted columns by user inputs. But the problem is on weekend.
How to give the condition to BOT to fill the weekend columns in the sheet as in PRESET/ABSENT column there should be weekend and that row should be in grey color. As this BOT needs to be publish on orchestrator and run daily at 6pm.

Please help me to provide a condition to update the weekend rows in a sheet.

Needs to fill this columns.

Update the weekend days like this.

[supermanPunch (Arpan)]

Hi @sarvesh.b ,

I am not sure if I have entirely got the query. However, To Identify Weekend values, you already have a Day Column which will help you decide if the Day is a Weekend or not.

Do you not want to use that Column ?

[shreyash_shirbhate]

Hi @sarvesh.b,

You can simply use the today’s day condition if it is Saturday or Sunday then right down the weekend.

DateTime.Now.DayOfWeek.ToString use this if you dont want to use the column as mentioned by @supermanPunch

For setting the color use below activity:

Set Range Color

[sarvesh.b]

Yes, but how can read that column its getting me a error as column"Day" does not belong to datatable.

[shreyash_shirbhate]

Hi @sarvesh.b,

Are you reading your file from A4 row right?

Please make sure you check the add headers option in the properties panel.

[supermanPunch (Arpan)]

@sarvesh.b , You would Require to Keep the Range as “A4” in Read Range Activity with Add Headers enabled

[sarvesh.b]

Yes, it taking the other columns but it is not reading the day column.

[sarvesh.b]

[shreyash_shirbhate]

Okay it should work, I think you are doing the right things.

[shreyash_shirbhate]

Can you please try row(0).tostring.trim

@sarvesh.b

[supermanPunch (Arpan)]

@sarvesh.b Could you try to Put a Breakpoint after Read Range Activity, so that you can Check the Column Names in Immediate Panel like below :

[shreyash_shirbhate]

Make sure don’t have any spaces in the excel sheet header.

Please check the Day header in excel and remove the spaces if there are any. @sarvesh.b

[sarvesh.b]

Yess bro, It is giving the other column values perfectly. But for days column it is giving me above error.

[shreyash_shirbhate]

Can you please check if there are any spaces? @sarvesh.b

Also please check the columns as recommended by Arpan @supermanPunch.

[sarvesh.b]

Yess , it is showing all the columns.

[shreyash_shirbhate]

I can see the space after the Days

Please remove from the excel sheet then you will be able to read the column values.

Cheers @sarvesh.b

[sarvesh.b]

It works bro, there was a space in days column.

Thankyou for your help friend!

[sarvesh.b]

Thankyou Friend for giving this idea.
It works fine now. Cheers

[shreyash_shirbhate]

You are welcome! @sarvesh.b

Please mark appropriate post as a solution so it will be helpful for other forum members.

Forum FAQ - How to mark a post as a solution

Forum FAQ - How to mark a post as a solution This document is part of our beginners guide. This article will teach you how to properly mark a post as a solution. We were closely following our last UiPath Forum feedback round! topic and carefully extracted all the bits of feedback that was provided. As such, we would like to tackle the topic of solutions on our Forum and how to properly use them. When is the topic resolved? The topic can be considered resolved when the topic author has fo…