Excel automation111

suppose we have excel sheet and in that we have dates from 1 to 30
like

1 2 3 4 5 6 7 8 9 10 11 12 13

bot have to extract the todays date column date that means bot have to compare today date in excel and extract the dates date column and write in one excel.

thanks in advance

Hi @Fab_Bucket

Could you please clarify your requirement? It’s not clear.

Thanks

we have an excel file

bot have to compare the today date from system and exract the today date from excel and write in other sheet.
suppose date is 7th bot should get the 7th date data from excel
This is the 7th date data
FRI
7
off
off
off
off
there
i need this output in other sheet

according to today date bot have to get the data from excel and write in other sheet.

Hi @Fab_Bucket

Read the excel using read range & store the the data in datatable variable in this case dt_Main then use the assign activity to get the todays date by using

DateTime.Now.Day

Assign it to int variable in this case TodayDate

Use the filter datatable activity to keep only the todays column data assign the output to dt_Output.

Use the Dt_Output in the write datatable to excel activity to write it to another excel

Hope this helps :slight_smile:

Hi @Fab_Bucket

Thanks for the clarification.

Please find the solution attached.
TEST3.zip (13.0 KB)

Hope it helps.