I want to get the date value from the excel cell.
The excel cell contains =Today()
I need the value as “08/28/2019”
Is it possible ??
Means excel cell value contains today() right so read the cell and compare with if activity if value eqal to today()=“today()” then use this syntax to get date Datetime.now.toshartdate()
We can use READ CELL activity
Didn’t that work
Cheers @RachelN
@RachelN
Use Read Cell Activity It will give you Only date even You Are Using Today(). but the format Of Your Cells Must be DateTime.
Every cell the formula ill vary @kalyanDev
Am using read cell only, but the output of today()-30 is coming as 43675
@palaniyappan
I gave the output variable of read cell as system.dateTime only, but when i use write line to display the value i gave as outputvaiable.ToLocaltime.Tostring
It is giving a error as “message”: “Read Cell: DateTimeConverter cannot convert from System.Double.”,
If You are getting the OutPut Like 43475 Then This Is In OA ForMat You can Convert It into Date Time Using System.Datetime.FromOADate.
I cant download zip. can you please send it as xaml file.
Please find below
Main.xaml (6.5 KB) Sample.xlsx (8.6 KB)
am not having excel installed in my system.
Am using workbook only.
When i try this code.I am getting the output as “MM/dd/yyyy” instead of today’s date
@Suman7
Anyone please check my xaml file and let me know the mistaketest.xaml (5.3 KB)
Hello @RachelN
Just Simply use Replace Method and assign this code to the string datatype variable StringVariable.Replace(“Today()”,Now.Date.ToString(“dd/MM/yyyy”))
It’ll replace the Value Today() with the current days Date
Check this workflow for better understanding
Today().xaml (4.8 KB) Today().xlsx (9.5 KB)
Thanks for your reply.
But in the excel sheet the input is fefeToday().
I want the Today()as formula. So in excel sheet the formula should be =today() and the value should be “08/28/2019”
Please check for this @vickydas
getting output as 43675 @vickydas
Hello @RachelN
Type this code in an assign Activity
Date.FromOADate(StringVariable)
and assign it to datetime Datatype Variabe
Check this workflow for better understanding
DT.xaml (4.9 KB)
2 Likes
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.