Abubakkar
(vnrabu)
November 27, 2019, 9:57am
6
How to take the column name (DATE) from the excel?
Manohar1
(Adicherla Manohar)
November 27, 2019, 9:57am
7
@Abubakkar
Inside For each row
use Assign activity and include the Column Date in it.\
columnDate=DateTime.ParseExact(row(“column name”).ToString(),“MM/dd/yyyy hh:mm:ss”,System.Globalization.CultureInfo.CurrentUICulture.DateTimeFormat)
In row(“Column name”) give your date column name
now use if condition and do compare of
current date=columnDate
Manohar1
(Adicherla Manohar)
November 27, 2019, 10:06am
9
@Abubakkar
can you please post the screen shot of date column in Excel
1 Like
Abubakkar
(vnrabu)
November 27, 2019, 10:07am
10
this is my excel column name date
only for number digits
omprasad
(Om Prasad)
November 27, 2019, 10:08am
11
Please Check This
Thanks & Regards
Om Prasad
1 Like
Abubakkar
(vnrabu)
November 27, 2019, 10:31am
14
Thanks for the help @Manohar1 .
How can i find column name date is 27 ?
i need current date till record only in excel sheet
rest of the 28,29,30 column name date is should be removable
row(“Date”).ToString=currentDate is that ok?
sarathi125
(Parthasarathi)
November 27, 2019, 10:39am
15
@Abubakkar ,
This will give your current date as “27” string.
System.DateTime.Now.Date.Day.ToString
1 Like
Manohar1
(Adicherla Manohar)
November 28, 2019, 4:53am
16
@Abubakkar
in place of row(“date”).toString use row(“currentDate”).toString
1 Like
Abubakkar
(vnrabu)
November 28, 2019, 4:59am
17
Thanks @Manohar1 .
How to read column name ? that date is in number format
Manohar1
(Adicherla Manohar)
November 28, 2019, 5:02am
18
@Abubakkar
While using Read range activity click on add headers property it will include the first line as headers.
1 Like
Abubakkar
(vnrabu)
November 28, 2019, 5:06am
19
yeah, I clicked on add headers property
Kindly try with this expression in this assign activity inside the for each row loop
Columndate = row(Now.ToString(“dd”))
Cheers @Abubakkar
1 Like
Abubakkar
(vnrabu)
November 28, 2019, 5:13am
24
Thanks @Palaniyappan
but i can’t compare this column name and current date
i want to compare in this column name todaydate (28) and current date (28)
May I know why
@Abubakkar
1 Like