If date is today then

Help
1

Hi,

if date is today means i want to select number of 10 in excel sheet .
is it possible?
could anyone help me plz…

image
image1338×594 56 KB

2

You mean you want to select 10 columns because of today’s date is 10 ??

int dayNum = DateTime.Now.Day //will return 10 (10-Dec-2019)

1 Like
3

Thanks @KarthikByggari,

particularly select 10 th column only,
because that is today’s date.

4

@Abubakkar,

Do you have the header as date? Then using read column with that date.

2 Likes
5

Then, get the day number as said in the previous post.
Then convert day number into a equivalent column name.
In this case, columnName - J
Then use Read Range or select range activity with a range "J:J"

Regards,
Karthik Byggari

3 Likes
6

No, Don’t have header of date

7

@Abubakkar

Is it okay to assume that considering the month to be December, there could be columns from 1 1 to 31? In which case, the headers shall be static in the cells, B1, C1, D1, and so on.

Please confirm if this is the case?

2 Likes
8

yes @hacky,
Exactly same

9

image
image795×324 13.4 KB

I got this error

image

just I try to read the column name of today’s date is 10

10

@Abubakkar,

Try like the following by converting the current date to excel column name.
Untitled

1 Like
11

How to read this column name?
column name is 10
today’s date

image
image1248×161 3.57 KB

12

@Abubakkar

Thats perfect!!!

ITS VERY EASY!!

  1. So just read the entire sheet (using Read Range and Add Headers property to be checked) into variable - dtReadRaange

  2. Use filter data table Activity go to “Output Columns” tab,

  3. Select “Keep” and write this → Now.ToString(“dd”)

  4. You can give the input datatable (dtReadRange) and output datatable (dtReadRangeNew)

  5. Now, you have the entire column of the todays date day in the datatable (dtReadRangeNew)

Please mark the answer as “Solution” if you found it useful.

Regards,
@hacky

1 Like
13

Thanks @hacky

but I can’t read column name. frequently get this error

image
image1319×586 37.5 KB

14

@Abubakkar

Please try using the the Read range activity (Workbook) and check.

1 Like
15

getting same error

image
image801×517 22.8 KB

16

@Abubakkar

Try to perform the testing Unit-by-unit to check where exactly is this issue coming.

I dont really think this error is related to Read range

1 Like
17

@Abubakkar,

Try to kill all the excel instances from Task Manager then check again.

Refer this post for the same issue,

1 Like
18

Thanks @sarathi125 @hacky @KarthikByggari

it’s working fine now.

19
20

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.