Excel automation111

Help Studio
, ,
1

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

2

Hi @Fab_Bucket

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

Thanks

3

we have an excel file

image
image814×260 5.23 KB

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.

4

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

image
image606×656 26.9 KB

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

image
image1488×622 50 KB

Hope this helps :slight_smile:

5

Hi @Fab_Bucket

Thanks for the clarification.

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

Hope it helps.