I am using Read range activity to read a data table containing date fields (dd/MM/yyyy).
- read range using excel
output is : >
- read range using workbook
output is :
I have attached the workflow.Test.xaml (8.5 KB) Test.xlsx (7.9 KB)
- I am expecting read range using workbook to give the output as (dd/MM/yyyy).
- Also Read range of excel is taking more time to execute(when the number of row items is heavy)
assign row(“COlll1”).toString=Datetime.ParseExact(row(“COlll1”).ToString,“MM/dd/yyyy hh:mm:ss”,System.Globalization.CultureInfo.InvariantCulture).ToString(“MM/dd/yyyy”)
I have to iterate the entire Datatable to assign this value, right.
I don’t want to iterate. I just want to know why there is a varying behaviour for these 2 activities.
Please deselect the option called “PreserverFormat(Slower) in workbook & PreserveFormat in Excel” Read range to avoid the date formate problems.
Please do let us know if you find any difficulty.
When I am removing the preserve format option, getting the date field as MM/dd/yyyy hh:mm:ss
Is it possible to get the date field always in dd/MM/yyyy ?
The region and data format for system is already set as dd/MM/yyyy
Ideally, it should read the date field from excel in the same format as configured in the system configurations.
Sorry for the delay in my response @MariaJosephina.
I am exactly not sure about why this is happening because my side is working fine Excel.
I will look into that.
for your requirement, As @AshwinS2 already mentioned, Converting date format is the only option for now.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.